Display all day of a month in a cross table in Crystal Report 8 
Author Message
 Display all day of a month in a cross table in Crystal Report 8

Hi,

my problem is that in a cross table report, I want to display all the
day for a specific month. For example, I would like to know for all
project (line) how many hours I spent for each day (colomn). I get all
good values for that but because I have not work saturday, the colomn
doesn't appear because the're is no record for that day in the
database.

               1     2    3   9  12
programming    6     4    8   4   1
analysing      1     3    0   3   6

I would like to display that (below) without creating a dumb table
with all day for a month and make an outer join with it. Is that
possible?

               1     2    3   4   5   6   7   8   9   10   11   12
........
programming    6     4    8   0   0   0   0   0   4    0    0    1
analysing      1     3    0   0   0   0   0   0   3    0    0    6



Wed, 25 May 2005 00:12:07 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Crystal Reports - determine last business day of month.

2. display days of months using formula

3. cross-tab report in 12 months

4. Converting Days to Years, Months and Days

5. Return Month/Day from Day Number

6. Cross-tab reports in Seagate Crystal Reports

7. Displaying Reports By Month

8. Cross Tab Reports - How to display Percentage of totals

9. Help - Cross Tab report displaying zero-length strings

10. VB4 Calander Grid Displays Days One day early

11. Report: This year by month/ last year by month

12. Crystal Reports cross-tab queries

 

 
Powered by phpBB® Forum Software