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
 
You must log in or register to reply here.

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

Similar Threads

Xtab queries in reports - again Duane 1
Reports with cross tab queries 2
repeating subreport header on report 0
FAO Duane Hookom - Reports using Cross Tab Queries 1
Creating a sub report with variable number of fields to print 2
Limiting Decimal Places in Report 2
reports and queries 10
Grouping a report 1

Back
Top