Multi select cascading parameter

There is one more issue:

In a report that i designed, has single parameter, but multi select. The data set for the report table gets the values by executing a stored procedure in the DB which has the above as the parameter. Since the parameter is a multi select, users can select multiple values for the parameter. The query in my data set is like this

exec schema.storedProcedure @Parameter = ?

This works fine when i have a single select parameter, but when i am trying to associate a report parameter, which is multi select, i get below warning (see screenshot), and as mentioned it takes only the 1st value.

If is use, filters, i get the error saying the parameter is not set.

How am i suppose to send the multiple data selected as the parameter to my stored procedure??

Avinash

For the ability to select multiple values at all levels of the cascading parameter, you might take a look at this devShare post: http://www.birt-exchange.org/org/devshare/designing-birt-reports/1477-allow-multi-value-for-cascading-parameter/

For the other issue, when using a multi-select parameter, you'll need to split the values into a comma separated string and pass them to your query. This is typically done in the beforeOpen of the dataset. Something like this: http://www.birt-exchange.org/org/devshare/designing-birt-reports/771-using-a-multivalue-parameter-in-a-in-clause/

Thanks Michael, those examples really helped.

I have now run into a very strange and irritating problem with the 1st issue i mentioned.

I have created 2 data sets for my 2 multi select cascading parameters. The 1st parameter populates fine. My 2nd data set executes a SP and takes values from 1st parameter as input parameter. The query is like this:

exec schema.storedProcedure @Parameter = paramList

I have a script in the before open event of this data set like this:
this.queryText = this.queryText.replace("paramList", "'" + params["1stCascadeParamter"].join(",")) + "'";

This is the output of the above script : exec schema.storedProcedure @Parameter = '975,974,825'

I have associated my 2nd cascading parameter (multi select) with it, and when i preview the report, there is no value seen in the 2nd parameter even after selection of any value in the first. I dont even get any error.

To debug i made the 2nd data set as my report output, and when i preview, i can see the data in the report that i want, so my data set is working fine. I tried lot of combinations with the script, but only the above one gives no error. Please help me solve this issue.

Avinash

Just read a few other posts with similar issue. They told to add the below code in 'before open' event, but this is also not working.

importPackage(Packages.com.ibm.tivoli.maximo.report.script);
mxReportScriptContext = MXReportScriptContext.initialize(reportContext);

PS: i am using BIRT 4.2.2

So, it's just not updating the second parameter list? But, it works if you use the dataset that's supposed to fill the second parameter as the report dataset? I'll have to try to set this up using an external database.

Yup, that is correct. It works as report data set but not for parameter. I however, have got it to work by changing the script. I changed my script to something like below:<br />
<br />
var stringArray = params["1stCascadeParamter"].toString().split(",");<br />
var result = "";<br />
for(var i =0 ; i < stringArray.length ; i++){<br />
if(i==0){<br />
result = stringArray;<br />
}<br />
else{<br />
result = result+","+stringArray;<br />
}<br />
}<br />
<br />
result = "'" + result + "'";<br />
<br />
this.queryText = this.queryText.replace("paramList", result);<br />
<br />
the output of this script is same as the other one:<br />
exec schema.storedProcedure @Parameter = '975,974,825'<br />
<br />
This script is working and populating my parameter. But I still dont know why the other script did not work.<br />
<br />
Avinash

Interesting. Well, either way, I'm glad you got it working!

<p>@walnash</p><p> </p><p>When is your second parameter updated?</p><p>In my case, I can select multiple values in my first cascading parameter.</p><p>But the second cascading parameter only shoes the value of the first value from the first parameter.</p><p>Then I click refresh report and suddenly all values from the first parameter are shown.</p><p>I took the example from <a data-ipb='nomediaparse' href='http://www.birt-exchange.org/devshare/_/designing-birt-reports/1477-allow-multi-value-for-cascading-parameter'>http://www.birt-exchange.org/devshare/_/designing-birt-reports/1477-allow-multi-value-for-cascading-parameter</a>.</p><p>For example, when I select UK and USA (first parameter) then only 7 (second parameter) for UK is shown.</p><p>Clicking on refresh report and selecting UK and USA as well as 7 causes that 1, 2, 3 (for USA) and the 7 for UK are shown.</p><p>Do you have the same output oder is it different to yours?</p><p> </p><p>Thank you for helping.</p>

