Skip to Content
Former Member
Jun 09, 2017 at 09:00 AM

Passing array parameter to subreport


I have a main report that has no groupings, essentially all of the content of the report is in the report footer, there is no detail or grouping as I am doing most of the grouping or aggregating in SQL. The report has multiple subreports in the Report Footer that I wish to pass values to for filtering (linked subreport). I would like to be able to set a parameter on the main report with a like* to get all variations on a value, ie like ABC*, to capture ABCD, ABCF, ABG etc. How can I do this? I know that I should be able to set an array for the parameter (using join?) and then change the subreport link to be in split(arrayvariable,","). What I am having problems with is building the array.