Active TopicsActive Topics  Display List of Forum MembersMemberlist  Search The ForumSearch  HelpHelp
  RegisterRegister  LoginLogin
General
 MetaMatica Forum : General
Subject Topic: Running Totals... Post ReplyPost New Topic
Author
Message << Prev Topic | Next Topic >>
MartyMed
Newbie
Newbie


Joined: 06 December 2008
Online Status: Offline
Posts: 3
Posted: 28 December 2008 at 12:14pm | IP Logged Quote MartyMed

Any ideas on how to implement running totals in a detail band. Something like...

1st line $10    $10

2nd line $8     $18

3rd line  $7     $25

etc...

Back to Top View MartyMed's Profile Search for other posts by MartyMed
 
administrator
Admin Group
Admin Group
Avatar

Joined: 01 October 2003
Online Status: Offline
Posts: 46
Posted: 28 December 2008 at 1:13pm | IP Logged Quote administrator

Do you want to have acumulative sum of some value on the each detail band? This is possible. See this example.
This example based on "Demo Report" and shows how you may have different colors on each detail row.
I have added the total value on each row. It calculates current total of salary field.

How I did this:
See title band. Right click on the band and select the "scripts". You can see this:
SETVAR('MYTOTAL',0)

Next go to the scripts of the detail band (before print):
SETVAR('MYTOTAL',GETVAR('MYTOTAL') + Dataset1.SAL)

Next, put onto detail band an expression field with expression:
getvar('MYTOTAL')

That's all.

You you need the comments about colors of detail band, just let me know.


Edited by administrator on 29 December 2008 at 8:53am


__________________
Oleg Yershov
Back to Top View administrator's Profile Search for other posts by administrator Visit administrator's Homepage
 

If you wish to post a reply to this topic you must first login
If you are not already registered you must first register

  Post ReplyPost New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

Powered by Web Wiz Forums version 7.91
Copyright ©2001-2004 Web Wiz Guide

This page was generated in 0.0635 seconds.