Drawing a grid on a Report

[Sarah]

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

 

[Duane Hookom]

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.

 

[Sarah]

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