Runtime Report source

[~Phil~]

I am developing some Crystal reports V10 that are to be called from ASP.NET page. The reports are loosly attached i.e. the report name together with path (C:\deploy\reports\report1.rpt) is passed to the CrystalViewer.reportsource at runtime, my quiry is that these reports call SQL stored procedures which return the data, however because I build the reports on the development machine, and the path and possibly and servername are different on the production machine how can I use my reports?

[dilemma]

Try puttint it in same folder of your page. Do not specify full path just report name is good enough. This should I guess.

Thanks

[dilemma]

Rememeber you need to delete existing connection information first using DeleteAll() function followed by Add("Data Source","newServerName"), Add("User ID",newUserId) etc... stuff.. which way at runtime your code resets existing connection information of the report which CR stores it at design time. Once done at runtime your code uses new connection info where Data Source = ServerName plays major role. Remember , ServerName may not work you may have to try putting ip address instead. Use CrystalDevHelp document of CR10. I will give your appropriate URL. Look for "change of data source" which will tell exactly what you are looking for.


Thanks