Print Page | Close Window

Subtotal of a column for a single page

Printed From: Crystal Reports Book
Category: Crystal Reports .NET 2003
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=16168
Printed Date: 29 Apr 2024 at 4:47pm


Topic: Subtotal of a column for a single page
Posted By: AngeloF
Subject: Subtotal of a column for a single page
Date Posted: 13 Apr 2012 at 5:47am
Hi all !

I have a question for you :

How Can I insert a total for a column in the footer of each page?

thanks for all suggestions


Replies:
Posted By: lockwelle
Date Posted: 17 Apr 2012 at 6:06am
some would say a running total, I would say shared variables...they do the same thing.  For some reason, running totals confuse me, DBlank uses them all the time.
 
shared variables would be something like:
page header formula:
shared numbervar tot:=0;
"" //hides the output
 
detail formula:
shared numbervar tot;
tot := tot + {table.field};
"" //again to hide the running total output.
 
page footer formula:
shared numbervar tot;
tot;
 
 
HTH

Posted By: AngeloF
Date Posted: 17 Apr 2012 at 10:15pm
Originally posted by lockwelle

some would say a running total, I would say shared variables...they do the same thing.  For some reason, running totals confuse me, DBlank uses them all the time.
 
shared variables would be something like:
page header formula:
shared numbervar tot:=0;
"" //hides the output
 
detail formula:
shared numbervar tot;
tot := tot + {table.field};
"" //again to hide the running total output.
 
page footer formula:
shared numbervar tot;
tot;
 
 
HTH


Print Page | Close Window