Cross tab

rbuser

Thanks Jim,

But could you please, give some introduction of how to use OnEndPage event
to change the height of the rows.

In your alternative answer, you can change the width of the columns, but the
height of the rows you can't change.

I still don't know how to change the height of a row. Could you please help
me?

Thanks

digitalmetaphors

Please, don't repost on a new thread, thanks, unless you feel we've
inadvertently missed seeing your prior post:)

If you change the font size of the cells in the crosstab, you can get a
smaller crosstab with more rows per page. If you need the font to be a
specific height, then you could generate the crosstab using a point size of
say, 4pt., and then in the OnEndPage event you can change then fonts back to
a larger more readable font. Access Report.Engine.Page to get the current
page object. The page has a Drawcommands array property you can loop
through, you'll want to use the DrawCommandCount property for your loop.
Look for TppDrawText objects and see if their Font.Size property is set to 4
pt. Then you can change the font size property back to your original font
size.


Cheers,

Jim Bennett
Digital Metaphors