Click to See Complete Forum and Search --> : page totals in crystal report
shrikant smart
March 23rd, 2004, 08:36 AM
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.com
malleyo
March 23rd, 2004, 09:32 AM
In 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.
harmonycitra
March 26th, 2004, 01:16 PM
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.
codeguru.com
Copyright WebMediaBrands Inc., All Rights Reserved.