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.

This is really a superuser question more than a programming one. A programmed solution using CR can set up data any way it wants. — Mike Burton
I'm also asking how to do it, if possible, on crystal reports, which by my understanding it can't be done. you seem to know how could you please answer? thanks. — sergiogx

Conrad Frix Conrad Frix · Accepted Answer · 2010-06-08T18:39:30

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

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

1 Answers