Need some help linking parameters f

[digilantis]

Need some help linking parameters from amin to subreport.
The Main report takes 3 parameters
{?AccountNo}StringVar
{?ReportStart}DateVar
{?ReportStop}DateVar

The ReportStart & ReportStop Vars are just User inputs. They do not query against the DB, The AccoutNo does query the DB

I can Pass in the AccountNo var to the Subreport OK But I need to pass the DateVars to the Subreport For record selection and I can't seem to pass those in? Am I missing something easy here?

Thanks

 

[synapsevampire]

I'd suggst using a single date range parameter, rather than 2.

Right click the subreport and select change subreport links.

Point at the {?ReportStart} and then below choose your date field in the *select data in subreport based on* area.

Now you can do this again for the other date if you prefer 2 different parameters.

Now go into the record selection criteria, you'll see the formulas used, edit it if required.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[chelseatech]

Older versions of CR didn't support Subreport Links of multiple values or ranges. CR8.5 and 9 do support this.

Check the "Report Options" inside the subreport, and see if your dates are appearing as date or date/time vars. The subreport links on the exact same type.

Or link the parameters manual to a parameter in the subreport and then create the record selection manual. You will need to amend it anyway as the link creates an &quot;=&quot; and you probably want >= and <= each value. Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm