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
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