Hello,

I am not sure why, but some duplicate data is showing up in my report even though I have chosen to select only distinct records and the data is not found more than once in the datasource.  Additionally, I'm working to make it so this report can be run directly from my original data, and there is some duplication there (for instance, if someone is employed at 25% in one area and 75% in another area, it will list their total combined salary under each position.)

I have found a way to get rid of these created duplicates through the following formula:

If (({Main_Data.Position}) = previous({Main_Data.Position}))
and (({Main_Data.Enc Sal Amt}) = previous({Main_Data.Enc Sal Amt}))
then $0 else ({Main_Data.Enc Sal Amt})

However, since this is a second pass formula, I am not able to create a summary of this field or a running total.  I've been trying to figure out how to summarize it in the formula so it will also happen in the second pass but have come up blank.

I am willing to use something else if I can get rid of my duplicates in some other way, but I need to summarize these fields!

 

I like shared variables just because it is easier for me to remember than global (and for some reason it is easier to type).  shared will work just as well as global with or without the subreport, but global won't work for the subreport....so I choose shared as a generic catchall.

 

 

HTH