Line Chart

[obtechuser]

Hello,

I have a report with numeric data ranging from 2007-2008. I want to insert a line chart which displays two lines: 1 for 2007 and 1 line for 2008.(In order to compare both years). Using the default chart settings, I get one long line that spans 2007-2008, and am not sure how to insert a 'break' that tells the chart to start a new line based on the year change.
In an excel line chart, this is setup via the "Series" tab for a chart.

Any ideas on how to do this in Crystal.

Thank You,
Marco Sanchez
Crystal 10
Windows XP
MS SQL

 

[lbass]

You need an "on change of" field, e.g., account. Then create two conditional formulas, one for each year, e.g.,

//{@2008}:
if year({table.date}) = 2008 then
{table.amt}

//{@2007}:
if year({table.date}) = 2007 then
{table.amt}

Select a line chart, and then using the advanced layout, add account as your on change of field and add each of the two formulas as the summary fields.

-LB