Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Compare records between 2 different subreports?

Status
Not open for further replies.

Santos

MIS
Mar 9, 2001
11
US
Hi,

Is there a way to compare 2 records beween 2 subreports? For example, I have 2 subreports and I would like to match records between the two. I want to set it up so that if there is a match, then the matching record will be suppressed. I tried using the shared stringvar statement with no luck. Any suggestions?

Thanks,

- dan
 
This is how I would do it...

I would make globally shared stringvar values for each of the fields. Then, in the main report, I would make shared numbervar fields. If the creteria for suppression is met then 1 else 0. Then in the subreports, I would suppress based on that shared numbervar (if 1 then true else if 0 then false)...


OLet me know how it goes.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top