---
title: "How used  the sum function in crystal reports"  
description: "How used  the sum function in crystal reports"  
author: "Kenny Tangnde"  
published: 2011-09-09  
updated: 2011-10-20  
canonical: https://www.mindstick.com/forum/306/how-used-the-sum-function-in-crystal-reports  
category: "c#"  
tags: ["c#"]  
reading_time: 3 minutes  

---

# How used  the sum function in crystal reports

hi all,

i have a [product](https://www.mindstick.com/articles/75385/full-product-keys) [table](https://www.mindstick.com/articles/43918/how-to-design-table-using-bootstrap) ,i [already](https://yourviews.mindstick.com/view/88453/the-hidden-ways-ai-is-already-controlling-your-daily-life) achieve subtotal [function](https://www.mindstick.com/articles/13001/multi-statement-table-valued-user-defined-function-in-sql-server) [field](https://www.mindstick.com/forum/160867/does-mindstick-provide-training-for-field-marketing) ,but [now](https://yourviews.mindstick.com/view/81402/it-s-liberals-vs-progressives-in-us-politics-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](https://www.mindstick.com/forum/159332/how-can-i-use-sum-in-linq)({Product_Tb.Product Quantity} * {Product_Tb.Product Price}\
)\
but crystal [reports](https://www.mindstick.com/blog/11576/magento-reports-extension) prompt [error](https://yourviews.mindstick.com/view/88527/fixing-quickbooks-error-4120-reinstalling-vs-repairing):here need one the field

thanks in advance.\

## Replies

### Reply by Uttam Misra

Here you go Mohan..\
**Join MindStick Beginners Section..\**https://www.mindstick.com/DeveloperSection/Beginner

### Reply by mohan kumar

Can anyone briefly explain how to use crystal reports formula section..I want to know the formula section of the Crystal reports from scratch..

### Reply by Anonymous User

Hi Aken,\
\
You can download Visual Studio 2010 Express Edition here:\
[http://www.microsoft.com/visualstudio/en-us/products/2010-editions/express](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](http://www.microsoft.com/visualstudio/en-us)

### Reply by Kenny Tangnde

hi Rohit Kesharwani,

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

thanks.

### Reply by Kenny Tangnde

hi Rohit Kesharwani ,

you can provide link address?

thanks.

### Reply by Anonymous User

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.

### Reply by Chris Anderson

hello aken,

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

### Reply by Kenny Tangnde

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.

### Reply by Kenny Tangnde

hi Rohit Kesharwani ,

thanks for your answer.

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

thanks.\

### Reply by Chris Anderson

Hello aken..

You can achieve the total function by using Running Total Field:\
\

**For running total field see this link:\** \

https://www.mindstick.com/Articles/614/running-total-field-in-crystal-report 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.

### Reply by Kenny Tangnde

hi Rohit Kesharwani

i want achieve used sum function statistical all subtotal.

### Reply by Chris Anderson

hi,\
Colud you please tell me on which basis you want to make total of subcategory.\
Could you will explain me in more details.


---

Original Source: https://www.mindstick.com/forum/306/how-used-the-sum-function-in-crystal-reports

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.