Skip to Content
avatar image
Former Member

How to create summary on the formula.

I created a formula in CRystal Reports 2013. When I tried to insert a summary I do not see the insert option. Can you please tell me how I can insert a summary on a formula.

Thank you.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Jul 20, 2017 at 10:41 PM
    You can't summarize on Whileprintingrecords formulas, but only on Whilereadingrecords, so the easiest way to check your formula is to have:

    Whilereadingrecords;

    at the top of your formula and CR will tell you what Function in the formula is causing the problem.

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 20, 2017 at 09:24 PM

    Hi Natalia,

    If your formula is already using a summary function like SUM or Count then it can't be summarized. What you will need to do is change your formula to use a running total. Then you can summarize to the running total instead.

    If you are not familiar with running totals and variables, do a search through the help. It has a detailed example on how to start it.

    Good luck,

    Brian

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 25, 2017 at 08:44 PM

    Thank you. Actually my formula was not using summary function, and it did not error out, but was wrong and could not be used in total. Thank you though.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 25, 2017 at 08:44 PM

    Thank you. Actually my formula was not using summary function, and it did not error out, but was wrong and could not be used in total. Thank you though.

    Add comment
    10|10000 characters needed characters exceeded