slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

Architect Forums - SalesLogix Scripting & Customization
Forum to discuss writing script in Architect plugins for SalesLogix & general SalesLogix customization topics (for Windows client only). View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to SalesLogix Scripting & Customization | New Thread

View: Search:

Author

Thread: Sub totals in editable datagrid

Steve Knowles
Posts: 657

Sub totals in editable datagrid Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 26 Apr 07 6:15 AM

I have an editable datagrid. I would like to show subtotals for some of the fields. My plan is to show the subtotal in text box under the grid.

1. The problem is that no events seem to fire when changing the value in the datagrid cell to fire my calulation code. Am I missing something? Is there an event that fires when a user edits a grid cell?

2. Is there some undocumented way the grid will calculate and display the total in a footer? Some of the events seem like they might make this possible, but no documentation seems to exist.

Thanks

[Reply][Quote]

Bob (RJ)Ledger
Posts: 1103

Re: Sub totals in editable datagrid Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 26 Apr 07 7:02 AM

The datagrid has a ShowSummaryFooter property. You can have it do sums for you automatically.... HOWEVER.. you have to select "Sortable" or it will not work since sortable how you get the entire recordset loaded into memory.

Just lookup ShowSummaryFooter in the Architect Help file

--
rjl

[Reply][Quote]

Steve Knowles
Posts: 657

Re: Sub totals in editable datagrid Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 26 Apr 07 7:13 AM

Sweeet. I saw ShowSummaryFooter but didn't see the little 'Footer' button in column properties.
Is it possible to store the footer values in the db?
Thanks RJ.

[Reply][Quote]

Kris Halsrud
Posts: 88

Re: Sub totals in editable datagrid Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 27 Apr 07 10:26 AM

You could take the recordset from your grid, loop through it and sum up a column:

dim objrs
dim dbltotal

dbltotal = 0

set objrs = datagrid.recordset
with objrs
while not (.eof or .bof)
dbltotal = dbltotal + cdbl(.Fields("SALESPOTENTIAL").Value)
.movenext
wend
.close
end with
set objrs = nothing

txtTotal.text = dbltotal

This kind of thing would work if your grid is bound or not. There are other ways to handle this if your grid is bound and the values you are trying to sum are already written to the DB (i.e. running a SQL query with a sum statement)

[Reply][Quote]

Bob (RJ)Ledger
Posts: 1103

Re: Sub totals in editable datagrid Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 28 Apr 07 7:03 AM

Quote:

Originally posted by Steve Knowles

Sweeet. I saw ShowSummaryFooter but didn't see the little 'Footer' button in column properties.
Is it possible to store the footer values in the db?
Thanks RJ.

The are "display only". You have to write your own code to to that .
--
rjl

[Reply][Quote]

Steve Knowles
Posts: 657

Re: Sub totals in editable datagrid Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 28 Apr 07 7:42 AM

Can I access the totals through code? I am ok writing to the db myself, just not sure how to grab the totals.. thx

[Reply][Quote]

Bob (RJ)Ledger
Posts: 1103

Re: Sub totals in editable datagrid Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 29 Apr 07 12:00 PM

AFAIK you cannot access the footer totals since they are display only.
--
rjl

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2025 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 6/18/2025 8:36:34 AM