Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

I am using the chart expert , my Chart Layout choices are disabled

Status
Not open for further replies.

MENON

Programmer
Jul 23, 2001
28
US
Please let me know how I can Enable my Chart Layout Buttons, I also would like to know How I can create an application with a Pie chart, thereby when I click on the Chart I can Pop up a Drill down Report.
 
Are they disabled on a brand new chart or just when changing existing charts?

If you create a group chart and hide the details, you can drill down on the chart to the details. Ken Hamady
Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)
 
THIS IS NOT AN ANSWER TO THE ABOVE PERSON'S PROBLEM

However,I am having the same problem too; both when creating a report in Report Expert and trying to insert a chart object into an existing report with a group sort.

The report selects records by date range.
The details are boolean fields (T or F).
The summary fields are counts of the 'T' detall records and are in a group sorted by date; the counts are reset at change of month.

When inserting the chart, the Running Totals are counts of the records (Layout=Advanced), not the counts of 'T'values.

I want to set Layout = Group so that the bars represent the group totals. All other Layout choices beside Advanced are disabled.

Help?

Thanks in advance...Matt Galbraith (mgtech)
 

In the fields you are attempting to chart on, are there variables used in the formulas?

-David
 
The fields I am trying to do the bar chart on are Running Totals fields which have a formula in the "Evaluate" section of the Running Totals editor. the formula looks at a boolean result: T or F. The count is incremented by 1 if the result is T. That would be the only "variable" I can think of. Thanks for responding.

Matt (mgtech)
 
Use a conditional total (Subtotal of an if-then formula) instead of a running total and you can do a group chart for the existing groups of the report. Conditional totals are described in faq149-243. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB
tek@kenhamady.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top