Skip to Content
0

Passing array parameter to subreport

Jun 09, 2017 at 09:00 AM

38

avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Vitaly Izmaylov
Jun 09, 2017 at 04:29 PM
0

Place the following formula in Details section:

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

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