Shared variable

[victora]

I have a main report and 2 embedded subreports. 1 main record can have multiple subreport records. Theres a date field on both subreports that I need to bypass if a condition is true (i.e. expired). How can I use a shared variable so I can do the filter from the main report.


Thanks

victora

 

[synapsevampire]

If the date is only in the subreport, then just add the criteria to the subreport record selection criteria to limit the rows to none if it meets the criteria.

It would be useful to share some specifics if this doesn't help.

-k

 

[victora]

ok, lets see if i can explain my scenario. My main file is a Provider table. Then I have 2 tables: a License table and an Insurance table which may contain multiple records for a provider. (A doctor can have multiple licenses and insurance). I'm printing a fax sheet that will remind them of expired licenses or insurance. I should only print 1 page that will print the expired licenses or insurances. So I created a subreport for each table where I grab only expired dates. The problem is if a Provider has an up-to-date licenses/insurance, it will still print a blank fax sheet.

So if I can query those fields from my main report then I can exclude them from printing.

I hope i'm cleared this time...anyway, thanks for the prompt response..

 

[synapsevampire]

Why not just link the tables to the main Provider table, group by the provider, and use a formula that checks to see if any of the licenses or insurance rows are expired?

It doesn't sound like you need a subreport at all.

That way you can limit rows in the report to only those that are expired in the record selection formula and not worry about filtering data in subreports.

-k

 

[victora]

sounds like a good one. let me take a shot on this. thank you...