CR XI Developer - Charting woes continue 1

[rjoubert]

I have CR XI Developer (30 day trial) installed. I am attempting to create a line chart from the following data...

Category Phase0 Phase1 Phase2
Category One 25 28 30
Category Two 45 45 50
Category Three 55 55 55

I want my chart to be formatted such that each Category has it's own series (line), and the Phases should appear across the horizontal axis. The numeric values under each Phase column are to be plotted. Any ideas on how to go about accomplishing this?

 

[lbass]

Is this a crosstab with a column called "phase" or are the phases separate database fields?

-LB

 

[rjoubert]

The Phase columns are separate database fields.

 

[lbass]

You would need to get the phase fields all into one field. Try inserting a command as your datasource, where you do a union all statement like:

select '1' as Phase, table.`phase1` as Amt, table.`category`
From table
Union All
select '2' as Phase, table.`phase2` as Amt, table.`category`
From table
Union All
select '3' as Phase, table.`phase3` as Amt, table.`category`
From table

Then insert a chart (line, advanced layout) in the report header where you add {command.phase} as your first "on change of" field, {command.category} as your second "on change of" field, and Amt as your "show value" field.

-LB

 

[rjoubert]

BRILLIANT!!! Thank you so much for your help LB.