Showing posts with label totals. Show all posts
Showing posts with label totals. Show all posts

Saturday, February 25, 2012

Page totals in last page

Friends,
I am working on a report where I have to print all the page totals, in the last page.
Could you please give us some sort of solution.
Regards
JCYou need to use Three formulae
Formula1 Reset having the code

Whileprintingrecords;
numbervar x:=0;
Formula2 Sum having the code
whileprintingrecords;
numbervar x:=Tonumber(x+DatabaseField);
Formula3 Display having the code
whileprintingrecords;
numbervar x;
Place Formula1 at Page Header
Place Formula2 at Details section
Place Formula3 at Page Footer

Now suppress Formula1 and Formula2

page totals in crystal report

hello everybody,
i am a new user to crystel report. i am using the crystal
report with vb. i have a report with some groups and
sub-groups. i want to print pagewise totals on each page.
pl show me the way.
thanks
shrikant
shrikant_smart@.rediffmail.comIn Crystal Reports 8.5, click Insert, Field Object. This will bring up a list of field objects. Expand 'Special Fields' and you can see your options of 'Page Number', 'Total Page Count', 'Page N of M', etc. Just drag and drop onto your report and position where you want it.|||I don't know this is the proper way or not. any way this will display page viz totals.

Create Formula named tot1

code:

WhilePrintingRecords;
NumberVar total;
total := 0

formula 2 : tot2

WhilePrintingRecords;
NumberVar total;
total := total + {amount};

formula 3 : tot3

WhilePrintingRecords;
NumberVar total;

Use the same variable name.

place tot1 is page header section. This will reset the total value to 0 for each and every page.

Place tot2 in details section. This will add the values.

Format both as suppressed.

Place the tot3 in Page Footer section. This will display page viz total.

Page Totals in Crystal Report

I want have Page Totals on a field in my report. Can anybody help me out.There's a section called 'Special Fields' located in the same area where you would add a Field or a Formula to your report. The Special Fields contain fields such as 'Print Date', 'Print Time', 'Page N of M', 'Page Number', 'Total Page Count', etc... In Crystal Reports 8.5, this can be found under Insert, Field Object menu item.