Hi all,
I am trying to help my son's after-school program improve the design of their invoice reports. They are using Access 2000, so that's what I am limited to.
The issue is that I have a subreport that is formatted to display two columns (Date and Amount) for the current charges. Since it's in a subreport, I needed to format the columns to print "Across then Down" in order to display multiple columns in the subreport, though I want the data to appear as if the report prints in "Down then Across" format, e.g.:
01/01/2008 $10 01/17/2008 $10
01/02/2008 $10 01/18/2008 $10
... ...
01/15/2008 $10 01/31/2008 $10
01/16/2008 $10
After devising a query to determine the correct RowNumber and ColumnNumber for the date on the record, I am able to produce a recordset in the desired order and the report looks great* if the data fits on one page. If the data takes more than a page, however, the detail section exhibits some strange behavior.
The dates from column 1 of the first page continue in column 2 of the second page. The dates from the bottom of column 2 on page 2 wrap to the top of column 2 on page 1. Column 2 page 1's dates continue in column 1 of page 2. Like this:
01/01/08 03/02/08
.... ....
02/04/08 04/05/08
---- PAGE BREAK ----
04/06/08 02/05/08
.... ....
05/08/08 03/01/08
I have played with the settings for the NewRowOrCol and KeepTogether (Section and Group) properties in various combinations and can't seem to hit on the right one. I even tried throwing in the ForceNewPage section for good measure, all to no avail. I have also reproduced this behavior in Access 2003.
Ideally, I would like the columns to wrap on each page, like any bill you might receive -- the dates would read in order from Page1 Col1, Page1 Col2, Page 2 Col 1, Page 2 Col 2. I don't know that this is possible through only report formatting, but if anyone has any thoughts on how I might be able to do this, I would love to hear them.
At the very least, I would like the dates to be in order Pg1 Col1, Pg2 Col 1, Pg 1 Col 2 Pg 2 Col 2. Does anyone have any advice on how to get this report to look a little more professional/intelligent/etc?
Thanks to any help anyone can give.
Regards,
Laura
* Also, does RepeatSection = Yes _not_ print the group header in the new column if the column printing is set to print across then down? That's the way it seems from my testing -- it will repeat the headings in column 2 if I set it to Down the Across, but not if it's set to Across then Down (same report). I was wondering if anyone can confirm this, because I can't seem to find it documented anywhere.
I am trying to help my son's after-school program improve the design of their invoice reports. They are using Access 2000, so that's what I am limited to.
The issue is that I have a subreport that is formatted to display two columns (Date and Amount) for the current charges. Since it's in a subreport, I needed to format the columns to print "Across then Down" in order to display multiple columns in the subreport, though I want the data to appear as if the report prints in "Down then Across" format, e.g.:
01/01/2008 $10 01/17/2008 $10
01/02/2008 $10 01/18/2008 $10
... ...
01/15/2008 $10 01/31/2008 $10
01/16/2008 $10
After devising a query to determine the correct RowNumber and ColumnNumber for the date on the record, I am able to produce a recordset in the desired order and the report looks great* if the data fits on one page. If the data takes more than a page, however, the detail section exhibits some strange behavior.
The dates from column 1 of the first page continue in column 2 of the second page. The dates from the bottom of column 2 on page 2 wrap to the top of column 2 on page 1. Column 2 page 1's dates continue in column 1 of page 2. Like this:
01/01/08 03/02/08
.... ....
02/04/08 04/05/08
---- PAGE BREAK ----
04/06/08 02/05/08
.... ....
05/08/08 03/01/08
I have played with the settings for the NewRowOrCol and KeepTogether (Section and Group) properties in various combinations and can't seem to hit on the right one. I even tried throwing in the ForceNewPage section for good measure, all to no avail. I have also reproduced this behavior in Access 2003.
Ideally, I would like the columns to wrap on each page, like any bill you might receive -- the dates would read in order from Page1 Col1, Page1 Col2, Page 2 Col 1, Page 2 Col 2. I don't know that this is possible through only report formatting, but if anyone has any thoughts on how I might be able to do this, I would love to hear them.
At the very least, I would like the dates to be in order Pg1 Col1, Pg2 Col 1, Pg 1 Col 2 Pg 2 Col 2. Does anyone have any advice on how to get this report to look a little more professional/intelligent/etc?
Thanks to any help anyone can give.
Regards,
Laura
* Also, does RepeatSection = Yes _not_ print the group header in the new column if the column printing is set to print across then down? That's the way it seems from my testing -- it will repeat the headings in column 2 if I set it to Down the Across, but not if it's set to Across then Down (same report). I was wondering if anyone can confirm this, because I can't seem to find it documented anywhere.
