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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Parameters Ignored in CrystalReportViewer

Status
Not open for further replies.

SHelton

Programmer
Jun 10, 2003
541
0
0
GB
Using CRXI in C# (VS2005), Vista Home Premium, SQL2000.

I have a very basic report with 2 parameters - if I run the report in CRXI I get prompted for the parameters and the report shows the correct data. Viewing the query in SQL Profiler shows the correct WHERE statement.

However, if I open the report (or any report) from a C# app and view it in a CrystalReportViewer, the parameters are ignored and all data is shown. Viewing the query in SQL Profiler shows that there is no WHERE statement.

This problem occurs whether I pass the parameters to the report object programmatically or allow the report to prompt for them at runtime.

Any help greatly appreciated.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top