Totally Dynamic Week Summary Report 1

[tbear6602]

I am streamlining a daily report that shows a rolling weekly snapshot. When I initally created it I was getting the following (abbreviated for clarity)
@Day1 @Day2 @Day3
Ticket1
Ticket2
Ticket3
Ticket4
Ticket5
Ticket6
Ticket7
Ticket8
Ticket9
Ticket10
Ticket11
Ticket12
So I played with it and the only way I could eliminate the whitespace (and get it looking as follows) was to create 7 subreports that pulld the data in and displayed it in a certain position based on the day of the week (and it pulls the same data 7 times).

The desired layout is:

@Day1 @Day2 @Day3 @Day4
Ticket1 Ticket5 Ticket9 Ticket13
Ticket2 Ticket6 Ticket10 Ticket14
Ticket3 Ticket7 Ticket11 Ticket15
Ticket4 Ticket8 Ticket12 Ticket16

We're moving this to another database, and I'm going to have to rewrite it anyway, so I'd welcome any tips on how to streamline it, esp. to eliminate the subreports.

 

[synapsevampire]

Subreports are a bad idea, and probably weren't required here.

You could have grouped by some outer field, such as the month or some such, and in the details constructed the totals as variables and displayed them in the group footer.

Understand that my solution offered was abbreviated not for clarity, but because you did not post meaningful technical information from which to properly do design work.

To get quality results post technical information:

Crystal version
Database/connectivity used/permissions available
Example data (not an example of a broken report, show the fields and example data)
Expected output

-k

 

[tbear6602]

ok - sorry. Using Crystal 10/ Oracle 9i Read only

Sample Data Available:

TicketDate TicketNumber OpenTime
7/25/05 9:05AM 123456 3.75
7/25/05 11:30AM 123457 4.15
7/25/05 2:04PM 123458 3.00
7/26/05 2:14AM 123459 8.2
7/26/05 8:13AM 123460 0.2
7/26/05 10:30AM 123461 0.5
7/27/05 9:18AM 123462 2.4
7/27/05 3:48PM 123463 6.0

Desired Output:

Monday Tuesday Wednesday
TicketNumber OpenTime TicketNumber OpenTime TicketNumber OpenTime
123456 3.75 123459 8.2 123462 2.4
123457 4.15 123460 0.2 123463 6.0
123458 3.00 123461 0.5



With the location of the data rolling as the week progresses. Basically the data from a week ago today (CurrentDate-7) appears in the first column, with each day as you read left to right becoming one day more recent, ending with yesterday's data (CurrentDate -1).

 

[MrBillSC]

In version 8.5 this works for me:
Group on date.
In group header place a formula that displays the name of the DayOfWeek for your date field.
In section expert for your detail section create your seven columns.
In "section expert" for your group footer check the "print at bottom of page" box.
In you group footer place a text box for testing. This should cause the text box to print at the bottom of the group column and the next group value (and header) will print at the top of the next column. Supress the text box after testing. This may not give you the solution you want if your report is multiple pages.

MrBill

 

[tbear6602]

Thank you thank you thank you!!!!


That worked perfectly. I remember messing with the column in the section expert, but I never saw the new subtabs appear. Boy am I blind! Now I know this report will put less strain on the database and on me if I need to fix it ever again!