Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

One check date per column

Status
Not open for further replies.

funscrapn

Technical User
Jan 13, 2005
12
US
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!!!
 
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 ;-)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top