Passing multiple Int values into a 'drill through' parameter
Good morning, all!
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.
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 params["heatNum"].value.join(","). I have second binding ('TEST') that is in the footer of the table just so I can see what values are captured.
Now, the main part of this report is a linear gauge gadget. I have interactivity on, and I'm passing the value of row["Test"] 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 WHERE heat_no IN (....) in my query for the second report.