Xtab queries in reports - again Duane

[Malcolm]

Hi

If Duane answers this, thanks for the prompt reply.

On searching the coding for the report (original message
below), I have found the following code:

Option Compare Database

Private Sub Detail_Format(Cancel As Integer, FormatCount
As Integer)
Me.MoveLayout = False
End Sub

Private Sub Report_NoData(Cancel As Integer)
Cancel = -1
MsgBox "No data found for selected Project in the time
period."
End Sub

Changing the "False" to "True" only seems to make it
worse. Can anyone suggest anything?

I should point out that using Access reporting is only a
small part of my work, so I am really a novice.

Thanks in advance.

Malcolm

Original message:

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?

 

[Duane Hookom]

I am not sure why the line of code is in there and what it is doing. My
crosstab reporting solution with "levels" doesn't include this code.