Pageserver in Crystal 8 to run reports from multiple datasources

[JordanCN]

I have set a SQL 2000 server with Seagate CR PageServer installed and serving my crystal reports. The SQL server has two databases with the exact same format however the data in the dbs is for two different companies.

I would like to not have to create the same report for both companies so I was wondering if there was a way to change the datasource for each report on the fly by passing parameters through the web links.

I know that when I setup parameters for the report I can automatically feed the parameters like so:

http://mydatabase/CrystalReports/myreport.rpt?prompt0=mystring&submit1=View+Report

Is there some sort of command I and inject into this like to tell the report to use the database COMPANY-A or COMPANY-B on the SQL2000 server?

 

[Turkbear]

Hi,
As far as I know, the datasource is not dynamically alterable in any version of CR and most certainly not in one that old.

If SqlServer databases can link to each other ( like Oracle's DB links) then you could try building a stored procedure or view in one of them that, given a parameter, will use it or the other database - that way the connection needs to be just to one database.





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[JordanCN]

In the runtime engines it is definetly configurable because we have an application that has always used crystal from 5 right up to 11 R2. The back end data can be named whatever we want, where ever we want.

When you open the .rpt files in the program's folder you can see that they were written to pull from one of the vendors servers because if you run it just in the develpment window it bombs out saying that it can't find the server. However when you run that report through the app it passes the location of the data to the report.

The question is can this also be done via the Seagate Crystal Report Pageserver as well.