jschill2628
Programmer
I have a report, which contains a crosstab report. From the crosstab I created a line chart. In my cross tab I have the following formula {Month2}
{Month2}:
if {@Month} = 1 then "January" else
if {@Month} = 2 then "February" else
if {@Month} = 3 then "March" else
if {@Month} = 4 then "April" else
if {@Month} = 5 then "May" else
if {@Month} = 6 then "June" else
if {@Month} = 7 then "July" else
if {@Month} = 8 then "August" else
if {@Month} = 9 then "September" else
if {@Month} = 10 then "October" else
if {@Month} = 11 then "November" else
if {@Month} = 12 then "December"
{Month}:
Month ({IRSCLAIM.CREATE_DT})
From the cross tab I created a line graph, this line was created to show the difference in incidents from FY to FY, and see the trending. My problem become when the value for a month has been zero, the graph dips down, and is not showing an accurate picture. Is there a way to suppress (take out) the zero’s in the line graph?
{Month2}:
if {@Month} = 1 then "January" else
if {@Month} = 2 then "February" else
if {@Month} = 3 then "March" else
if {@Month} = 4 then "April" else
if {@Month} = 5 then "May" else
if {@Month} = 6 then "June" else
if {@Month} = 7 then "July" else
if {@Month} = 8 then "August" else
if {@Month} = 9 then "September" else
if {@Month} = 10 then "October" else
if {@Month} = 11 then "November" else
if {@Month} = 12 then "December"
{Month}:
Month ({IRSCLAIM.CREATE_DT})
From the cross tab I created a line graph, this line was created to show the difference in incidents from FY to FY, and see the trending. My problem become when the value for a month has been zero, the graph dips down, and is not showing an accurate picture. Is there a way to suppress (take out) the zero’s in the line graph?