Click here to Skip to main content
11,581,852 members (71,950 online)
Rate this: bad
good
Please Sign up or sign in to vote.
HI, Iwant to calculate page sum in page footer and show same amount in next report headder
ie My column Amount look like
in page1

Amount
-----------------
1
2
5
6
---
sum:14


page 2

Amount
-------------
b/F:14
-----
10
6
10
----
sum:40

iam tried this in
allsumFormula: WhilePrintingRecords ;
shared numberVar totalsetPsum;
shared numberVar totalPiecesPSum;
shared numberVar totalAmountPSum;
totalsetPsum:=totalsetPsum+{sp_report_select_view_madeup_shipping_instruction_details;1.totalsetreg}; totalPiecesPSum:=totalPiecesPSum+{sp_report_select_view_madeup_shipping_instruction_details;1.totalpcsreg}; totalAmountPSum:=totalAmountPSum+{sp_report_select_view_madeup_shipping_instruction_details;1.value};

in
sumheadder: WhilePrintingRecords ;
shared numberVar totalsetPsum; if PageNumber <>1 then totalsetPsum-{sp_report_select_view_madeup_shipping_instruction_details;1.totalsetreg};
but in odd and even pages they give different value
Posted 3-Oct-12 19:58pm
rajin kp1.9K
Edited 3-Oct-12 20:37pm
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 330
1 Sergey Alexandrovich Kryukov 165
2 virusstorm 109
3 Frankie-C 105
4 F-ES Sitecore 85
0 OriginalGriff 1,273
1 Sergey Alexandrovich Kryukov 900
2 Abhinav S 617
3 F-ES Sitecore 500
4 Suvendu Shekhar Giri 433


Advertise | Privacy | Mobile
Web04 | 2.8.150603.1 | Last Updated 4 Oct 2012
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100