I am wondering if something can even be done in Crystal reports.... Here is the scenario:
I hate a start date and a end date. each in a table in a separate field. I want to be able to create something that will take the dates and list every date between the two as its own header column in Crystal. Then I can align the details based on the date to the header.
It is for some time keeping reports that I am trying to build for our HR dept. They want to see a report every Monday morning that shows last weeks hours underneath the dates for last week. I have the query working where it shows a total hours for the day with a date stamp in another field, but I can't find a way to put it in crystal to make it work.
Example: 1/1/11 - 1/7/11
My current Query/Crystal shows like this:
NEED it to look like this:
1/1/11 1/2/11 1/3/11 1/4/11 1/5/11 1/6/11 1/7/11
8 7 0 5 5 8 6
Please if anyone can help, it would be greatly appreciated.