Passing Multiple values from Parent Report To Subreport

[RickyW]

I have a Parent report which contains a key field with multiple values. I am trying to pass these to a subreport
parameter ({?Builder} with allow multiple values checked on)in the selection formula of my subreport. I thought I could do:

{@PhaseNumber} = {?Pm-@PhaseNumber} and
{Cwtrades.CLOSEDATE} >= {?MinClosingDate} and
{Cwtrades.CLOSEDATE} <= {?MaxClosingDate} and
{Cwtrades.STATUS}<>'B' and
{Cwtrades.LISTING} in {?Builder}

I get an error saying &quot;This array must be subscripted For Example Array[1]&quot;
I tried to build this with an array but can not find any examples or documentation to help me.
Thank You,

Rick

 

[synapsevampire]

The simplest way to accomplish this is to use the subreport linking to define it. Right click the subreport and select Change Subreport Links.

The syntax is slightly different, it will look like:

{Cwtrades.LISTING} in {?Pm-Builder}

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com