Home
Designing Analytics Reports
Passing multiple Int values into a 'drill through' parameter
Migrateduser
<p>Good morning, all!</p>
<p> </p>
<p>Here's the problem I've run into: I have a top level report that collects a number of 'heat_no' (Integer) values when run, and dumps the values into a parameter (heatNum). This parameter does nothing other than collect data.</p>
<p> </p>
<p>On the report table, I have a binding called 'Heats' that takes all of the values in the parameter, and combines them into a comma-separated string by using <strong>params["heatNum"].value.join(",")</strong>. I have second binding ('TEST') that is in the footer of the table just so I can see what values are captured.</p>
<p> </p>
<p>Now, the main part of this report is a linear gauge gadget. I have interactivity on, and I'm passing the value of <strong>row["Test"]</strong> to the drill report into a parameter (heatNo) that is an integer . The problem I'm running into, is that I cannot for the life of me get the values being passed to work..... I can't seem to find the correct way to break the individual values out of the string, then put them back together as INT values so I can use them for <strong>WHERE heat_no IN (....)</strong> in my query for the second report.</p>
<p> </p>
<p>
Find more posts tagged with
Comments
There are no comments yet