Alanhamlins
MIS
I have a table containing customer records and each customer has a date.
I am trying to produce a report that will show the customers with the same dates (not more than 10), in a list beneath the date group header.
I have contrived a report consisting of four similar subreports, one for each week, the idea being to list four weeks down the page, each week with the five days (Mon-Fri in a five column report) across the page, with the customers listed beneath their date. I set the column order to 'Down then across'.
The problem is that the second and subsequent subreports insist on starting in the last column of the preceding subreport. I have the 'New Row or Col' for the section (date) header set to Before section. Question, how do I force each subreport to start where I put it on the main report so that 'Mon' starts in the same column as 'Mon' for the previous week instead of 'Fri'
Cheers
I am trying to produce a report that will show the customers with the same dates (not more than 10), in a list beneath the date group header.
I have contrived a report consisting of four similar subreports, one for each week, the idea being to list four weeks down the page, each week with the five days (Mon-Fri in a five column report) across the page, with the customers listed beneath their date. I set the column order to 'Down then across'.
The problem is that the second and subsequent subreports insist on starting in the last column of the preceding subreport. I have the 'New Row or Col' for the section (date) header set to Before section. Question, how do I force each subreport to start where I put it on the main report so that 'Mon' starts in the same column as 'Mon' for the previous week instead of 'Fri'
Cheers
