Skip to Content
avatar image
Former Member

How do I make a Formula Available to a Chart in CR11.0?

Hi all.  I have Crystal 11.0.  There are some report examples that I installed when I installed CR11.0.  One sample report is with Charts.  I opened up the sample to confirm something.  I'm more confused than before I viewed the sample!  🤣  Specifically, I'm talking about the Gantt chart's usage of a computed formula field.

From my various "Googles" for how to do a Pareto Chart, I saw recommendations that I needed to do the chart inside a subreport because I want to pass in a formula that does a percentage computation.  The instructions were to pass in the formula as a subreport link and then the chart would "see" the formula because it was now a parameter.

I opened the chart example to see how it was done.  The charts were in group headers.  When I viewed Gantt chart in the chart expert, I saw all the formulas listed alongside the fields from the "Customers" and "orders" tables.

So I tried to emulate this.  I placed my formula in the details section and then suppressed printing of it.  I inserted a chart directly into the group header as I saw in the sample.  In the chart expert, my formula is not visible in the list of fields.  The sample report has formulas.  Why does my custom report not also have access to my own formulas within the chart expert?  How do I get my own report to behave like the sample chart report?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 30, 2015 at 06:10 PM

    Hi Debbie,

    The difference could be the functions you've used in the formula on your report.

    Could you paste the code you've used please?

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Abhilash Kumar

      You're a genius, Abhilash.  Thanks so much!  I don't know why I couldn't see that.  You made my life so much easier!  Since I already have those fields in the Query, I'm just adding the percentage into the query too.  Duh!  Man, I'm kicking myself for wasting so much time on Crystal formulas.