Crystal Reports alternative that can use db connection on web.config?

Question

Crystal reports isn't working on different servers because they use different connection strings and crystal reports can't use the connection string stored on the web.config to access the database.

Is there an alternative to crystal reports that can use the connection string on the web.config file?

or does someone know how to fix the problem using crystal reports?

thanks.

Answer 1

You can use the Crystal Reports API to modify the connection prior to rendering the report.

UPDATE:

Here's an example that uses the ASP.NET 2.0 CrystalReportsViewer control example in VB.NET