SubReports

[glenellis]

Have primary report with parameter that asks for Barrel number. Reports lists all input arrays for that barrel. There could be multiple input arrays per barrel assembly. When I now link subreport and specify input array as the link, the "link" brings me to the subreport showing me the data associated with the last record on the primary report.
Is there a way to "hyperlink" the input array field on each row, so the user can select which input array value they wish to drill-down on?

CR version 8.5/SQL Server 2000

Thank you.

 

[chelseatech]

You can't pass a mutivalue down to the subreport, but you can pass a string. So use a formula with a "JOIN" function to combine your array into a string, link it to the subreport and then break it apart again with SPLIT

1) In main report create a formula - BarrelList
Join ( BarrellArray, "|&quot
// or any other char that isn't a valid barrellcode

2) Link the formula to a paramater in the subreport

3) In the subreport, if you want to select the barrells, in the record selection use...
{table.BarrellCode} = Split({?Linkedparm},"|&quot