Saturday, February 25, 2012

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.

No comments:

Post a Comment