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.
@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.