Skip to Content
Former Member
May 16, 2008 at 04:06 PM

Dynamic Parameter causes Datasource prompt


Post Author: ecathell

CA Forum: Data Connectivity and SQL

I have done a lot of searching for this problem, and though I have found similar issues, none "fit" mine exactly.

First: Crystal Reports 2008 connecting to a DB2 database. This report is being deployed to a website using the Viewer control in The webserver has the same DSN(ODBC) connection that my development computer has.

Previously I had all static parameter in my report, and it was working correctly, my code was allowing the report to get access to the DB2 databases and pull the information it needed without any input from the end user. Once I added a dynamic parameter(it is using the same tables that are already in the report currently) it started prompting for access information. I have tried several ways in my code to combat this, but nothing is working. Is there some other procedure that needs to be done to fix this?

I do notice that the datasource that is listed for the dynamic parameter uses the table name as the root instead of the actual dsn connection. Is this a bug?