Changing Legend in Group Pie Chart in 8.0 1

[week]

I am using a Group Chart (grouping records and doing one slice per group) for my Pie Chart. I originally had only 4 groups when the pie chart was created. Later, had to add one more group. The chart put the legend 'others' for the new group(vendor_breakdown) instead of putting the name of the group. I don't see anywhere I can change the name of the legend. Why is it not using the group name?

In my Stored Procedure, I am assigning the vendor_breakdown depends on the vendor category. It pulls all other 4 groups fine....

Anybody?

Thanks.
MiSeon

 

[Andie]

Which version are you using? Did you use the chart expert in creating your chart?

 

[week]

I am using Crystal 8.0. The chart was created before and I added a new group. It's not pulling the new group name after I added to the existing report. But then I deleted the Pie chart and created a new one on the same report but it's still doing the same. Yes, I created the new chart with chart Expert.

MiSeon

 

[kenhamady]

This is caused either by TopN or Specified Order Grouping. Did you use either of these features? In older versions of CR the TopN can activate automatically when using the report expert. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[week]

I don't remember spcifying any group order. If I was using TopN, how can I work with it to what I need to do?

MiSeon

 

[kenhamady]

First go to Report - TopN and see which subtotal you are using. Then change the setting on the left to ALL, and then reselect the subtotal on the right. This will sort, without giving you an OTHERS group. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[week]

Thanks for following up but it is still diplaying my new group with 'other vendor(s)', in the report the group name is 'sha managed care', as well as 'others'. I just don't understand how it's pulling all other group with correct name but the new one.

Are we running out of ideas?

Thanks.
MiSeon

 

[kenhamady]

Open the Sort Records Window (Report - Sort Records)
There will be a list of fields on the right, groups and sorts. Post the list of fields that you see there in your next message, just as they appear there. You may be grouping on a formula that someone wrote. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[week]

Ok, this is what my report sort order is

Sort Fields:
Group #1: sp_servall_profile_all.memid_name - A
Group #2: sp_servall_profile_all.vendor_breakdown - S
A - sp_servall_profile_all.dcid_name
A - sp_servall_profile_all.MEMBER_NAME


In my stored Procedure:

vendor_category_2 =
CASE
WHEN (p.primary_vendor_flag = 'Y') THEN 'A'
WHEN (pc.description = 'Preferred Choice') THEN 'B'
WHEN (pc.description = 'Other') THEN 'E'
WHEN (pc.description = 'SHA Market Share') THEN 'D'
ELSE 'C'
END,

vendor_breakdown =
CASE vendor_category_2
WHEN ("A&quot then
'Prime Vendor(s)'
WHEN ("B&quot then
'Preferred Choice Vendor(s)'
WHEN ("C&quot then
'Key Vendor(s)'
WHEN ("D&quot then
'ServAll Managed Care'
ELSE
'Other Vendor(s)'
END,

My Pie charts Legends are labeled with 'Prime Vendor(s)', "Preferred Choice Vendor(s)', 'Key Vendor(s)', 'Other Vendor(s)', and 'Others'.

'Others' should be 'Servall Managed Care'.

The report has Top N/Sort but it's checked to sort on 'All'.

Thanks for your time....

 

[kenhamady]

>>Group #1: sp_servall_profile_all.memid_name - A
>>Group #2: sp_servall_profile_all.vendor_breakdown - S

The "S" on the end is the key, it means specified order.

Go to menu options:
Report-Change Group Expert, Highlight Group 2 and click "Options"
Go the "Others" tab and select:
"Leave in their own groups" Ken Hamady

http://www.kenhamady.com/

On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.

 

[week]

Ken,

I had to leave 'Others' the same way but I added the new group that I was trying to show in the legend. And it works now!!!

Thanks, Ken!

MiSeon