Multiple Users at Same Time

[ddnh]

I currently have CE 9, but will be upgrading to 10 very soon. I have multiple reports that will be pulling from two databases. One is a SQL Server, the other is another application. Data from BOTH is necessary for most reports. Our idea was to create an xml file for each user request (the xml file would be data combined from both DBs). This would be easy if there were one user. I can create a system DSN and use the xml file as the datasource. What can I do for multiple users? Seems as though we have to connect to multiple datasources on the fly. Is this possible? I need multiple users to use the same report at the same time...each entering their own parameters. HOW DO I DO THIS? We don't currently have any CE documentation, and I am not finding enough info in my old CR 9 book or on the web. Any suggestions would be very helpful.

 

[IdoMillet]

Why not access both data sources in the same report? Crystal can do that. If this is not viable for you, consider using SQL Server to link to the external tables or use SQL Server DTS to import the data from the other application into SQL server tables (at a frequency high enough for your purposes).

hth,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[ddnh]

the "other" non SQL data source has hundreds of tables without primary keys. so we're trying to avoid re-doing it. if we can create the data source on the fly, based on parameters, it would be much easier. we just need to know if it's possible.