Customising Legends for chart

Hi to all,

A query about legends in a chart, is it possible to customise legends in chart? I have used formula fields as the value of a pie chart and apparently the legend shows "@." infront of the fieldname... I'd like to have my own legend name for reading friendliness.

Thanks.

-HenryAnd for your information I am using Crystal Report included with VS.net 2003.

Cheers.

-Henry|||i'm having the same problem..

anyone der to help?|||Hi Cynthia, it has been many years since I have post my question... But I think I don't have a solution. I believe a full version of Crystal Report allow renaming field name.|||ok. where can i get the full version of Crystal report? is it consider an additional component to integrate into visual studio?

Custom palette in pie chart

Hi there!
I'v been trying to figure this out for a while, I have a Pie chart for
which I want to set the colors of the pies to my own defined colors.
The source dataset may contain 0 to 15 values, I've tried the folowing
solutions but none seem to work.
When column bouncetype is "HARD_BOUNCE" the pie should be green, etc...
=Switch
(
First(Fields!BounceType.Value,
"MailMessageBounceByType")="HARD_BOUNCE","GREEN",
First(Fields!BounceType.Value, "MailMessageBounceByType")="UNKNOWN","BLUE",
First(Fields!BounceType.Value,
"MailMessageBounceByType")="SPAM_NOTIFICATION","RED"
)
And also an iif statement.
=Iif(First(Fields!BounceType.Value,
"MailMessageBounceByType")="HARD_BOUNCE","GREEN",
Iif(First(Fields!BounceType.Value, "MailMessageBounceByType")="UNKNOWN",
"Red","Blue"))
Any ideas?If I have understoood correctly what you need is to set up colors in your
pie chart setting a color per group.
So, right click on the chart > Properties > Data Tab > Edit your value >
Appeareance tab > Series style > fill > Color > and the put the expression:
= iif(Fields!BounceType.Value, "HARD_BOUNCE","GREEN",
iif(Fields!BounceType.Value, "Red","Blue"))
"Peter Larsson" <scapecom@.hotmail.com> escribió en el mensaje
news:ellRTIHIIHA.3400@.TK2MSFTNGP03.phx.gbl...
> Hi there!
> I'v been trying to figure this out for a while, I have a Pie chart for
> which I want to set the colors of the pies to my own defined colors.
> The source dataset may contain 0 to 15 values, I've tried the folowing
> solutions but none seem to work.
> When column bouncetype is "HARD_BOUNCE" the pie should be green, etc...
> =Switch
> (
> First(Fields!BounceType.Value,
> "MailMessageBounceByType")="HARD_BOUNCE","GREEN",
> First(Fields!BounceType.Value,
> "MailMessageBounceByType")="UNKNOWN","BLUE",
> First(Fields!BounceType.Value,
> "MailMessageBounceByType")="SPAM_NOTIFICATION","RED"
> )
> And also an iif statement.
> =Iif(First(Fields!BounceType.Value,
> "MailMessageBounceByType")="HARD_BOUNCE","GREEN",
> Iif(First(Fields!BounceType.Value, "MailMessageBounceByType")="UNKNOWN",
> "Red","Blue"))
> Any ideas?|||Hi Monica, thanks for your reply!
Well, that's exactly what I did. ;)
I solved it though, by putting code in the Code-Tab, it's a smoother
solution I think.
http://blogs.msdn.com/bwelcker/archive/2005/05/20/420349.aspx
Regards,
Peter Larsson
Mónica wrote:
> If I have understoood correctly what you need is to set up colors in your
> pie chart setting a color per group.
> So, right click on the chart > Properties > Data Tab > Edit your value >
> Appeareance tab > Series style > fill > Color > and the put the expression:
> = iif(Fields!BounceType.Value, "HARD_BOUNCE","GREEN",
> iif(Fields!BounceType.Value, "Red","Blue"))
>
> "Peter Larsson" <scapecom@.hotmail.com> escribió en el mensaje
> news:ellRTIHIIHA.3400@.TK2MSFTNGP03.phx.gbl...
>> Hi there!
>> I'v been trying to figure this out for a while, I have a Pie chart for
>> which I want to set the colors of the pies to my own defined colors.
>> The source dataset may contain 0 to 15 values, I've tried the folowing
>> solutions but none seem to work.
>> When column bouncetype is "HARD_BOUNCE" the pie should be green, etc...
>> =Switch
>> (
>> First(Fields!BounceType.Value,
>> "MailMessageBounceByType")="HARD_BOUNCE","GREEN",
>> First(Fields!BounceType.Value,
>> "MailMessageBounceByType")="UNKNOWN","BLUE",
>> First(Fields!BounceType.Value,
>> "MailMessageBounceByType")="SPAM_NOTIFICATION","RED"
>> )
>> And also an iif statement.
>> =Iif(First(Fields!BounceType.Value,
>> "MailMessageBounceByType")="HARD_BOUNCE","GREEN",
>> Iif(First(Fields!BounceType.Value, "MailMessageBounceByType")="UNKNOWN",
>> "Red","Blue"))
>> Any ideas?
>

Custom names for summary fields

Using Crystal Reports 8.5 I have created a report which displays a pie chart of the column totals in a report. Unfortunately the names of the summary fields are used as labels for the pie chart slices and they are ugly - things like "sum qryOrders.OrderValue". Is there a way to replace these labels with my own choice of text?From the deafening silence, the answer appears to be 'No'. In case anyone else has the same issue, here is a workaround. Suppress the display of pie slice labels. Suppress the display of the chart legend. Create your own legend box using the basic drawing tools - filled rectangles - and add your own text labels.|||For the sake of future Googlers; I too was having this problem, and I had given up when I realized that if you sort "in specified order", you can then set up your "Named Groups" such that the "Group Name" is the name that you wish to have displayed.

For example, the formula for one of my named groups is "@.Allocation" "is equal to" "International Equity", and the name of the group is "Int'l Equity".

Works like a charm, sorry I'm too late to help you.|||Well, within a couple of minutes of posting, I realized that this only works if you have only one field to show a value for. So, it's not going to work where I really need it to, but still, it's useful elsewhere.