Jump to content

BIRT Developer Center Download


File Information

  • Submitted: Jun 28 2013 01:33 PM
  • Last Updated: May 01 2014 12:00 PM
  • File Size: 20KB
  • Views: 19148
  • Downloads: 183
  • Approved by: mwilliams
  • Approved on: 01 May 2014 - 12:01 PM
  • Summary: This example sets a default value to select all parameter choices. This is done by modifying the query that is executed with script.
  • Content Type: Designs & Code
  • BIRT Version: 2.2

Download All Parameter Values

- - - - -
Parameters All Choice Select All

This example report has two datasets. One is tied to a report parameter. This report parameter has a default value of All Customers. The second dataset is displayed in the report. In its beforeOpen the query is modified based on the parameter selected.

Very cool - now if I could just get it to work on my data.


I can replicate this to varying degrees using the ClassicModels sample database but am having issues getting it to work with my data and I suspect it's the beforeOpen script.


Here's my modified version:

category_Param = "'" + params["Category"].value.join("','") + "'";
if (category_Param.match("(All)") == null){ 
this.queryText = this.queryText + " and CATEGORY IN (" + category_Param + ")";
I've also tried it with the schema.tablename in front of the CATEGORY field name in the last line but to no avail.
Any thoughts appreciated.

Hi Jason,


I am trying to use the report provided but the reportdataset does not seem to pull the values selected from the Data Set. I am using BIRT 4.2


Any ideas?




Other files you may be interested in ..

  • 997 Total Files
  • 8 Total Categories
  • 153 Total Authors
  • 31706 Total Downloads
  • Joyplot in iHub Latest File
  • Clement Wong Latest Submitter

0 user(s) are online (in the past 1 minutes)

0 members, 0 guests, 0 anonymous users