How used the sum function in crystal reports

Total Post:68

Points:476
C# 
C#
 14054  View(s)
Ratings:
Rate this:

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.

  1. Post:65

    Points:455
    Re: How used the sum function in crystal reports

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

  1. Post:68

    Points:476
    Re: How used the sum function in crystal reports

    hi Rohit Kesharwani

    i want achieve used sum function  statistical all subtotal.

  1. Post:65

    Points:455
    Re: How used the sum function in crystal reports

    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.

      Modified On Mar-18-2016 04:56:11 AM
  1. Post:68

    Points:476
    Re: How used the sum function in crystal reports

    hi Rohit Kesharwani ,

      thanks for your answer.

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

    thanks.

     

     

      Modified On Mar-29-2018 04:36:54 AM
  1. Post:68

    Points:476
    Re: How used the sum function in crystal reports

    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.

      Modified On Mar-29-2018 04:37:13 AM
  1. Post:65

    Points:455
    Re: How used the sum function in crystal reports

    hello aken,

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

  1. Post:126

    Points:882
    Re: How used the sum function in crystal reports

    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.

  1. Post:68

    Points:476
    Re: How used the sum function in crystal reports

    hi Rohit Kesharwani ,

    you can provide link address?

    thanks.

      Modified On Mar-29-2018 04:37:25 AM
  1. Post:68

    Points:476
    Re: How used the sum function in crystal reports

     hi Rohit Kesharwani,

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

    thanks.

  1. Post:10

    Points:70
    Re: How used the sum function in crystal reports

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

  1.   Modified On Mar-14-2016 08:22:15 AM

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!