Problem with groupFooter

Roberto Marra

Hi there,
Im pretty new with ReportSharpShooter and Im getting mad...

Got a report

pageHeader
groupHeader1 (group over CustomerName)
groupHeader2 (group over invoiceNumber)
detail
groupFooter2 (group over invoiceNumber)
groupFooter1 (group over CustomerName)
pageFooter

Now.. in the detail everything is show properly, in the groupFooter2 I got some field that works with aggregate and with those no problem, but I got as well 2 field where are the result of 2 query (one per field) based on the invoiceNumber. To be more clear let say there ia a simple query that do something like SELECT spcPrice FROM OINV.. WHERE DocNum =" & txtDocNum & "..

Then still in the groupFooter I make a calculation with those 2 field, like (txtQty*txtSpcPrice) and I want the result of this calculation to be added to another field of the groupFooter2, something like

txtGlobalTotInv.Value = detail1.SUM(aggregate...)+(txtQty*txtSpcPrice) or
txtGlobalTotInv.Value = detail1.SUM(aggregate...)+txtTMP.Value, where txtTMP.Value is the result of (txtQty*txtSpcPrice)


But there is no way I always see the sum of the aggregate but without the txtTMP value...

I tried to check with some MsgBox the value of this field and I saw that I got min 6 times the Message Box result, some with 0 and some with the value...

Everything works fine with just one record, but with more than one...no way...


I don't have any idea how to fix or solve that..

Hope somebody can help me

Cheers
Roberto

Philipp Knecht

Hi Roberto

Please check in the Properies tree if your field txtTMP gets executed before the field which is depending on it.
If not put it with the ordering Tpoolbarbuttons of the designer into the correct position.

In general it's not a good idea to make fields depending on others because you have take care of the rendering sequence.

There is also a new concept introduced with Groupbands.

It's already usable from 1.52. But if you want to try it out i can recommend you the new Beta Version (Send us the Installation Id if you are interested)

hth

Roberto Marra

Hi Philipp,
first of all thx for replying me.

You said

"put it with the ordering Tpoolbarbuttons of the designer into the correct position"

but I don't know which toolbarbutton you are talking about... I tried to find it out but I couldnt ( I got the version 3.5.1)

I read on the Perpetuum software website that the groupFooter is obsolete as well as the aggregate... hope I don't have to rebuild everything once I got the new version.

Cheers
Roberto

Roberto Marra

Sorry Philipp,
I found it.

Thnx I will try and let you know if still I got problem

Cheers
Roberto

Roberto Marra

Phillipp want just to confirm that everything is working now

Thnx Man :P

Philipp Knecht

Hi Roberto

No Problem. You are welcome.
Btw. Groupfooters will be supported in the engine ;)