Run Report Pop up is not fetching data.

Hi,

I am using BIRT version 2.2.1 for designing Reports.I am designing Report with both SQL and Oracle database.

First i designed a report using SQL datasource and added few parameters with display type Text Box,List Box,Combo Box and Radio Buttons.when i genearted the report values got populated in the List boxes for all the parameters.

Then i changed the datasource of the report to ORACLE and tried generating the report.Report got generated without error but when selecting the pop up through Run Report the list boxes are not getting populated.Its showing only the Default value.

When I chcked the parameter results in Data Set for that particular List Box its showing binding error.Previously i was using same report for both SQL and ORACLE.But in this version i m facing this problem.And the same is happening when an ORACLE report is changed to SQL datasource.

Attached the snap shots along with this.

Regards,
A.Rasheedh

Find more posts tagged with

Comments

mwilliams

Hi A.Rasheedh,

The returning only the default or last selected value issue sounds like a caching issue. Running a dataSet for just the parameter and then one to be limited by the parameter value is a way to make sure all values always show in the parameter box. You may have already solved this issue though. Not sure why it would matter switching between Oracle and another type though.