Modify the Dataset by Script

There are instances in which you would like to modify the dataset query based upon parameter values, either the first value which may be "All Values" or just one parameter value. 

The following script worked for me: 
var paramSelect = reportContext.getParameterValue("OptionParameter");
var selected = "'" + paramSelect + "'";
 if(paramSelect != "All Options"){ 
this.queryText += " and table.field = " + selected ; 
}

I discovered that you cannot add the single quotes for the selected in the this.queryText string, such as:
this.queryText += " and table.field = ' " + selected + " ' "; // this does not work

 It works when you add the single quotes in the variable as above.

Comments

Post a Comment

Popular posts from this blog

Installing Birt Reports

Each time I need to install Birt Reports designer on a new machine I seem to forget the various elements needed. First off - you do not need to install the Eclipse program.  All you need is the version of the Birt reports designer that is compatible with whatever software you are associating the reports with. In my case I needed version 4.8 (as of July 2021).  This is because the program being used was only approved up to version 4.8. The following link was helpful in dealing with when you get the java exit code 13 when trying to start Birt https://appuals.com/fix-java-was-started-but-returned-exit-code13-eclipse/ For installing Birt version 4.8 you need the following: The latest version of Birt 4.8  birt-rcp-report-designer.   https://download.eclipse.org/birt/downloads/drops/     Check the date on the directory link.  At this time I selected  I-R1-4.8.0-201905212138 .  Because I had previously selected an earlier version it would not r...
Read more

Global Variables

Image
 I had a report where I wanted to pass the values from one table to another so that I could do a calculation.  What I did was create a global variable.  Following is the process I took to do so: Initialize your global variables On the report level, using Scripting select the Initialize method Use the  reportContext.setPersistentGlobalVariable("variable_name", "variable_value")  function for initializing the variable Populating your variable with the value in the report Select the element in the report that will have the value for the variable and then go into the Scripting tab:
Read more

Display Parameter Text

   Parameters usually provide the option to put two items in a drop down list, the value and the description of the value.  If you want to grab either of the two items to put in a report, say the header, the reference to either of the two items is as follows: Displaying the parameter list item value:    params[" your_parameter_name "].value Displaying the parameter list item description:    params[" your_parameter_name "].displayText
Read more