Thursday, March 29, 2012

Failed to open a rowset Warning/Error

Hi there

I am working in CR 9.0 and have included subreports in the main report.

Whenever I run the main report and have to give the Login ID & password for the " HiT ODBC / 400 Driver" (DataSource - AS400) I get the following warning/error.

"Failed to open a rowset.
Details: HY000:{HiT][HiT ODBC/400][SQL/400][ODBS Error][SQL0128] Use of NULL is not valid"

If I click the OK button the report is generated.

If I run the same report the second/third time - where I do not have to specify the Login ID & password the error/warning does not occur.

How do I get rid of this warning/error msg.

rkpYou need to pass them in the Front End coding

No comments:

Post a Comment