Subreport

I know I can link the customer table to the form, but how do I bring up the customer group field from the subreport to the main report? Using global vars or something?

As you can tell, I'm not very familiar with this method.

The subreport is small, with just the group showing.

How can you filter on the values of a subreport though? don't you need to have the value in a formula?

You link with the customer ID.  ARGRO is the table in the subreport.

I mean ARCUS, you display IDGRP.

You need 2 formulas so that you can actually use the sub-report field in in the main report:

Create your sub-report with ARCUS

- Add IDGRP to the sub-report

- Suppress the Report Header & Footer & Page Header & Footer – leave only the detail line     unsuppressed

- (for main report when database is OEINPR3 – link is OEINPR3.Customer to ARCUS.IDCUST)

Add the sub-report to the page header (you should be able to leave the section suppressed)

Sub-Report Formula:

In the sub-report create a formula named group:

whileprintingrecords;

shared stringVar custgrp :={ARCUS.IDGRP} ;

save & add formula to detail line of the sub-report

In the main report create a formula named cgroup:

whileprintingrecords;

stringvar custgrp;

You should now be able to use/reference the formula in the main report to suppress items or sections on the report.

You need 2 formulas so that you can actually use the sub-report field in in the main report:

Create your sub-report with ARCUS

- Add IDGRP to the sub-report

- Suppress the Report Header & Footer & Page Header & Footer – leave only the detail line     unsuppressed

- (for main report when database is OEINPR3 – link is OEINPR3.Customer to ARCUS.IDCUST)

Add the sub-report to the page header (you should be able to leave the section suppressed)

Sub-Report Formula:

In the sub-report create a formula named group:

whileprintingrecords;

shared stringVar custgrp :={ARCUS.IDGRP} ;

save & add formula to detail line of the sub-report

In the main report create a formula named cgroup:

whileprintingrecords;

stringvar custgrp;

You should now be able to use/reference the formula in the main report to suppress items or sections on the report.

or you can switch to the non DLL version :-)  I'm just sayin...

Thank you Vicky! Seems like a lot of work though. Ha.

YW -  my guess is that it's less work than you've already put into the report... and I did write the formulas out for you  so the only work there is copy & paste... :)

Good Luck