borderAndreaVB free resources for Visual Basic developersborder

borderAndreaVB Visual Basic and VB.NET source code resources - Copyright © 1999-2010 Andrea Tincaniborder

AndreaVB | Forum | News | Downloads | Register | Help | Member List | Statistics | Search | PM | Profile

Print This Topic
Previous Topic (vb.net pass parameters to crystal reports)Next Topic (How to loop through a table and bind data to formula fied to lay data out horizontally) New Topic New Poll Post Reply
AndreaVB Forum : Reporting tools : page totals in crystal reports
Poster Message
boit
Level: Scholar

Registered: 28-04-2005
Posts: 43

Ads by Lake Quincy Media
icon page totals in crystal reports

masters, inquiry on getting total figures of certain database fields per page on crystal reports 9.2

thanks in advance

05-01-2007 at 05:10 AM
View Profile Send Email to User Show All Posts | Quote Reply
trilok31bhuraita
Level: Trainee

Registered: 05-03-2009
Posts: 1
icon Re: page totals in crystal reports

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.

05-03-2009 at 04:24 PM
View Profile Send Email to User Show All Posts Visit Homepage | Quote Reply
AndreaVB Forum : Reporting tools : page totals in crystal reports
Previous Topic (vb.net pass parameters to crystal reports)Next Topic (How to loop through a table and bind data to formula fied to lay data out horizontally) New Topic New Poll Post Reply
Surf To:


Not Logged In? Username: Password: Lost your password?
Partners: Download Actual Software | Free Software Download
borderAndreaVB free resources for Visual Basic developersborder

borderAndreaVB Visual Basic and VB.NET source code resources - Copyright © 1999-2010 Andrea Tincaniborder