Subreport, suppressing duplicate data to get an exact count

[agray123]

I am working on a report that will compute retirement eligibility.

There are two factors, and thus two reprots, one which I have added as a subreport.

Factor one, age greater than 60...I use an age formula to compute age based on a given date.

Factor two, years of service greater than 30

I use the same age formula to compute yrs svc.

Now I want to suppress any EMPLID's that appear in the subreport for years service if the employee is also over 60.

This will enable me to get an accurate count.

I am thinking along the lines of a shared variable, but would appreciate any other ideas...

 

[lyanch]

I don't understand why you are using a subreport to get the second set of data. Why not a selection formula in the maing report of:

age > 60 OR yearsofservice >30

That would eliminate your duplication problem.

Lisa

 

[agray123]

Wipes up the puddle of drool from trying to overcomplicate a report and thanks lyanch....I have pneumonia and they gave me this really cool cough syrup with all these warnings on it....

Sorry for the stupid question!

 

[lyanch]

No problem if you send me some of your cough medicine

Lisa

 

[agray123]

If i could include it as an attachment, I would.

I bet it would go great mixed with Sprite...LOL

Thanks for the help!

Andy