please help:Can't load report query

pratim

Hi,

I am using BIRT 2.3.2.

If i run a report for a certain duration of time which is invalid, for which there is no data in the database BIRT viewer gave me an exception saying "Sql statement does not return a result set object". Example, i run a report at 9am in the morning asking the report to show me data for 10am to 11am, then this exception through up.

However after deploying the BIRT report engine in Application, for the same invalid period Report shows an error message at the bottom of the report saying,

"The following items have errors:

Table TopNApplications_Table:

+ Can't load the report query: 1195. "


From this behavior i can feel that there is an exception from the database side and Report is displaying the error at the bottom of the report.


I would like to know, whether there is some workaround to avoid this error other than handling the exception at database level? Because anyhow my reports are displaying "No records for the table" if the aggregation of row count in the table is zero.


regards,

Partha

JasonW

Can you try this with 2.5.2 to see if you get the same error?

Jason