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

cross tab design

edited June 2004 in End User
Hi!

1. How can I remove top row from the cross tab from you samples:
---------------------------------------------------------------
|Sum of amount| Year of sale date|
|
|State | 1998 |1999| ....... |Grand
Total|
|BC | 17840 .........

The report should look like
---------------------------------------------------------------
|State | 1998 |1999| ....... |Grand
Total|
|BC | 17840 .........

2. How can I streach the repoprt to fit the page width? In a case when with
varios number od columsn, the report should always fit the page width.

Comments

  • edited June 2004
    I am using Matrix object to control the appearance of the cross tab, but I
    can't hide 'Year of sale date' label:
    the code is below:

    Also I want to completely remove first row. How can I do this?

    procedure TForm1.ppCrossTab1AfterCalc(Sender: TObject);
    begin
    // This code should hide label 'Year of sale date', but for the unknown
    reason it isn't work.
    TppCrossTab(Sender).Matrix.CaptionVisible[1,0]:= False;

    { This code works fine, but I didn't want to hide this columns
    TppCrossTab(Sender).Matrix.CaptionVisible[0,0]:= False;
    TppCrossTab(Sender).Matrix.CaptionVisible[1,0]:= False;
    TppCrossTab(Sender).Matrix.CaptionVisible[2,0]:= False;}
    RemoveBorder(Sender, 0, 2);
    RemoveBorder(Sender, 0, 1);
    RemoveBorder(Sender, 0, 0);
    end;
  • edited June 2004

    Sorry, but the built-in formatting capabilities of the Crosstab are limited.
    Neither of the features that you are request are currently implemented. The
    RBuilder\Demos\Crosstabs example reports show what events are available and
    how to use them.

    The other option is create a custom crosstab renderer class. The default
    renderers are located in RBuilder\Source\ppCTRend.pas


    --

    Thanks for supporting ReportBuilder! Please vote for ReportBuilder in the
    Delphi Informant Readers Choice awards!

    http://www.delphizine.com/ballot2004/


    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
This discussion has been closed.