Adding Total Column in Crystal Report

Posted Date: 30 Nov 2009 Posted By:: sayedaly

Member Level: Silver Member Rank: 2911 Points: 1 Responses: 2

Hi All

I'm Retiring data dynamically and displayed in database.Now I want to Sum the columns that retrieved in Report.If anyone knows kindly revert ASAP.It'll be helpful for me.

Regards,
Sayed

Responses

#448591 Author: Lalji Member Level: Gold Member Rank: 130 Date: 30/Nov/2009 Rating: Points: 2
You could create a formula in Crystal that has values from both fields thn add that in the cross tab.

#448652 Author: MuhiReks Member Level: Gold Member Rank: 76 Date: 30/Nov/2009 Rating: Points: 2
1. Intialise the variable in Page header `WhilePrintingRecords; NumberVar Amount :=0` 2. Create formula field and placed in detail ex `WhilePrintingRecords; NumberVar Amount := Amount + CDbl ({Table1.5});` Table1.5 is column name , which we have to sum 3. In footer , create another formula field ex.. `{@GrossSum}-CDbl ({Table1.5})` @grossum is formula field which created in details field table1.5 is column hope this help! thnx Muhil

Post Reply

This thread is locked for new responses. Please post your comments and questions as a separate thread.
If required, refer to the URL of this page in your new post.

	Next : Is it possible to use microsoft dll's in JAVA
	Previous : Hi
	Return to Discussion Forum
	Post New Message
	Category:

Related Messages

Active Members
Today

Last 7 Days

more...

Awards & Gifts

Email subscription

Talk to Webmaster Tony John