Home
Designing Analytics Reports
Passing multi-value parameter through a chart in a drilldown
Migrateduser
<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
There are no comments yet