Community
Participate
Working Groups
Build Identifier: 20090920-1017 I would like to be able to conditionally set if a dataset is run. Suppose I have 3 data sources and 3 datasets for each one of them. I'd like to display only the datasets related to one data source based on a parameter. This could be done with visibility condition but the datasets that are not visible STILL are executed. Thanks! Reproducible: Always Steps to Reproduce: 1. Create a new report. 2. Create 2 or more datasources 3. Create at least one dataset per datasource. 4. Add distinct datasets to report as tables. 5. Conditionally "hide" tables based on parameters. 6. Even though tables are hidden, the datasets are still executed
this could solve this issue too http://www.birt-exchange.org/forum/designing-birt-reports/12899-compute-sums-grid-2.html#post60283
This depends on how engine execute the invisible report items.
actually you can change the report design handle in the onPrepare script.
(In reply to comment #3) > actually you can change the report design handle in the onPrepare script. how so?
Created attachment 168316 [details] Sample of switching the dataset through script In the design, there are two data set: dataSet_A and dataSet_B. Data Set A queries all the employees with job title as "Sales Rep". Data Set B queries the employees which jot title is not "Sales Rep". There is also a boolean parameter "IsSalesRep". If this parameter value is TRUE, the report design uses the DataSet_A, if it is false the design uses the DataSet_B.
just what I was looking for.... Thankyou very much!
