Passing multi-value parameter through a chart in a drilldown

<p>Hey, all! So, I've searched through the OpentText / Eclipse forums, and really haven't found a straight answer for my problem. I have a table / chart design that has five parameters (one of which allows for multiple values), to which I have added drill-down interactivity on the bar chart. The target report has the same parameters, and one of which will accept multiple values. These are string values, and on both reports, I have this on the data set beforeOpen:</p>
<p> </p>
<div><span style="font-size:14px;">if (params["Grade"].value != null)</span></div>
<div><span style="font-size:14px;">{this.queryText = this.queryText+ " AND grade_family_category IN ('" + params["Grade"].value.join("','") + "')";}</span></div>
<div> </div>
<div>Each of the reports on their own run perfectly fine with multiple values for the 'Grade' parameter. The issue comes when I try to pass the 'Grade' value(s) from the chart to the target report. I get the following error:</div>
<div> </div>
<div><strong>ChartException: The trigger data is invalid or its type is unknown.</strong></div>
<div> </div>
<div>So, is there a way to push multiple values through, or am I out of luck?</div>
<div> </div>
<div>Thanks in advance for any help! Have a great weekend!</div>
<div> </div>
<div>Scott</div>

Find more posts tagged with

Comments

pricher

<p>Hi Scott,</p>
<p> </p>
<p>How did you create the hyperlink from the chart to the drill-down report? Maybe you can send a copy of your design.</p>
<p> </p>
<p>Thanks!</p>
<p> </p>
<p>P.</p>

CodeRookie

<p>Good morning, Pierre! I created the hyperlink in the 'Y Series' area of the chart. You've actually seen this report design before (<a data-ipb='nomediaparse' href='http://developer.actuate.com/community/forum/index.php?/topic/39707-passing-a-value-from-a-tablegroup-as-a-drill-through-parameter/'>http://developer.actuate.com/community/forum/index.php?/topic/39707-passing-a-value-from-a-tablegroup-as-a-drill-through-parameter/</a> ). I'm trying to add the ability for the user to pass multiple values for the 'Grade Family Category' parameter.</p>
<p>I'm attaching the latest version of the file.</p>
<p> </p>
<p>Thanks for the help!</p>
<p> </p>
<p>Scott</p>

pricher

<p>Hi Scott,</p>
<p> </p>
<p>I have done further testing using Classic Models and I am able to replicate your issue in 3.1.1, but it works fine in iHub 16.</p>
<p> </p>
<p>You might want to take a look at this <a data-ipb='nomediaparse' href='http://developer.actuate.com/community/forum/index.php?/topic/29580-passing-multi-value-parameter-on-with-drill-through/'>post </a>for a workaround.</p>
<p> </p>
<p>Hope this helps,</p>
<p> </p>
<p>P.</p>

CodeRookie

<p>Pierre,</p>
<p>Hi! Unfortunately, the subsequent link to the devshare noted in the forum topic you referenced is broken.....</p>
<p> </p>
<p>It's just weird that the chart will work using multi-values, the target report will work with multi-values, <strong><em>BUT</em></strong> trying to pass multi-values between the two blows the whole thing up.</p>
<p> </p>
<p>Would you happen to know what setting changed between 3.1.1 and 16 to allow it to work? Probably not a simple one line fix.</p>
<p> </p>
<p>Thanks for the help!</p>
<p> </p>
<p>Scott</p>

CodeRookie

<p>Pierre,</p>
<p>I got it to work! Here is what I did: I put a data binding in the table that feeds the chart, and called it 'Grade'. The expression in that data binding is: <strong>params["Grade"].value.join(',')</strong>.</p>
<p> </p>
<p>So now, in the hyperlink in the chart, I set the 'Grade' parameter in my target report equal to row["Grade"] from the table and, voila, I can pass multiple values through the chart to my target report design.</p>
<p> </p>
<p>Victory!</p>
<p> </p>
<p>Thanks again for your help!</p>
<p> </p>
<p>Scott</p>

pricher

<p>Great news! Well done!</p>