drill Down with charts

[syncdba]

Hi,
I'm new to Crystal reports. I'm trying to create a report with a chart. I'm trying to show Total Amount($)
for each month(eg aug'05,Nov'05,Dec'06..).Now I'm facing two problems;
1. I want if someone click on july month Vertical Bar it will give him only July chart & same with other months.
2. I'm getting a big blue vertical bar for jan'06.feb'06....How can I get no Vertical bar for these months.
I hope I explained my problem properly if not please let me know. i will try again.

 

[BobSuruncle]

If you create a group chart, it's possible to drill down to the group that you double-click on in the chart.
In order to create a group chart, you must have 2 things:
1. Groups
2. Summarized values

You'd likely hide your details section and the group header. In the hidden group header, you'd have the chart for just that group.

I'm not sure what you're talking about when you say you've got big blue vertical bars.

Let us know what version of Crystal you're working with, what groups you've created, what summaries you've created, etc.
It would be good to see the data you're starting with and how you'd like it to end up looking.



Bob Suruncle

 

[syncdba]

When I double click on one of the month(july)I see the data(Cust_date) & cus_credit columns) but not the vetical chart's bar. I cant drill down the chart to group footer.I hide the detial & Group header sections.
I'm using
Cust_date cust_credit
2004-09-12 $4567
2005-05-14 $60000
2005-04-29 $38900
2004-08-30 $23567...
I did "On change of" as Close Month & "show" as Sum of command.cust_credit.

I have vertical bars as Close months(Cust_date) which is Aug2005,Sept2005,Oct2005,Nov2005,Dec2005,jan2006,Feb2006,March2006...i'm using this SQL
select cus_cd,cus_active_dt,
case
when cus_active_dt between '2005-07-31' and '2005-08-31' then 'August 2005'
when cus_active_dt between '2005-08-31' and '2005-09-30' then 'September 2005'
when cus_active_dt between '2005-09-30' and '2005-10-31' then 'October 2005'
when cus_active_dt between '2005-10-31' and '2005-11-30' then 'November 2005'
when cus_active_dt between '2005-11-30' and '2005-12-31' then 'December 2005'
when cus_active_dt between '2005-12-31' and '2006-01-31' then 'January 2006'
when cus_active_dt between '2006-01-31' and '2006-02-28' then 'February 2006'
when cus_active_dt between '2006-02-28' and '2006-03-31' then 'March 2006'
when cus_active_dt between '2006-03-31' and '2006-04-30' then 'April 2006'
when cus_active_dt between '2006-04-30' and '2006-05-31' then 'May 2006'
when cus_active_dt between '2006-05-31' and '2006-06-30' then 'June 2006'
when cus_active_dt between '2006-06-30' and '2006-07-31' then 'July 2006'
end as CloseMonth
from customer..
the first vertical bar(blue) has all the data I dont want like 2004 customer_date.
I tried to explain my problem.Please let me know if its fine.