customizing chart titles for GH when evaluating for each flag

[jack91]

Hi,

I am using crystal version 10.

I have say 100 computers and i am evaluating which of them have warranty expired by using:

if isnull({warranty_end date })
then
"Assets With NO Warranty INFO"
else if {warranty_end date } <= CurrentDate then
"Assets Out Of Warranty"
else
"Assets Under Warranty"

Now I am creating an upper tier which divides the assets into critical or non-critical.

GH1 - criticality
GH2 -- warranty expired

Now what I am doing is creating charts in:

GH 1 -- "place chart" for each critical flag
On change of "warranty expired"
show values "warranty expired"

Formula for critical flag i am using is:
if {critical field value}= "Y" Then "Critical" else "Non Critical"

so the graphs come out for critical and non- critical. -- until this it is fine.

THE ISSUE IS:
I want to custom change the chart titles for critical and non-critical.
I am unable to do that.

Is there a way to get around to doing that??

thanks
Jk

 

[lbass]

You can manually change the chart titles in the chart expert, so if this is not what you mean, please explain. You could alternatively remove the chart title and place a formula that returns the desired result in another group header section above the one containing the chart.

-LB

 

[jack91]

If I manually change the chart titles with the chart expert it does not seem to work.
The reason is:

I have 2 charts one in GH1 and the other in GH2, these charts evaluate for warranty expiry and they do it for critical and for non-critical computers.

So I have now 4 charts total. The first 2 charts are for critical and the other 2 charts for non-critical computers.
So custom changing the chart titles does not work when i refresh the reports.

Your second suggestion:
"You could alternatively remove the chart title and place a formula that returns the desired result in another group header section above the one containing the chart.
"
-- is probably what I will need. Please advise further.

Thanks
Jk

 

[lbass]

1) Please explain what you want the chart titles to say. I'm assuming you want them to pick up information from each group instance.

2) Please provide the actual groupnames for Group#1 and Group#2.

-LB

 

[jack91]

3 graphs that I am evaluating for each "Critical Flag". If criticality = "Y" then "Critical" else if Criticality = "N" then "Non-Critical"

Critical Flag is in GH1

The graphs are:
1)Warranty expired
2)Future Warranty expired info (the computer warranties, are they expiring in the next 30 day, 60 days etc)
3)Old warranty expired info (the computer warranties, which are already expired did they expire 30 days back, 60 days back etc)

I have formulas for 1,2 and 3.

Crystal gives its own generic Titles, I want them to be more descriptive. like "Warranty expiration forecast for critical computers", "Warranty expiration HISTORY for non-critical computers" etc.

This I am un-able to do.

Group 1 name: Criticality flag
Group 2 name: warranty expired

Thanks
Jk

 

[lbass]

The chart titles would automatically provide a subtitle for by group like: "For Critical". If you are unhappy with these, you should be able to write formulas like:

"Warranty Expiration "+
(
if {@Warranty Expired} = "Assets Out of Warranty" then
"History " else
if {@Warranty Expired} = "Assets Under Warranty" then
"Forecast "
) + chr(13)+
"For "+{@Criticality}+" Computers"

I added a return in this which you can remove if you wish, but if not, format the formula to "can grow". Place this formula in a GH#2_a header with the chart in GH#2_b.

-LB

 

[jack91]

Is it possible to refine it further:

The bar chart has 3 titles as headers. top/bottom and left

top title: warranty expiration forecast for Critical Assets
bottom title: Expiration Forecast
left Title: asset count (This can be same for all bar charts)

Is customizing the bottom title a problem?

(I am trying to tie in what I am doing here with this

http://www.tek-tips.com/viewthread.cfm?qid=1557814&page=1)

Thanks
Jk

 

[lbass]

You could add another group section below the chart and add a formula:

"Expiration "+
(
if {@Warranty Expired} = "Assets Out of Warranty" then
"History " else
if {@Warranty Expired} = "Assets Under Warranty" then
"Forecast "
)

For the Y axis, just use the standard title in the expert.

-LB

 

[jack91]

Would you suggest that to make this easier that the:

Warranty Expired formula, future warranty expired and Old warranty expired formula can be entered into the the database columns.

Would this not make things easier?

Regards,
Jk

 

[lbass]

I don't know what you mean. This is not that complex in the first place.

-LB

 

[jack91]

For the Y axis -- can the title be customized?

(For the top and the bottom of the chart you suggested placing another section above and below the chart to get the titles), but the Y axis is on the left.

The custom title on the Y axis will be same for both charts so I can just change it on the design template itself and it should work right?

I will try it out anyways.

btw, you have given me some much invaluable help and saved my ass so many times, it would make me happy to give you $$ whatever I can, is there a way to do that?
(I hope I am not breaking any forum rules asking you this)

Regards,
Jk

 

[lbass]

You certainly could donate to the site. Although that would not find its way to me, it would acknowledge the value of the forums to you.

-LB

 

[jack91]

For a simillar chart i did the following:

"Warranty Expiration Forecast For"+{@Criticality Flag}+" Assets"

{@criticality Flag} formula:

if {parameter.field}= "Y" Then "Critical"
else
if {parameter.field}= "N" Then"Non Critical"
else
if {parameter.field}= "{ALL}" Then "Critical/Non Critical"

I can't seem to get this to work.
Please advise on any corrections.

Thanks
Jk