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.
Uttam Misra
20-Oct-2011Join MindStick Beginners Section..
https://www.mindstick.com/DeveloperSection/Beginner
mohan kumar
20-Oct-2011Anonymous User
13-Sep-2011You 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
Kenny Tangnde
13-Sep-2011hi Rohit Kesharwani,
you used VS2010 is what edition, where are from download,can you provide download address.
thanks.
Kenny Tangnde
12-Sep-2011hi Rohit Kesharwani ,
you can provide link address?
thanks.
Anonymous User
12-Sep-2011Hi 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.
Chris Anderson
12-Sep-2011hello aken,
i think you do not install a VS 2010 properly or not using a proper setup to install.
Kenny Tangnde
11-Sep-2011hi 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.
Kenny Tangnde
11-Sep-2011hi Rohit Kesharwani ,
thanks for your answer.
other,can you provide a vs2010 professional edition link address give me.
thanks.
Chris Anderson
10-Sep-2011Hello 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.
Kenny Tangnde
10-Sep-2011hi Rohit Kesharwani
i want achieve used sum function statistical all subtotal.
Chris Anderson
10-Sep-2011Colud you please tell me on which basis you want to make total of subcategory.
Could you will explain me in more details.