Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
We have one report which shows the employee wise account details in a crosstab.
 
The problem we are facing is the output goes on multiple pages and the grand total appears only on last page.
 
Is there any method by which we can have a page wise running total on each page?
 
Any other solution with horizontal column grouping will also help...
 
I need to use CROSSTAB as the number of columns and rows is variable.......
Posted 24-Sep-12 1:59am
Edited 24-Sep-12 4:13am
Nueman8.3K
v2
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

may help you...
Create a formula field TOTAL1 and edit this code:
WhilePrintingRecords;
NumberVar total;
total := 0;
Place TOTAL1 in page header section.
 
Create a formula field TOTAL2 and edit this code:
WhilePrintingRecords;
NumberVar total;
total := total + {field01};
where field01 is the field to summarize.
 
Place TOTAL2 in details section.
 
Create a formula field TOTAL3 and edit this code:
WhilePrintingRecords;
NumberVar total;
Place TOTAL3 in page footer.
 
also please visit...
http://csharp-guide.blogspot.in/2012/06/crystal-reports-crosstab-report.html[^]
  Permalink  
v2
Comments
rosyp at 24-Sep-12 15:42pm
   
very nice
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

there is an option in crystal report to add footer. on footer click left then u can see insert on top.select insert then you can see special field select that , on special fields you can see Page N of M.
 
'Page N of M' is a inbuilt function to show the number of pages like 'page 2 of 10'.
  Permalink  
Comments
Member 10351824 at 28-Oct-13 7:13am
   
Thanks

its i nice code.

But if i want to one page total. How can i do?
vasim sajad at 16-Nov-13 1:35am
   
i didn't get u what u meant
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 3

Thanks
 
its i nice code.
 
But if i want to one page total. How can i do?
  Permalink  

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



Advertise | Privacy | Mobile
Web03 | 2.8.140926.1 | Last Updated 28 Oct 2013
Copyright © CodeProject, 1999-2014
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