DBCross - how to make an additional summary row?

m.stefaniak

Urgent!

I have to have two GrandTotal Row: Sum and second - average.

How to make additional summary row with average of columns data.

I looked for in manuals and I found nothing like this.

I thought about
DBCross1.OnPrintCell event. There I can use

if DBCross1.IsGrandTotalRow(RowIndex) then

and do something like value := value+#13+MyAvgData
but I can not change printed data.

Can anyone give me a tip how to do it?

thx
M.

gordk

you can't
to have 2 rows you must have a 2 row matrix, which requires 2 fields in the row quadrant of the cross matrix editor

Mick.pl

I used compiled demo of FR 4 (see JPG) as it has demo database which helped me to test my idea.
Look first at PDF then at source fr3.

I use OnCalcHeight, OnPrintCell and IsGrandTotalRow.

PS.
Thank you for inspiration [img]style_emoticons/<#EMO_DIR#>/smile.gif" style="vertical-align:middle" emoid=":)" border="0" alt="smile.gif" /> Mick[/img]