Passing Parameter -- Syntax

[digilantis]

I have the formula below in a SubReport. The SubReport is placed in the AccountNo GroupFooter of the main report. I am looking for the correct syntax to pass the main report AccountNo to the formula in the subreport??

IIf({tblAutoRaw.dtAction}={?ReportStart}AND[Mainreport.AccountNo = SubReport.AccountNo] AND {tblAutoRaw.szTermCode} <> &quot;TR&quot;,{tblAutoRaw.nCount},0)

Thanks

 

[IanWaterman]

Delete this statement from your subreport selection

AND[Mainreport.AccountNo = SubReport.AccountNo]


Go to Edit - Subreport Links

Select AccountNo in top left box
if AccountNo does not appear automaticaaly in bottom right use drop down to select AccountNo
Click OK

This will create an enetry in subreport selection
{AccountNo} = {?Pm-AccountNo}

The subreport link wizard creates a parameter from the main report and then carries that through to the selection criteria of the subreport.

Hope this clear

Ian Waterman
UK Crystal Consultant