Crstal Reports Problem

[Bruce Wiebe]

Hi all

I have developed a windows application (VB.net) that uses a web service
on a remote machine as a datasource. through numerous web service calls
it extracts data from a sql server and saves this data into a number of
xml files on the local machine, These xml files are then pulled into a
Crystal Report. the thing that i am having problems with is that when i
try to deploy the application it keeps asking me to provide login
details to the xml files and as far as i am aware the xml files dont
have any login details

Does anyone have any idea how i can get round this so my customer can
start printing reports

any help would be most appreciated

Thanks in advance

 

[CJ Taylor]

I was just reading a crystal hotfix list today and almost swear something
like that was involved.

Alright other things to check, your xml files, what are they set to in the
report? Crystal is a bit of a pain when it comes to setting datasources,
especially Crystal.NET

Are you using Crystal.NET or Crystal 8 or 9?

Also, did you run the proper setup project for Crystal (i.e., did you deploy
it correctly?)

-CJ

 

[Bruce Wiebe]

Thanks for the reply

Im presuming its crystal.net its the one that comes with visual studio
2003

As far as im aware the reports have been deployed properly correct merge
modules and keys etc

The XML files are added to the report my using add database and then
ADO.NET(xml) under more data sources

They work fine at design time

 

[CJ Taylor]

Hey Bruce,

Arlight, lets go with this. So you are using Crystal.NET, ok, now your XML
data sources, are they the same on every machine?

Otherwise you have to change it progamtically, which may mean that it
couldn't find the XML datasource which is why it was asking you to log in.
The XML itself wasn't asking you to log in, but the OLEDB driver was. Who
knows why. I'm assuming it oculdn't find it.

-CJ

 

[Bruce Wiebe]

Hey cj

Once again thanks for the reply

The thing thats getting me is that all the xml files are there in the
same directory as the report and they crystal system does not even
connect to the original datasource as it is physically miles away. it is
connected to by a web service and the i call the writexml method of the
dataset to create the xml file.

So yes the XML files are the same on every machine well they contain the
same format however the data in each one will change as the reports are
designed to print invoices

Thanks again for your help in this ive been pulling my hair out for days

 

[CJ Taylor]

Hey Bruce,

Alright, working through this. Now I'm trying to understand who is writing
the XML file, the Web Service? or the client consuming the web service?

Reason being that doesn't the client application have a choice on where its
installed? Or are you hardcoding a value of where this XML file is written
to?

-cJ

 

[Bruce Wiebe]

Hi CJ

The process of getting the xml files goes like this

1. The Web service running on the remote machine retrieves the data from
the remote database and returns a dataset to the program. i then copy
this to a local dataset and use the writexml method of the localdataset
to write the xml file to the local hard disk, this is all done without
any interaction with crystal at all.

2. The Crystal report is then loaded and is supposed to use these
written xml files as the source for the report

This problem only seems to occur when i am am accessing reports with
multiple xml files as source files for the crystal data as i have other
reports in the same application that only use one xml file and they run
fine

Thanks again for your help im slowly going mad over this one