Group Footer with multple aggregate rows

Comments

• gordk St.Catherines On. Canada.

  February 2011 edited 4:00PM

  not clear what you mean by adding rows.
  but maake sure that the band properties are set correctly.
  ie stretching allow split etc.
• Monte Carver

  February 2011 edited February 2011

  What I mean by multiple rows is I would like to show several aggregates within the group footer, for example:
  
  Maximum of Day >> XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX
  Minimum of Day >> XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX
  Average of Day >> XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX
  Std Dev of Day >> XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX
  
  I am finding that it is not likely a setting problem, because if I copy the MAX or MIN "rows" for the AVG "row" then the copied row appears as expected. But as soon as I start changing the copied MAX syntax to AVG or SUM, then somewhat the AVG rows disappears, or rendering only produces the first page with no footer, etc. Furthermore, if I replace one of the first row MAX objects with AVG or SUM, the value is terribly wrong. So. I believe the problem is somehow associated with the SUM or AVG producing the wrong values. In fact if I delete all objects in the group footer and place a single object with AVG syntax, I still get the incorrect value. The AVG of 35 rows of 80 degrees is not hard too check against [img]style_emoticons/<#EMO_DIR#>/smile.gif" style="vertical-align:middle" emoid=":)" border="0" alt="smile.gif" /> So... Please what am I doing wrong? My feeling that this is somehow a bug. But I would think an aggregate bug would have been flushed out long ago. Also, I am running against XP sp/3 Delphi 2009 FR 4.10.1 SQL Server 2008 R2 Regards, Monte Carver[/img]
• Mick.pl

  February 2011 edited 4:00PM

  Are standard MasterData / Footer bands the only solution that you may use?
  If not then try to use DBCross with several calculations of your own in Total row while still having one value in each row.
  
  I gave an example how to solve a similar problem in other topic.
  See the link below:
  
  [topic="7162"]DBCross - how to make an additional summary row?[/topic]
  
  Look first at PDF file to see how DBCross can make addictional sum / avg etc.
  And if you find it is interesting then you may download the FR3 definition I enclosed over there.
  
  Mick
• gordk St.Catherines On. Canada.

  February 2011 edited 4:00PM

  You should take a look at what Mick has sugessted it may better suit your needs.
  as to not seeing rows
  
  Maximum of Day >> XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX
  Minimum of Day >> XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX
  Average of Day >> XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX
  Std Dev of Day >> XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX XX
  
  This appears to be
  one tfrxmemoview with multiple lines of text and\or expressions
  the memoview stetchmode must be set and the bands stretch property must also be set.
  or you will get what you describe.
  the only exception to band stretching is the pagefooter band it is not stretchable.
  
• Monte Carver

  February 2011 edited 4:00PM

  I am actually using a tfrxmemoview memo for each calculation and one for each of the text descriptions. It sounds like you are suggesting that this approach should work.