ASP.NET report viewing error

[cogentdev]

Hi am using the report viewer in asp.net to view crystal reports. In my dev enviroment everything is working fine, when I change to a differnet DB server all the reports with parameters fail with the following error

Error in File c:....Reports\ChartReportClientDoctor.rpt: Error in formula <Record_Selection>. '{spCRClientData1;1.admissionDate} = {?admitDate}' This field name is not known.

If I point this server at the dev DB it works fine, but it doesn't work on the production DB at all. I am using SQL server. The reports that do not us a parameter work fine.

 

[vidru]

Do you get any errors if you point the report to the production server at design time?

-dave

 

[cogentdev]

if I point my dev machine at the production db I get the same error

 

[vidru]

Check the output of the stored procedure on the production server, and compare it to the one on the development server. Good chance that the fields returned aren't the same, namely the admissionDate field.

-dave