Repeating Records

[donnarenia]

I have a report that pulls tax returns...by statutory due date. The report works fine but then I created a formula that will add the preparers name so I can know who is assigned to that return. When I add the following formula to my report I get repeating projects. I have checked my links and changed them to Left Outer Join but I continue to get repeating projects.

My preparer formula is:
WhilePrintingRecords;
stringVar preparer;
preparer := if {PROJECT.StatutoryDueDate} in {?Date
Range} and {PROJSTAF.Role}= "TAX" then {PROJSTAF.EmpID}

Any Suggestions

 

[donnarenia]

figured it out...no reply necessary

 

[lbass]

Yes, you should explain how you fixed this so this thread becomes meaningful.

-LB

 

[donnarenia]

Well...it wasn't the best fix. I simply added a selection criteria to the select expert that showed the role I needed. I was receiving duplicate because every record had 5 different roles and I only need to see the one....not too impressive.