HOW USED THE SUM FUNCTION IN CRYSTAL REPORTS

Kenny Tangnde

Total Post:68

Points:476
Posted by  Kenny Tangnde
C# 
C#
 13343  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. Chris Anderson

    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. Kenny Tangnde

    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. Chris Anderson

    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. Kenny Tangnde

    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.

     

     

  1. Kenny Tangnde

    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.

  1. Chris Anderson

    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. Awadhendra Tiwari

    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. Kenny Tangnde

    Post:68

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

    hi Rohit Kesharwani ,

    you can provide link address?

    thanks.

  1. Kenny Tangnde

    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. mohan kumar

    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!