Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

suppressing a part of graph when using group Layout

Status
Not open for further replies.

jack91

Technical User
Apr 13, 2009
185
US
hi,

I am using crystal v 10.

I have 2 groups for my report

group 1 ---> hardware criticality (Y/N)
Group 2 ---> future warranty expiration info

**@hardware criticality formula: (please end of this thread)
**@Future Warranty expiration info: (please end of this thread)

I have made a graph using :
place chart: once per report
Layout: Group
On Change of: @critcality and @future warranty expiration info
Show: Count of @future warranty expiration info

** My Question is:
------------------

If in the parameters i have chosen to display both Y and N for criticality of Hardware.
I see both graphs(bar charts)for critical and non-critical on the same chart. I would like to see them separated into two individual charts.
I have tried doing the following in the section formula where the chart is located;
{hardware.comp}<> "Y"

but it does not seem to suppress this.


**@hardware criticality formula:
-----------------------------------
if {hardware.comp}= "Y" Then "Critical"
else if {hardware.comp}= "N" Then "Non-Critical"

**@Future Warranty expiration info:
-------------------------------------
if {comp.warranty_end}>= currentdate and {comp.warranty_end} <= currentdate+30 then
"Less than 30 days"
else if{comp.warranty_end} > currentdate+30 and {comp.warranty_end}<= currentdate +60 then
"Between 30 - 60 days"
else if{comp.warranty_end} > currentdate+60 and {comp.warranty_end}<= currentdate +90 then
"Between 60 - 90 days"
else if{comp.warranty_end} > currentdate+90 and{comp.warranty_end}<= currentdate +365 then
"Between 90 days and 1 year"
else if{comp.warranty_end} > currentdate+365 and {comp.warranty_end}<= currentdate +730 then
"Between 1 - 2 years"
else if{comp.warranty_end} > currentdate+730 then
"greater than 2 years"

Please advise
Regards,
Jk
 
Add a group using your criticality formula and then place chart in the header of that group.

Ian
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top