Sponsored By
DataConverter
Advertise with Us
Advertisement
Advertise with Us
Follow Us
Follow _MindStick_ on Twitter View MindStick Software's LinkedIn profile View MindStick Software's Facebook profile
Mindstick
Article Article  Forum Forum  Blog Blog  Quiz Quiz  Beginner Beginner  Careers Careers  Contact Contact  Login Login  
Home | Product | Services | About Us | Interview | DeveloperSection | Submit an Article | Submit Blog
Report Abuse Form
Reason:    
   

Home >> .Net >> C# >> How used the sum function in crystal reports
Author Post

aken H


Total Post: 66
Member Since: 9/6/2011
Points: 419
How used the sum function in crystal reports
Posted On: 9/9/2011 10:50:19 PM

hi all,

  i have a product table ,i already achieve subtotal function field ,but now i want achieve total a function.
my subtotal function is:{Product_Tb.Product Quantity} * {Product_Tb.Product Price}
then how  will  to total a function achieve,
i try below "total"function:
sum({Product_Tb.Product Quantity} * {Product_Tb.Product Price}
)
but crystal reports prompt  error:here need one the field

thanks in advance.

Author Post

Rohit Kesharwani


Total Post: 54
Member Since: 8/8/2011
Points: 385
Re: How used the sum function in crystal reports
Posted On: 9/10/2011 12:39:31 AM
hi,
Colud you please tell me on which basis you want to make total of subcategory.
Could you will explain me in more details.
Author Post

aken H


Total Post: 66
Member Since: 9/6/2011
Points: 419
Re: How used the sum function in crystal reports
Posted On: 9/10/2011 2:48:39 AM

hi Rohit Kesharwani

i want achieve used sum function  statistical all subtotal.

Author Post

Rohit Kesharwani


Total Post: 54
Member Since: 8/8/2011
Points: 385
Re: How used the sum function in crystal reports
Posted On: 9/10/2011 8:32:57 AM
Report Abuse Answer

Hello aken..

You can achieve the total function by using Running Total Field:
For running total field see this link:
http://www.mindstick.com/Articles/d482235f-3777-44d6-9599-5b790444e851/?Running Total Field in Crystal Report

For the above problem:
Right click on running total field-->Select New-->Put the Formula(created qty * price) from the left pane to Field to summarize field and select sum from the Type of summary dropdownlist--click ok.

After this drag the running field and drop it into footer section of the report. Finally you can see a total in footer section.

Thanks.

Author Post

aken H


Total Post: 66
Member Since: 9/6/2011
Points: 419
Re: How used the sum function in crystal reports
Posted On: 9/11/2011 3:38:26 AM

hi Rohit Kesharwani ,

      thanks for your answer.

other,can you  provide a vs2010 professional edition link address  give me.

thanks.

 

 

Author Post

aken H


Total Post: 66
Member Since: 9/6/2011
Points: 419
Re: How used the sum function in crystal reports
Posted On: 9/11/2011 3:52:53 AM

hi Rohit Kesharwani ,

i looked your blog article,me to very appreciate you write article.
Unfortunately I can not use vs2010 some crystal reports functional.

Error:Failed to load properly "Microsoft.Data.Entity.Design.BootstrapPackage.BootstrapPackage,Microsoft.Data.Entity.Design.BootstrapPackage,Version=10.0.0.0,Culture=neutral,PublicKeyToken=b03f5f7f11d50a3a" package.

Author Post

Rohit Kesharwani


Total Post: 54
Member Since: 8/8/2011
Points: 385
Re: How used the sum function in crystal reports
Posted On: 9/12/2011 1:05:02 AM

hello aken,

i think you do not install a VS 2010 properly or not using a proper setup to install.

Author Post

Awadhendra Tiwari


Total Post: 126
Member Since: 1/19/2011
Points: 893
Re: How used the sum function in crystal reports
Posted On: 9/12/2011 5:34:16 AM

Hi aken H

You need to check System.Data.Entity dll. You can try by replacing this dll via microsoft site.

Maybe ur application starts working.

 

Thanks.

Author Post

aken H


Total Post: 66
Member Since: 9/6/2011
Points: 419
Re: How used the sum function in crystal reports
Posted On: 9/12/2011 9:52:07 AM

hi Rohit Kesharwani ,

you can provide link address?

thanks.

Author Post

aken H


Total Post: 66
Member Since: 9/6/2011
Points: 419
Re: How used the sum function in crystal reports
Posted On: 9/13/2011 12:49:06 AM

 hi Rohit Kesharwani,

you used VS2010 is what edition, where are from download,can you provide download address.

thanks.

Author Post

Haider M Rizvi


Total Post: 40
Member Since: 6/6/2010
Points: 291
Re: How used the sum function in crystal reports
Posted On: 9/13/2011 5:36:50 AM
Hi Aken,

You can download Visual Studio 2010 Express Edition here:
http://www.microsoft.com/visualstudio/en-us/products/2010-editions/express

Or, if you want to get other versions then visit:
http://www.microsoft.com/visualstudio/en-us
Author Post

mohan kumar


Total Post: 10
Member Since: 10/19/2011
Points: 51
Re: How used the sum function in crystal reports
Posted On: 10/20/2011 4:41:52 AM
Can anyone briefly explain how to use crystal reports formula section..I want to know the formula section of the Crystal reports from scratch..
Author Post

Uttam Misra


Total Post: 113
Member Since: 6/2/2010
Points: 818
Re: How used the sum function in crystal reports
Posted On: 10/20/2011 6:39:33 AM
Here you go Mohan..
Join MindStick Beginners Section..
http://www.mindstick.com/Beginner/ContentPage.aspx?cdata=Crystal+Report
Report Abuse Form
Reason:    
 
Total Online Users: 7311
Advertisement
MindStick DataConverter
Advertise with Us
  
Copyright © 2009 - 2013MindStick. All Rights Reserved.