dynamic crosstab report and page numbering

[Guest]

I have set up a dynamic crosstab report, as described in Q328320.
This works, until I add page numbering (="Page " & [Page] & " of " & [Pages])
Then the report displays but the dynamically created crosstab columns are
all duplicated - instead of x records I get the same record x times.
In fact it is [Pages] that causes the problem ="Page " & [Page] works.
I tried to paste the report as a subreport to another blank report, so I
could page number the main report, but I get the error
"You can't use a pass through query or a non-fixed-column crosstab query as
a record source for a sub-form or report", even though I am not trying to
link the main and sub reports. (Link master fields and link child fields are
blank).
As a workaround I tried to do the page numbering programatically, but all
the resources I've found say to get the total pages by using [Pages], which I
can't.
The really annoying thing is that I'm sure I had this working last week...

 

[Duane Hookom]

I don't care for that solution for creating a crosstab report. I think it is
slow, inflexible, and has too much code. You might want to look at the
solution in the Crosstab.mdb found at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4. This method is faster,
has less code, and accommodates any number of columns.