How to test BIRT Reports with a mock Excel Datasource

hi, I have a BIRT report that uses JDBC Datasource to populate data to a DataTable. I have bound the table to the Dataset. The detail row of the DataTable uses the DataSet directly to show DB data in the reportNow, I want to use an alternate Excel Datasource to populate the report in the testing phase. But, what i find is that, I'm not able to change the Datasource of the existing Dataset from JDBC DataSource to Excel DataSource.. I think, one option is to create a new DataSet for the Excel DataSource, bind the DataTable to the new DataSet and rely on Column Bindings on the DataTable to populate the detail columns of the report, instead of using Dataset directly. Disadvantage is the need to switch the Dataset bound to the DataTable. I would like to if this is the correct way of using Mock DataSource? Is it possible to use a Mock DataSource and at the same time reuse the existing Dataset for testing..Thanks,
Vishnupriya

Find more posts tagged with

Comments

kclark

Take a look at <a data-ipb='nomediaparse' href='http://birtworld.blogspot.com/2008/05/birt-swapping-data-set-at-runtime.html'>this blog post</a>. it should be good enough for what you're trying to do. It shows how to swap data sources/sets for testing vs production.