Xtab queries in reports - FAO Duane

  • Thread starter Thread starter Malcolm
  • Start date Start date
M

Malcolm

After a long term illness I am revisiting reports built in
Access 2000.

I have built up a report which uses a sub report
containing a cross tab query to allow for a variable
number of column names depending on when the report is run.

The alias table shows all the level (page) numbers and the
corresponding set of column titles for all the levels.

The xtab query when viewed on its own has all the relevant
data for the required levels.

However when the report is viewed, some of the levels (Not
all) are displayed over the top of each other i.e. page 2
displays level 2 and level 3 data over the top of each
other, with the heading for level 3.

Hope this is relatively clear, and can anybody help.

Malc
 
The only thing that comes to mind is there might be code in some section of
report like:
Me.MoveLayout = False
 
Back
Top