dataset > XML >Crystal

TPM

Well-known member
Joined
Dec 7, 2004
Messages
623
Location
CA
Programming Experience
3-5
Hey guys
I have a problem, I want to get live data from a DB to a remote user for use in a crystal reports viewer. ATM I have the remote server query the DB and return a dataset which the user saves as an XML file. Crystal can use XML files for it's reports BUT it needs (as far as I can find) an ODBC DSN to access it. As this will hopefully be a distrebuted app. I'd rather not use a DSN (at least not a system or user DSN). Any one have any ideas as how to get around this problem?
This is driving me nuts! Any help would be apreciated!
TPM
P.S. I don't want to directly access the DB for security reasons.
 

MrProgress

New member
Joined
Feb 19, 2005
Messages
2
Programming Experience
3-5
Hello,

Instead of using the XML file directly, what about reading that XML file to a Dataset and Sending data to Crystal in that XML. I always prefer using Typed dataset for Crystal Reports for increasing speed.
 

TPM

Well-known member
Joined
Dec 7, 2004
Messages
623
Location
CA
Programming Experience
3-5
Wow a reply! Yes I had thought about using the dataset, but I was having some trouble with that as I'm using crystal 9 (not the inbuilt). I haven't worked on this for a while, I'll have to go back and relook at it. I had started on a custom control, but a more pressing project came up... You know how it goes.

Thanks again for the reply

TPM
 
Top Bottom