C# .NET - Crystal Report: Sum of a field Page Wise
Asked By Yogesh Mishra on 25-Jun-12 10:02 AM
I have a crystal report having fields ID, Name, Address, Salary.
I Want total of salary per page on the report footer.
How can i do that?
DL M replied to Yogesh Mishra on 25-Jun-12 11:54 PM
Check this article
----------------
http://www.codegain.com/articles/crystalreports/general/how-to-use-running-total-fields-in-crystal-report.aspx
Jitendra Faye replied to Yogesh Mishra on 26-Jun-12 12:32 AM
Add this formula in report footer
=Sum(ReportItems("ColumnName").Value)
Try this and let me know.
TSN ... replied to Yogesh Mishra on 26-Jun-12 12:43 AM
hi.... try the below one...
Create a formula field TOTAL1 and edit this code:
WhilePrintingRecords;
NumberVar SALARYTOTAL;
SALARYTOTAL := 0;
Place TOTAL1 in page header section.
Create a formula field TOTAL2 and edit this code:
WhilePrintingRecords;
NumberVar SALARYTOTAL;
SALARYTOTAL:= SALARYTOTAL + {field01}; //IN YOUR CASE IT IS field01 is SALARY
where field01 is the field to summarize.
Place TOTAL2 in details section.
Create a formula field TOTAL3 and edit this code:
WhilePrintingRecords;
NumberVar SALARYTOTAL;
Place TOTAL3 in page footer.
TSN ... replied to Yogesh Mishra on 26-Jun-12 12:44 AM
Create a formula field TOTAL1 and edit this code:
WhilePrintingRecords;
NumberVar SALARYTOTAL;
SALARYTOTAL := 0;
Place TOTAL1 in page header section.
Create a formula field TOTAL2 and edit this code:
WhilePrintingRecords;
NumberVar SALARYTOTAL;
SALARYTOTAL:= SALARYTOTAL + {field01}; //IN YOUR CASE IT IS field01 is SALARY
where field01 is the field to summarize.
Place TOTAL2 in details section.
Create a formula field TOTAL3 and edit this code:
WhilePrintingRecords;
NumberVar SALARYTOTAL;
Place TOTAL3 in page footer.
Yogesh Mishra replied to DL M on 26-Jun-12 02:29 AM
Hi DLM,
This link does not provide me thing what I actually want.
Actually When I am at first page it works quite good but at second page it preserve the total of first page and add the sum of second page total to it.
I want total of salaries per page separately.
RAJASEKHAR RAJENDRAN replied to Yogesh Mishra on 27-Jun-12 08:26 AM
Hi Yogesh,
You can get the Page Total in the Crystal Report in the footer as in the below link.
http://www.effegidev.com/post/Page-Total-in-Crystal-Report.aspx
Thanks & Regards,
Rajasekhar.R
There is a field called "Total I have summed up the individual values of this field "Total Cost" in the group footer for each group, which give me aggregate total cost of each group at the group footer .Now I want to summarize the report with just Dept name i.e group name and the aggregate total (sum of total cost field of that group) in the report. . . keywords: Crystal Report Report Footergrouping, VB.NET, database, report, Dept description: Crystal Report Report Footer
In my crystal report format Under the group footer of system, two box objects are closing . But the problem is that if my report contains more than two pages of the particular system, in the first page these objects i think it is because of that these box objects are closing in the group footer), but at the last page it is appearing. . Is there any way to set the
Hi I have created crystal report in my application which gives the invoice report.Now if the invoice lines are more than 10 ite goes to the next page the bottom so please help Thank You. I think you can achieve it by adding Footer to crystal report . So just add Footer and in that footer add your invoice total. So on each
HII I have a problem when i export a report from crystal report to excel data only format(xls), the report header doesnt present in the excel document . . Does any one have a solution. . Please help header would be present what u need to do is: In excel click on "view" > footer and header hi check this link http: / / infynet.wordpress.com / 2010 / 10 / 06 / crystal-report-in-c / keywords: report, crystal report description: CRYSTAL REPORT HII I have a problem
There is a field called "Total I have summed up the individual values of this field "Total Cost" in the group footer for each group, which give me aggregate total cost of each group at the group footer .Now I want to summarize the report with just Dept name i.e group name and the aggregate total (sum of total cost field of that group) in the report. . . To only show a summary hide the detail and group header sections and only show
hi I have installed crystal report in visual studio 2010. I want to create a report but don't know the procedure to create a report using crystal report. guide me Hi Swapneel, Hope this helps; sorry for the long post bit I get
i am new to crystal report .ho0w to create crystal report in c# .net2.0.what are reference can i add?what are steps are available have covered here are : 1) Introduction 2) Getting a feel of it - Using an existing Crystal Report file in your .aspx page 3) Crystal Reports Walkthrough - using the Pull Model 4) Crystal
Hi! I want to create Crystal Report with heading, i am using ASP.Net 2005 can anyone explain with detailed and examples and also i want to take the printout it. Thanks You can create a Crystal Report by using three methods: 1. Manually i.e. from a blank document 2. Using Standard Report Expert 3. From an existing report Using Pull Method Creating Crystal Reports Manually. We would use the following steps to implement
HI this is the first time that i will use crystal report , i have dont have database but just a datatable wich was created manually , how can i create a report using this datatable , if any one help me that will be great , im waiting , thanks for advance HI Crystal Reports Without Database Usually Crystal Reports we are using to fetch data from database and show it as a report. Here we are going to generate a Crystal Reports without using a datbase . For generating
How is it possible to display the contents of the group footer(in my case it is a double line) in every page . Now it is showing only at the end of the report. If you only want the double-lines, you can just expand the page footer and copy / create them there. The Design tab (on the left edge) shows five sections of the report: Report Header - -- -Displays the content on first page of the report Page Header - -- -Displays the content