afrausto
Posts: 66
|
| Posted: 07/17/2006, 3:53 PM |
|
Hello,
I'm using the current version of CCS/ASP and I'm trying to see if anyone has tried to keep a running total within an editable grid. I'm would like to show a list of grant applications in an editable grid where when I change the status for a record to 'Granted' it adds the amount that would be awarded into a running total at the top of the page. Of course, when you page between pages it should keep the running total as the status' are changed. Has anyone done something to this affect?
Thanks,
Albert
|
 |
 |
WKempees
|
| Posted: 07/17/2006, 5:25 PM |
|
To give you directions:
In the before show of the grid, or the before show of the runningtotal
label, you will have to do a
CCDLookup("SUM(field)","tablename","status="Granted",Yourconnection)
|
|
|
|
afrausto
Posts: 66
|
| Posted: 07/18/2006, 10:30 AM |
|
Thanks for the suggestion. I hadn't thought of that, but that would work as an option.
What I was hoping to accomplish is to have the running total change, in real-time as records status' are changed to"Granted". I'm thinking it would require java scripting to accomplish that, but with an editable grid it would be difficult to track individual status changes as one moves from page to page. Any thoughts anyone?
Thanks.
|
|
|
|
|
