select records based on subreport

[richardtm]

Can I select only those records where records are present in one of two (or both) subreports?

Thanks for any assistance.

 

[kskid]

It would be much more helpful if you supplied more technical information. See FAQ149-3762

 

[synapsevampire]

Theoretically you can, but keep in mind that subreports are puh-yoooooour, eeeeeevuuuuuhl, try to avoid using them.

As witchita mentioned, flesh out meaningful information about the requirements.

-k

 

[Madawc]

To pass data back from a subreport, use a shared variable. Make a formula field in the subreport like
Shared dateVar
V_Today := {LoadStatus.LastDLoad}
or
whileprintingrecords;
shared currencyvar WasSaved;
WasSaved:={#TotSaved};
WasSaved

To access it in the main report, create another formula field with
Shared dateVar
V_Today := V_Today
or
whileprintingrecords;
shared currencyvar WasSaved;
WasSaved

Note that the shared variable is only available in the section after the section which contains the subreport.

And as synapsevampire said, subreports are slow. They make a lot of work for computers, but nay save time for humans. You decide which is more important for your particular circumstances. The normal alternative is a Stored Procedure, which requires a knowledge of SQL.

Madawc Williams (East Anglia, UK)