Print Page | Close Window

Calculate a Data Field from the Details Section

Printed From: Crystal Reports Book
Category: General Information
Forum Name: Announcements
Forum Discription: Please check this section for the latest announcements from Crystal Reports Forum
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=13449
Printed Date: 02 May 2024 at 5:54pm


Topic: Calculate a Data Field from the Details Section
Posted By: dgcrystal
Subject: Calculate a Data Field from the Details Section
Date Posted: 08 Jun 2011 at 7:33pm
Greetings,

Hello guys, I`m very new to Crystal Report and I hope I could find my answers here within this community.

I created a report in Crystal Report 11, and I added a database connection to an Access2007 Table. Then I dropped an AREA field from that table into the Details Section of my report. So now I can show all the records from that table in my report.

The question is:
I want to add the sum of this AREA field on the Report Footer Section in order to get the total area. How I can do that in Crystal Report software?

Please advise...


Replies:
Posted By: sudh
Date Posted: 11 Jul 2011 at 7:37am
following steps can be reach out the requirement:
 
Solution1:
 
1.Create running on the fied that you want to calculate.
2.Drag running total to report footer section of the report.
solution 2: 
 
1.Create below formula on the field that you wanted to calculate,
    Sum(field name).
2.Place formula in the report footer section.
 
Thanks,
Sudh.

Posted By: dgcrystal
Date Posted: 11 Jul 2011 at 6:23pm
Thank you Mr. Sudh for your perfect reply, I tried it and it worked fine.


Print Page | Close Window