How do Vertical bands work

Comments

• gpi

  March 2017 edited 11:33PM

  Use Master-Detail-Subdetail datasets
  Order Master dataset by department field, Detail dataset - unique values of the years values, subdetail - Av values
  Add TfrxGroupHeader, TfrxMasterData, vertical TfrxHeader and TfrxMasterData
  Assign horizontal TfrxMasterData with master dataset, vertical TfrxMasterData - with Detail dataset
  Place static columns from Master dataset on the vertical TfrxHeader, Av fields - on the vertical TfrxMasterData band

  wrote:

  And to add to this, i need the table to change page horizontly if the amount of collumns does not fit on the page.

  Attach a sample what you mean
• gpi

  March 2017 edited 11:33PM

  wrote:

  I tried using the DBCross-tab object, but i need the table to allways occupie the full page width even if it as to strech the columns

  It seems you will need a complex calculations during report's preparing to calculate width of columns in the report's script
• Jo??o Ferreira

  May 2017 edited 11:33PM

  Thanks for the help gpi, but i made a few changes, worked with the query, and made this report another way.
  
  But my main problem persists, i still have no clue on how vertical bands work, they seem to be a possible solution for some of my problems, since most of my reports are table's with a variable number a columns.
  
  Is there any documentation that explains how vertical bands work, or any type of course, training... something that explains this component?
• gpi

  May 2017 edited 11:33PM

  Vertical bands is old (from FR2 since 1998) and unstable feature. You may find samples with vertical bands in the FRDemo. See "Old-style crosstab" and "Calendar" reports
• Jo??o Ferreira

  May 2017 edited 11:33PM

  Thank you very much GPI.
  
  Unfortunately that means that i will continue to have a lot of trouble with grid designs, since one of the company rules regarding reports, is that grids must always use the full page width, no matter how many columns it as, in some cases we use a single column stretch to fill the empty space, like a name column, and on other case, we fill with empty grayed out columns. Also no cells must be left open, like what happens when a cross-tab splits horizontally.
• gpi

  May 2017 edited 11:33PM

  Try to use TfrxDBCrossView placed on band on TfrxReportPage with endless height and endless with. Print prepared report with TfrxReport.PrintOptions.PrintMode = pmScale
• norcalgal

  April 2018 edited 11:33PM

  gpi wrote: »

  Vertical bands is old (from FR2 since 1998) and unstable feature. You may find samples with vertical bands in the FRDemo. See "Old-style crosstab" and "Calendar" reports

  
  I'm in the demo right now and I don't see a 'calendar' example anywhere. Version 20 18.2.24