Skip to Content
0
Former Member
Feb 26, 2009 at 07:28 PM

How To Suppress Records In Subreport Based on Value in Main Report

530 Views

I want to supress records in the Details section of my subreport based on a value in the Details of my Main report (main report could have same record as subreport).

I created the following formula with a shared variable and placed it in the Details section of my main report:

WhilePrintingRecords;

Shared StringVar sCertCode :={ACCPASCERT.CERT_CODE}

I placed the subeport in the Group Footer of the Main Report.

In the subreport, in the Section Expert I added the following formula for Supress of the Details section:

WhilePrintingRecords;

Shared StringVar sCertCode;

sCertCode = {ACCJBCERTS.PERS_CODE}

Unfortunately even though the value in the main report is the same as the value in the subreport, those records are not being suppressed in the subreport.

Would appreciate any ideas.

Thanks.