Home General
New Blog Posts: Merging Reports - Part 1 and Part 2

Croos Tab

edited October 2001 in General
Hi,

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

Thanks.

Comments

  • edited October 2001
    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


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

    Thanks
    Ailton

  • edited October 2001
    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


  • edited October 2001
    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

  • edited October 2001
    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


This discussion has been closed.