Report columns shifted to the right

P

Perkon

Using Access 2003. I have a report that just lists (up to) six columns of
(up to) five rows of calendar dates. Each column consists of dates within a
week. The record source is a simple query consisting of calendar dates and
their associated "week parts" and there is no code involved. There is a
"week header" (no controls and a height of 0") that I just use to group by
the week. A new column is forced when the week changes. There is a report
header that just contains labels for weeks one through six. When running the
report, the detail section (where the dates appear) is shifted one column to
the right (so the first column always appears blank). The labels in the
report header appear where they should. I found that if a page header is
inserted (even with no controls and a height of 0.0007"), all of the columns
appear as they should. Remove the page header or reduce its height to zero,
and the detail section shifts right again. Problem is...I need to use this
report as a subreport. Since page headers apparently aren't recognized when
a report is used as a subreport, the columns always appear shifted when used
as a subreport in a main report. Any help would be greatly appreciated.
 
M

Marshall Barton

Perkon said:
Using Access 2003. I have a report that just lists (up to) six columns of
(up to) five rows of calendar dates. Each column consists of dates within a
week. The record source is a simple query consisting of calendar dates and
their associated "week parts" and there is no code involved. There is a
"week header" (no controls and a height of 0") that I just use to group by
the week. A new column is forced when the week changes. There is a report
header that just contains labels for weeks one through six. When running the
report, the detail section (where the dates appear) is shifted one column to
the right (so the first column always appears blank). The labels in the
report header appear where they should. I found that if a page header is
inserted (even with no controls and a height of 0.0007"), all of the columns
appear as they should. Remove the page header or reduce its height to zero,
and the detail section shifts right again. Problem is...I need to use this
report as a subreport. Since page headers apparently aren't recognized when
a report is used as a subreport, the columns always appear shifted when used
as a subreport in a main report. Any help would be greatly appreciated.


I am unable to reproduce that behavior in AXP so I probably
can not help. However, you might be able to get around the
issue by setting the group header section's NewRowOrCol
property to None and setting the group footer section's
NewRowOrCol property to After Section???
 
P

Perkon

Thank you...that did the trick. I didn't have a group footer for that
section initially. I'll be in trouble with a colleague here if I don't
acknowledge that she came up with the same solution. (Can't believe it
didn't occur to me to try that in the first place.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top