Announcements
 Crystal Reports Forum : General Information : Announcements
Message Icon Topic: Calculate a Data Field from the Details Section Post Reply Post New Topic
Author Message
dgcrystal
Newbie
Newbie


Joined: 08 Jun 2011
Online Status: Offline
Posts: 2
Quote dgcrystal Replybullet Topic: Calculate a Data Field from the Details Section
    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...
IP IP Logged
sudh
Newbie
Newbie


Joined: 11 Jul 2011
Location: India
Online Status: Offline
Posts: 6
Quote sudh Replybullet 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.


Edited by sudh - 11 Jul 2011 at 7:38am
IP IP Logged
dgcrystal
Newbie
Newbie


Joined: 08 Jun 2011
Online Status: Offline
Posts: 2
Quote dgcrystal Replybullet Posted: 11 Jul 2011 at 6:23pm
Thank you Mr. Sudh for your perfect reply, I tried it and it worked fine.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.030 seconds.