Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Being prompted for parameter value when....

Status
Not open for further replies.
Aug 27, 2003
428
US
I need to change the data source to Test for my report on CE 9. Currently it has a datasource as Prod and it runs fine without prompting for parameter values.

However, when I change the datasource to Test, I am being prompted to enter values. I have no idea where the paramters came from. The procedure that generates the data on the report itself does not contain any parameters.

Dis anyone have this issue before?

Thanks in advance!
junction123
 
Check and see if the source RPT file has any sub-reports, and if those sub-reports have parameters.

You may have only done the "SET LOCATION" of the Main report to the TEST server, but the sub-reports are still pointing at PROD.

Hope it helps....
 
Actually, all I had to do was click on verify database and bring it up to date. Thanks anyway.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top