Skip to Content
author's profile photo
Former Member

Passing array values to a sub report

Hi everyone,

I had a little problem with passing values to a sub report through array.

I have two groups in my main report. And in the second group I want to store the values being printed out in the array and pass them to the sub report.

I created a formula in the main report and placed it in the second group footer.

Then I placed the sub report in the first group footer and created a formula to retrieve the values of the array. But the same value printed on every page.

What am I missing?

Thank you.

Here's the formula I created in the main report: This is the formula in the sub report:

WhilePrintingRecords; WhilePrintingRecords;

shared numberVar array values; shared numberVar i;

shared numberVar i; local numberVar j;

i:=i+1; numbervar v;

redim preserve values[i]; shared numberVar array values;

if i=1 then for j:=1 to i step 1 do

values[i]:={@total} v:=values[j];

else if not({@total} in values[1 to i]) then v;

values[i]:={@total}

else

(

i:=i-1;

)

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    Jan 08, 2015 at 10:08 AM

    Hi Nebil,

    What exactly are you trying to do with the array formula on the Main Report - only store 'unique' values that appear on the Group #2?

    And, what exactly do you do with the array formula inside the Subreport? Display it somewhere?

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Jan 08, 2015 at 09:47 AM

    Hi,

    Try Using Join And Pass it as Text .

    ToText(Join( ({YourArray}) , ","))

    I use Below Code for Passing in Open Doc .

    Replace(Replace( ToText(Join( ({YourArray}) , "],[")),"&","%26"),"+","%2B")+"]"

    Add comment
    10|10000 characters needed characters exceeded