more doubts about DBCrossTab

Comments

• gordk St.Catherines On. Canada.

  November 2004 edited 3:52PM

  go to page 85 of the usermanual.pdf file.
  
• Gibaleno

  November 2004 edited November 2004

  I read many times the manual and nothing there answer my questions.
  
  1) There is no answer to define the row header width (i try several alternatives, but no one work properly), the OnCalcWidth apply only to columns not to row header (first column of the dbcrosstab object, e.g. Employee Name).
  
  2) In the manual is described a way to format the Grand Total values, but if I format in then cross tab editor, on the report preview an error occur, fastreport try to format the title "Total" with the numeric mask, intead of format the values.
  This error occur when I execute do program on the Delphi IDE.
  
  The fast-report version is 3.06 trial and I??m using the DbCrossTab object.
  
  Thanks!
• JKoeller

  November 2004 edited 3:52PM

  i have the same problem with the first column width (row header), i cannot set the width.
  
  i have dbcrosstab report with 5 columns (1 row header + 4 cols) plus grand total, the first column (text) can have 250 chars, but i want to set the width to 450 pixels.
  
  OnCalcWidth i can set all the columns width, except the first column (row header), how can i do this??
  
  thx,
  
  J Koeller.
  
  
• AlexTZ

  November 2004 edited 3:52PM

  Change the frxCrossMatrix.pas file:

  procedure TfrxCrossMatrix.CalcBounds;
  ...
  begin
    ColumnItems := FColumnHeader.TerminalItems;
    RowItems := FRowHeader.TerminalItems;
  
    { calculate the widths of columns and the heights of rows }
    FColumnHeader.CalcSizes(FMaxWidth, FMinWidth);
    FRowHeader.CalcSizes(FMaxWidth, FMinWidth);
  ...
  

  
  Now you can set the MaxWidth/MinWidth properties to limit the width of the row header.
  
• Gibaleno

  November 2004 edited 3:52PM

  I can't do this because I'm using the FR3 trial, but I'm happy because now I know that this is possible.
  
  Thanks!