<p>@firefighter90</p><p> </p><p>hey, i have the same output. I guess you are using ctrl + mouse clicks to select multiple values in first parameters. With this we only get the value for the first selection. If you click on any one value and drag your mouse over other values you get the values for these selection as well. This, however does not server much purpose. I had much bigger problems with my report so did not delve into this issue. Just for your reference below is the script that i used in the 'beforeOpen' event of my dataset to get it to at-least populate the next parameter.</p><p> </p><div>var stringArray = params["firstParameter"].toString().split(",");</div><div>var result = "";</div><div>for(var i =0 ; i < stringArray.length ; i++){</div><div>if(i==0){</div><div>result = stringArray;</div><div>}</div><div>else{</div><div>result = result+","+stringArray;</div><div>}</div><div>}</div><div> </div><div>result = "'" + result + "'";</div><div> </div><div><div>// For String</div><div>this.queryText = this.queryText.replace("firstParameterValue", result);</div><div> </div><div> </div><div><div>My dataset executes a stored procedure using below query:</div><div> </div><div>exec reporting.procedure @parameter = firstParameterValue;</div><div> </div><div>Avinash</div></div></div><div> </div><div> </div><div> </div>

<p style="color:#000000;font-family:helvetica, arial, sans-serif;">@firefighter90</p><p style="color:#000000;font-family:helvetica, arial, sans-serif;">Are you facing the problem when you preview or run the report from report designer? Because i am facing the same problem when i preview/run the report from designer. Once i deploy the report in the server i do not face this problem</p><p style="color:#000000;font-family:helvetica, arial, sans-serif;"> </p><p style="color:#000000;font-family:helvetica, arial, sans-serif;">Avinash</p>

birtUser041882

<p>nothng is wokring for me.. is it the birt version? but I upgraded to 4.3 just teh SDK engine cant be upgraded. is it because of it? I tried all possible solution but nothing. anyone help me? I can't make the second level get the values selected in the 1st level. it only shows the value for the first item selected but not the other items.</p><p>ex a=1,2,3, b=3,4 if I select a second level shows 1,2,3 but if I select both a & b it still shows 1,2,3 and not 3,4 been struggling on thjis for 2 days now.</p>

birtUser041882

<p>by the way I used the resource from <a data-ipb='nomediaparse' href='http://www.birt-exchange.org/devshare/_/designing-birt-reports/1477-allow-multi-value-for-cascading-parameter'>here </a></p><p>even that report sample is not working as it claimed to.</p><p>I am using ctrl+ click , I also tried click then drag mouse but it just shows the value for the last items my mouse dragged into. </p>

<p>@birtUser041882</p><p> </p><p>Have you checked after deploying your report in the server? I had a similar issue but after i deployed my report in the server, it was working fine.</p><p> </p><p>Avinash</p>

<p>Now I deploy my report in the server.</p><p>I can see the different values when clicking on the different countries, but this only works if I select from the bottom up.</p><p>But when I click on UK and Japan, I want to see the Country Codes 5 and 7, I only see 5 for Japan (the last selected item).</p><p>Can anyone help me with my problem?</p>

<p>I found a solution for my problem:</p><p> </p><p><a data-ipb='nomediaparse' href='http://www.birt-exchange.org/devshare/_/designing-birt-reports/1477-allow-multi-value-for-cascading-parameter'>http://www.birt-exchange.org/devshare/_/designing-birt-reports/1477-allow-multi-value-for-cascading-parameter</a></p><p> </p><p>I have already used this some days ago but it didnÂ´t work, donÂ´t know why.</p><p>When trying it now, I got the result I wanted to have.</p><p> </p><p>Thank you all for your help. I appreciate it, at all.</p>

<p>Glad to hear it's working for you!</p>

<p>It only works with strings but my parameters are integers.</p><p>I hope I can find a way to adapt the beforeOpen - Script from walnash.</p><p>Have found none till now.

