Skip to Content
avatar image
Former Member

Field not getting summarized...

Hello All,

I have few fields in my report out of which if i right click on one field it dosen't show me an option to insert Summary.

What could be the reason?

Thanks

Neeshi

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Apr 01, 2016 at 09:25 AM

    Hello Neeshi,

    Do you have any Local, Global or Shared variable in that formula?

    If so then I am afraid you will not be allowed to insert the summary for those variable.

    In that case you will have to create the summary manually like below shown as example in the detail section.

    WhilePrintingRecords;

    NumberVar yourVariable;

    NumberVar SummaryVariable;

    SummaryVariable:=SummaryVariable+yourVariable;

    yourVariable;


    and then on the Group where you want to display the summary just write this formula;


    WhilePrintingRecords;

    NumberVar SummaryVariable;

    Make sure you reset the variable after displaying it into a sub section below where you displayed that.

    WhilePrintingRecords;

    NumberVar SummaryVariable:=0;

    Let me know if this helps.

    Regards

    Niraj

    Add comment
    10|10000 characters needed characters exceeded

    • Summaries are allowed to be inserted off of formulas that have variables declared as Local or Global.

      Formulas marked as 'WhilePrintingRecords' however, cannot be used to insert summaries irrespective of what the scope of the variables are.

      -Abhilash

  • Apr 01, 2016 at 08:58 AM

    Hi Neeshi,

    Is this a formula field that you're trying to insert a summary on?

    You can't insert a summary on formula fields that use print-time functions or have summary functions inside them.

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 01, 2016 at 02:11 PM

    Also, summaries are not allowed on the various types of BLOB fields, including SQL Server Text fields, Oracle CLOB fields, etc.

    -Dell

    Add comment
    10|10000 characters needed characters exceeded