Sunday, August 10, 2014

Page wise total in Crystal Report


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 + CDbl ({field01})  


where field01 is the field to summarize & CDbl is converting.
Place TOTAL2 in details section.

Create a formula field TOTAL3 and edit this code:

 WhilePrintingRecords;  
 NumberVar total;  



Place TOTAL3 in page footer.


you can also see This

 
 











vfpoledeb.1 provider is not registered on the local machine

Have u Install VFP Ole DB Provider in your System ? If No then Please Install it from following link. http://www.microsoft.com/download...