JoanHerrick
asked on
SQL Reporting Services and Informix database
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.
Thanks!
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.
Thanks!
ASKER
When I do that, it works fine. That's what makes me think there's something about the parameter that's a problem.
Do you know what datatype the field is? is it varchar or integer?
I don't know much about reporting services but perhaps you need to define the correct datatype for your parameter.
I don't know much about reporting services but perhaps you need to define the correct datatype for your parameter.
ASKER
Yeah, I've tried using both integer and string and neither one seems to work.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I'm not exactly sure about this because I haven't had time to research it, but I think you're right. I awarded the points because I didn't want to leave it hanging plus you were the only one who responded to me. Thanks!
i.e.
select * from view where pr_no = 189
or if it's a string
select * from view where pr_no = '189'