One check date per column

[funscrapn]

I am trying to create a report which will be pulling 4 to 5 check dates (depending on the month). Each check date needs to be in it's own column. Does anyone know how to accomplish this?
Thanks!!!

 

[AKMooseMan]

Hi there...my first reply in here (my first day in here period!)...

Without doing a quick test, I would think that you would use a "sum distinct(decode....." in a derived field for each check date.

I'm not sure where exactly you are going, but am thinking you are heading something like this with more collumns:

Employee CheckDate1 CheckDate2
John SMith sum of "something" sum of "something"

If I get the chance today, I'll take a break and play for a few...but that is where I would head ;-)