Prev: A Year to Date Report Question
Next: Summing a column in a report
From: Sarah on 20 Mar 2010 09:05
greetings

I have a report based on a Crosstab query. Both the Query and the Report
work just fine. They have 2 row headers on the left side of the table and a
variable number of PivotField headers.

I've been asked to have the Report's table in a grid when printed. Normally
I would just use line segments to draw this grid. BUT, the number of
PivotFields varies from Report to Report, so I'm having difficulty getting
the grid to work. My supervisor wants the grid to end with the LAST COLUMN.
I'd like to know:

a) What is the best way to compute how many Pivotfields a Query will have?

b) How should I approach the drawing of the grid?

thank you in advance for any tips. I'm not experienced enough at coding to
know how to handle this properly.
Sarah

From: Duane Hookom on 20 Mar 2010 11:19
First, how are you creating your report if your number of columns will vary?
Have you thought about just using the border of the text boxes to create the
grid?
It might help if you provided the SQL view of the crosstab.
--
Duane Hookom
MS Access MVP


"Sarah" <Sarah(a)discussions.microsoft.com> wrote in message
news:0B6AFF7D-1B10-42F6-8948-0674455BE194(a)microsoft.com...
> greetings
>
> I have a report based on a Crosstab query. Both the Query and the Report
> work just fine. They have 2 row headers on the left side of the table and
> a
> variable number of PivotField headers.
>
> I've been asked to have the Report's table in a grid when printed.
> Normally
> I would just use line segments to draw this grid. BUT, the number of
> PivotFields varies from Report to Report, so I'm having difficulty getting
> the grid to work. My supervisor wants the grid to end with the LAST
> COLUMN.
> I'd like to know:
>
> a) What is the best way to compute how many Pivotfields a Query will have?
>
> b) How should I approach the drawing of the grid?
>
> thank you in advance for any tips. I'm not experienced enough at coding
> to
> know how to handle this properly.
> Sarah
>
From: Sarah on 20 Mar 2010 18:30
hi Duane
The number of columns varies because the table is based on a Crosstab query,
so the number of PivotFields can be more or less. In any case, I've found
that the max number of Pivotfields is 16, so I've decided to make the grid
that size and leave 'squares; blank if not needed. Thank you for your
assistance. -Sarah

"Duane Hookom" wrote:

> First, how are you creating your report if your number of columns will vary?
> Have you thought about just using the border of the text boxes to create the
> grid?
> It might help if you provided the SQL view of the crosstab.
> --
> Duane Hookom
> MS Access MVP
>
>
> "Sarah" <Sarah(a)discussions.microsoft.com> wrote in message
> news:0B6AFF7D-1B10-42F6-8948-0674455BE194(a)microsoft.com...
> > greetings
> >
> > I have a report based on a Crosstab query. Both the Query and the Report
> > work just fine. They have 2 row headers on the left side of the table and
> > a
> > variable number of PivotField headers.
> >
> > I've been asked to have the Report's table in a grid when printed.
> > Normally
> > I would just use line segments to draw this grid. BUT, the number of
> > PivotFields varies from Report to Report, so I'm having difficulty getting
> > the grid to work. My supervisor wants the grid to end with the LAST
> > COLUMN.
> > I'd like to know:
> >
> > a) What is the best way to compute how many Pivotfields a Query will have?
> >
> > b) How should I approach the drawing of the grid?
> >
> > thank you in advance for any tips. I'm not experienced enough at coding
> > to
> > know how to handle this properly.
> > Sarah
> >
 | 
Pages: 1
Prev: A Year to Date Report Question
Next: Summing a column in a report