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.
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.