How to take the page totals of a report in Crystal Report 5.0 
Author Message
 How to take the page totals of a report in Crystal Report 5.0

Hi All,
It is really a shame for me to ask this question because it seems very much
easy. I tried variety of ways to take the totals of a field in Page footer,
but it did not work (it took all the totals of the records).
Please Help Me.



Sat, 27 May 2000 03:00:00 GMT  
 How to take the page totals of a report in Crystal Report 5.0

What you need here is 3 formulas with a memory variable

This formula goes in the page header format it to be suppressed(not
printed)
WhilePrintingRecords;
NumberVar myTotal :=0;

This formula goes in the detail line also formatted to be suppressed
WhilePrintingRecords;
NumberVar myTotal;

myTotal := myTotal + <<Field that is to  be totaled>>;

In the footer  this formula formatted to be visable
WhilePrintingRecords;
NumberVar myTotal;
myTotal;

Where you will get into trouble. You will forget the Full Colin  before the
equal sign and the report will compile but the values will not total.
You will not terminate each of the statements  with a semi colin and
crystal will complain when you try to save the formula.
You will leave out the line "WhilePrintingRecords;" and the report will
work for a while and then when you change something totally unrelated it
will crash.



Thu, 01 Jun 2000 03:00:00 GMT  
 How to take the page totals of a report in Crystal Report 5.0

Use then 'WhilePrintingRecords' command in the formula where you sum
the field.

Thomas

On Tue, 9 Dec 1997 11:04:19 +0200, "Turhan Ganiz"

Quote:

>Hi All,
>It is really a shame for me to ask this question because it seems very much
>easy. I tried variety of ways to take the totals of a field in Page footer,
>but it did not work (it took all the totals of the records).
>Please Help Me.




Fri, 02 Jun 2000 03:00:00 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Report generation takes a LOOOOONG time for 7-page report

2. Report generation takes a LOOOOONG time for 7-page report

3. Total Page value in Crystal Report

4. Crystal Reports.NET Total Page Count

5. Crystal Report Page Total

6. TOTAL PAGES USING CRYSTAL REPORTS 4.6

7. CRYSTAL REPORTS 6 (32bit) - Total Page Count Problem

8. Total page count in crystal Report 4.6

9. IIS 5.0 + Crystal Report 8.5 = Web reporting?

10. Summarising data from sub-reports in Crystal Reports Pro 5.0

11. Report takes 15 minutes to print from VB 5.0 app

12. Crystal Reports (two page reports)

 

 
Powered by phpBB® Forum Software