</p>

<div>try this for integer.</div><div> </div><div>//For integer </div><div>this.queryText = this.queryText.replace("'textToReplace'", params["Country"].value);</div>

<p>When I try this, nothing happens.</p><p>I add .toString() after params["Country"].value then the suitable values for the first selected country are shown.</p><p>When I click on another country, all values vanish.</p><p> </p><p>Nevertheless, thanks for your answer.</p>

<p>Try this. And yeah lot of time these scripts dont work and i dunno why. If you read my posts above you'll see that i had to tweak my script a lot on trial and error basis to get it to work. I found the below script from a blog. It worked for the example it was used for, but didnt work for me. You can try it and see if it works for you.</p><p> </p><p>[color=rgb(40,40,40);font-family:helvetica, arial, sans-serif;]this.queryText = this.queryText.replace("[/color][color=rgb(40,40,40);font-family:helvetica, arial, sans-serif;]textToReplace[/color][color=rgb(40,40,40);font-family:helvetica, arial, sans-serif;]", "'" + params["[/color][color=rgb(0,0,0);font-family:helvetica, arial, sans-serif;]Country[/color][color=rgb(40,40,40);font-family:helvetica, arial, sans-serif;]"].join(",")) + "'";[/color]</p>

<p>When working with BIRT, you have to be very patient

</p><p>IÂ´ve already tried so many options like params["Country"].value[0], params["Country"].value ..... but nothing works.</p><p>(I rebuilt the classicmodels database and gave each Country an integer ID)</p><p> </p><p>Maybe I have to change a Javascript File from webcontent, I donÂ´t know.</p><p> </p><p>Do you have any idea how I can adapt the code from beforeOpen when Country was a String and no Integer??</p><p> </p><p>Maybe like this:</p><p> </p><p>var integerArray = params["Country"].value;<br />
var result = "";<br />
<br />
for(var i = 0 ; i < integerArray.length ; i++)<br />
{<br />
if(i==0)<br />
{<br />
result = "'" + integerArray "'";<br />
}<br />
else<br />
{<br />
result = result + ",' " + integerArray + "'";<br />
}<br />
}<br />
<br />
//result = "'" + result + "'";<br />
<br />
this.queryText = this.queryText.replace("paramList", result);</p>

<p>this.queryText = this.queryText.replace("'paramList'", '3, 12');</p><p> </p><p>This works fine

</p><p> </p><p>But why doesnÂ´t params["Country"].value fill in 3 and 12 ?!?!</p>

<p>Hi everyone</p><p> </p><p>I have problem with this multi-cascading parameter.</p><p>I downloaded example from site: <a data-ipb='nomediaparse' href='http://developer.actuate.com/community/devshare/_/designing-birt-reports/1477-allow-multi-value-for-cascading-parameter/'>http://developer.actuate.com/community/devshare/_/designing-birt-reports/1477-allow-multi-value-for-cascading-parameter/</a></p><p>When I open this example in Birt application it doesn't work (I see parameters on level 2 only from one of selected on level 1) but in debugger mode it works properly.</p><p>I installed this example on server and I replaced BirtParameterDialog.js file but it still doesn't work.</p><p> </p><p>Thanks for any suggestions.</p><p> </p><p>Regards</p>

<p>Today I checked once again and now it works on server. I don't know why.</p><p>But there is one little problem. When I select items with mouse it works but with CTRL+mouse click it doesn't.</p><p>Is there a solution for this?</p>

<p>Hi again</p>
<p>I would like to refresh this subject.</p>
<p>Does anybody know why multi cascading parameters not working in IE?</p>
<p>In chrome it works perfect. When I select items with mouse or with keybord + mouse but in IE works selecting only with mouse.</p>
<p> </p>
<p>Regards</p>

kclark

<p>@krychunm, have you tried compatability mode in IE just to see if that works?</p>

<p>Hi</p>
<p>Yes I tried but only on IE 9.</p>
<p>I checked if it works without compability mode on other versions of IE but it's not.</p>
<p> </p>
<p>Regards</p>