Link to home
Start Free TrialLog in
Avatar of JoanHerrick
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!
Avatar of nmcdermaid
nmcdermaid

Can you try it without the parameter and see if that is causing the error.


i.e.

select * from view where pr_no = 189


or if it's a string

select * from view where pr_no = '189'

Avatar of JoanHerrick

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.
Yeah, I've tried using both integer and string and neither one seems to work.  
ASKER CERTIFIED SOLUTION
Avatar of nmcdermaid
nmcdermaid

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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!