Can't chart on a formula????

[jdemmi]

I am pretty knowledgable when it comes to Crystal reporting but a rookie when it comes to Crystal Charts/Graphs.

Here's why question/problem.

I have a report which is really just a bunch of counts (running totals) and formulas (calculates points based on the counts). The report has a subreport which passes data back to the main report (using shared number variables).

My data is OK and the correct values are being passed back to the main report.

Here's where the problem comes in. I am now trying to chart some of the data, but the "field" I want to display is not listed in the available fields of the Chart Expert.

This is happening for several fields but the one I REALLY need is a formula.

The formula is based on several other forumlas, some of which are based on values which are passed from the subreport back to the main report (using the shared variables I mentioned above).

Any ideas on why I cannot choose this formula for my chart? Could I have too many "nested" formulas (formulas based on other formulas)?





-- Jason
"It's Just Ones and Zeros

 

[rosemaryl]

Dear jason,

You cannot chart on print time formulas. In the help file, go to Index, and do a search for "multi-pass reporting flow charts"

The chart shows when things happen in Crystal. Since graphs and printime formulas happen in the same pass, you cannot chart on them.

A work-around does exist for version 9 and higher and here is the kb article:

http://support.businessobjects.com/...pers/cr9_charting_print_time_formulas.pdf.asp

regards,
ro

Rosemary Lieberman
rosemary-at-microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

You will get answers more quickly if you read this before posting: faq149-3762