report from crosstab query

[javablood]

Help! I have a report based on a crosstab query. The query returns a column
(parameter) and a number of other columns for dates sampled and the body is
the concentration of the sample, e.g.,

PARAMETER 1/1/08 2/1/08 3/1/08 4/1/08 . . .
acetone 5 2 10U 10U
benzene 4 2 5U 5U
..
..
When the sample dates exceed the page width (8.5), the data overflows to the
next page; however, the PARAMETER column does not repeat. How do I get the
PARAMETER column to repeat for each succeeding page? I have looked
everywhere but have not found anything on this and it may be beyond my novice
skills.

 

[Duane Hookom]

Apparently you need to display more dates than can fit across the page. There
is a fairly complex yet flexible solution at
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=11. You could
also add another Row Heading that groups by a specific number of dates.

Since your column headings are dates, I would use the solution at
http://www.tek-tips.com/faqs.cfm?fid=5466, changing month intervals to days.

 

[javablood]

Duane,

Thanks for your quick reply. Yes, typically there is a sample collected
every month and my annual report has to show all the sample results. I
looked at your first solution a bit ago but since it wraps around on a single
page I did not think it would apply, or at least did not see how it would.
And I am not sure how the 2nd solution would work.

My rows fill an entire page so I would need to "wrap" the PARAMETER column
into the next page. I found a work around in which I copied the control for
the PARAMETER at the different page breaks and this somewhat works but messes
up the format of the last colum of the pages before the break.

Is there anything like the Repeat Columns/Rows as in Excel? That is what I
need but I do not want to export into Excel. I just migrated all the data
from numerous Excel table to allow me more functionality and efficiency.

Thanks,

 

[Duane Hookom]

I would probably use the tek-tips solution.
If you wanted to display up to 12 columns of monthly data, you could group
by year and then use months as column headings. If you could display 24
months, then use a calculation that groups by alternate years as a row
heading.

As a last ditch effort, you could paste the results of the query into an
Excel file for printing.

 

[javablood]

Thanks Duane.
--
javablood

I would probably use the tek-tips solution.
If you wanted to display up to 12 columns of monthly data, you could group
by year and then use months as column headings. If you could display 24
months, then use a calculation that groups by alternate years as a row
heading.

As a last ditch effort, you could paste the results of the query into an
Excel file for printing.