Link to home
Start Free TrialLog in
Avatar of qbjgqbjg
qbjgqbjgFlag for United States of America

asked on

crystal reports - charts

I have a report that is grouped By fund within acct type(Revenue or Expense) .
Is there any way to to make 2 charts and have 1 for Revenue and one for Expense. (Instead of both showing on the same chart)?
Avatar of Mike McCracken
Mike McCracken

Are you grouping by type (Expense/Revenue) then by fund?

If so put the chart in the Expense/Revenue group header or footer

mlmcc
Avatar of qbjgqbjg

ASKER

Unfortunately they want the charts at the bottom of the report.
Is there a way to eliminate groups with a 0 total?  I thought I could add a formula that will just have a value for expense and one for revenue(if {Scenario.ACCT_TYPE} = 'E' then {Scenario.SUMTot} else 0)
ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
This report is already a subreport.
I got some help from Ken Hamady. I created 2 formulas, 1 for exp total, and 1 for  revenue total.  I used a cross-tab for each chart. This worked perfectly.
See my entry below for my solution. Thanks for your help.