Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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?

Former Member
replied

OK. SO all the summaries are being calculated in the SQL Query, aren't they?

You can create a formula that looks like this:

Sum({grptotal}, {Group_field}) / {GrandTotal}

Insert a Chart and use this field as the 'Show Values'. Next, go over to the Options tab > Check 'Show Value' > Select 100%

-Abhilash

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question