nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Interactive report filter value selection

mehdiesteghamat

hi All,
 
I am just trying to use BIRT 2.3 to implement an interactive filter selection where users can pick a field of the report from a dropdown no. 1 and select a value for it from a second dropdown no 2.
 
I'd like everything to be done inside the report template using scripting. Is it possible for a page to interact with users in this manner. 
 
Please let me know.
 
Thank you,

Find more posts tagged with

Comments

JFreeman

You should be able to accomplish this using text elements with HTML/Javascript to create the drop downs and then rerun the report by passing it parameters from the values selected in the drop downs.
 
Take a look at this example, it does something similar to what you are wanting: <a data-ipb='nomediaparse' href='http://developer.actuate.com/community/forum/index.php?/topic/29016-adding-new-drop-down-in-birt-report-and-changing-query-parameter-based-on-value-from-dropdown/?p=134361'>http://developer.actuate.com/community/forum/index.php?/topic/29016-adding-new-drop-down-in-birt-report-and-changing-query-parameter-based-on-value-from-dropdown/?p=134361</a>
 
On a side note, BIRT 2.3 is really old at this point and I would recommend looking towards upgrading to a newer version.

mehdiesteghamat

hi Jesse,
 
I checked that which was helpful.
 
But, I need to populate the drop-downs dynamically like cascading parameters; but it is supposed to be different because in my case the first drop down is the list of final report columns which I would like to filter the results based on. After users selects the filtering column, I need to need to populate the second drop-down with list of the distinct values for the previously selected column meaning that I need to
 
1) re-run the report 
2) get the object for the dataset and pass a "select distinct" to it.
3) when I have all the distinct values, I should be a able to create the html options for the drop-down;
 
however, I do not know 
 
1) how/when(which event) I can access the dataset and I can iterate over the rows. (I just use getDataset of a table handle using the Dataset but have no clue how I can get the current row during fetch time from the dataset)
2) when/where I should create my html options provided that all values are available from the previous step.
 
and Just one final question:
 
1) If I use a Text to run my scripts when are the executed in the report process pipline (i.e. onPrepare, onCreate, onRender, etc.)
 
Thanks in advance,
 
Soosho

mehdiesteghamat

The issue is that I am limited to insert html during presentation phase (onRender), if I want to use regular BIRT datasets.

JFreeman

There are a couple of options for iterating over the rows in the data set.
 
When the report is running, you can have code in the data set events beforeOpen and onFetch to read the rows as they are created and then use some logic to create a persistent global variable with an array of the values you want available later on.
 
Alternatively, you can also use the Design Engine API to to manually run the data set and then iterate over the rows.
Take a look at the example in this post: <a data-ipb='nomediaparse' href='http://developer.actuate.com/community/forum/index.php?/topic/35930-running-a-query-in-the-initalize/?p=133369'>http://developer.actuate.com/community/forum/index.php?/topic/35930-running-a-query-in-the-initalize/?p=133369</a>