Skip to Content
author's profile photo Former Member
Former Member

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.

Add comment
10|10000 characters needed characters exceeded

1 Answer

  • Posted on Jun 09, 2017 at 04:29 PM

    Place the following formula in Details section:

    if {YourValue} Like "ABC*" then
    ( numbervar n:=n+1;
    stringvar array List;
    redim preserve List[n];

    It will built an array "List" with all the values
    Add comment
    10|10000 characters needed characters exceeded