Skip to Content
0
Former Member
Sep 09, 2011 at 12:46 PM

Crystal Question

14 Views

Experts,

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:

1/1/11

8

1/2/11

7

1/3/11

0

1/4/11

5

1/5/11

5

1/6/11

8

1/7/11

6

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.