Drawing a grid on a Report

S

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
 
D

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.
 
S

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top