report from crosstab query

  • Thread starter Thread starter javablood
  • Start date Start date
J

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,

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,
 
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.
 
Thanks Duane.
--
javablood


Duane Hookom said:
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.
Click to expand...
 
Back
Top