Report Parameter based on data set value

phlyer · 2016-07-12T06:31:21+00:00

Hi, I'm currently trying to generate a report parameter (boolean) based on the value of a data set column (string), which only has one row (string). So what I was starting with, is the following script in onFetch of the data set: // onFetch if(row["typ"] ==…

phlyer

Hi,
 
I'm currently trying to generate a report parameter (boolean) based on the value of a data set column (string), which only has one row (string). 

So what I was starting with, is the following script in onFetch of the data set:
<pre class="_prettyXprint">
// onFetch
if(row["typ"] == "JOU") {
reportContext.setPersistentGlobalVariable("multipleUser", true);
}</pre>
The report parameter itself is a boolean checkbox and in getDefaultValueList I want to catch the variable:
<pre class="_prettyXprint">
// getDefaultValueList
reportContext.getPersistentGlobalVariable("multipleUser");</pre>
As I am quite a beginner in JavaScript I am not sure if this is right and am hoping for some help regarding the code or even if my idea to do it like this is wrong.
I've seen in other posts that while generating the report with a parameter window, onFetch and getDefaultValueList are used more than once, but since I am only setting a value in one and retrieving it in the other, that shouldn't have an effect, right? 
Thank you in advance and best regards!

Find more posts tagged with

Comments

Matthew L.

Based on the requirements you mentioned, the Boolean+Check Box parameter option does not have a Dynamic option.
This causes the solution to become more difficult than it would seem.
The reason that the current code you provided doesn't work is because the "Data Set" never get's executed before the Parameter Screen appears (order of how elements execute).
Therefore the setPersistentGlobalVariable() does not contain a value to set the parameter.
 
To work around this, we can manually execute the Data Set using some complex BIRT Design Engine JavaScript.
I've attached an example that will replicate the behavior you are wanting.
You should be able to "Copy and Paste" the code in the examples parameter's "getDefaultValueList" and place it in your own report parameter.
Then you should only need to change the first line in the code for the Data Set Name where your data is located.
<pre class="_prettyXprint _lang-js">
//Change "Scripted Data Set" to your Data Set Name
var returnValue = QueryDataSet("Scripted Data Set");
</pre>
Hopefully this help.
If you have any questions, please let me know.

KumarSaurav

Thanks Matthew L. This solution helped me also in my project.

phlyer

Hi Mathew,
 
this actually helped me a lot. Thank you very much. I just had to change one thing, maybe I explained it wrong earlier, but if someone else has the same problem:
 
The dataset I am handling has quite a few columns but only one row, so I only needed to change the following line in your script for "getDefaultValueList" to look in a specific column:
<pre class="_prettyXprint">
var myVar = ri.getValue("typ");</pre>
Thank you again!

Matthew L.

Great, I'm glad this solution works for you and that you could look through the code and make the correct changes according to your report requirements.