• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Totals on a grid tab

David Robertson

Reputable Poster
G-day list,

I am having problems with totalling in an B7332 sp7_obj application grid(P09200).

When the user switches between different tabs on the grid, it behaves as if the "Find" button had been clicked, and reloads the grid (to resequence the grid as per the selected tab).

However, the event rules associated with the "find" button are not processed, which clear the totals that are accumulated. This causes the totals to be added to, and therefore incorrect.
There does not appear to be any point at which to insert logic to clear the totals under these circumstances.

If the user changes forms, he needs to immediately then press the "find" button so that the totals are reset. This is not a very elegant solution.

Any ideas greatly appreciated.

Regards,
David
 

Zoltan_Gyimesi

Legendary Poster
David,

Changing the grid format (tab on grid) will trigger the Write Grid Line-Before event and you can catch it.
You have to create and manage a flag to detect the first occurence of this event and move your "Find" logic into an IF bracket into the beginning of the mentioned event.

Please, share your results with us on the Forum. Thanks.

Good luck,
Zoltán

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)
 

Zoltan_Gyimesi

Legendary Poster
David,
I have just tried: the Grid Record is Fetched event will be also triggered, so you can use it also.
Zoltán

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)
 
Top