Croos Tab

rbuser

Hi,

(RB Pro 5.56)
How can I change the height and width in a Crosstab report.?

Thanks.

digitalmetaphors

You can set the crosstab properties:
ParentWidth = False
and
Stretch = False
Then resize the height of the crosstab to the area you wish to have it print
statically in the band.


Cheers,

Jim Bennett
Digital Metaphors

rbuser

I'm sorry. but my question was wrong, I mean, I want to know how to change
the columns properties.

Thanks
Ailton

digitalmetaphors

You can't natively. The crosstab has autosizing columns. You could
manipulate these in the OnEndPage event by accessing the draw commands for
the lines and texts in the crosstab. A better approach would be to create
and register your own crosstab renderer with RB, however, that is not the
easiest thing to do. Yoav, on General thread 9/16/2001 created a crosstab
renderer which would write to a text file.

Cheers,

Jim Bennett
Digital Metaphors

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

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