I created a report in Reporting Services (Sql 2000) that queries an Informix database. The dataset selects data from a view (Command type = text) and passes a parameter. The query works fine in VStudio designer, but when I publish the report to the report server, it fails. I believe my connection is fine on the report server because when I define the parameter in the report as a certain value, it works. It's just when the user enters a value that it bombs out.
Here's the error:
An error has occurred during report processing. (rsProcessingAborted) Get Online Help
Query execution failed for data set 'DataSet1'. (rsErrorExecutingCommand) Get Online Help
IErrorInfo.GetDescription failed with E_NOINTERFACE(0x80004002).
I have noticed that when the user enters a parameter of value 00000189, the report dumps all the zeros and shows only 189. I don't think this is the problem though because when I enter 189 in designer preview, it works fine too.
Here's my Dataset query:
select * from view where pr_no = ?
Any help you can give is appreciated.