More than one line on bar chart

[Former Member]

I am creating a Line chart from a table. The table includes a code column, date column, and several statistic columns. The dates are end of month dates only. There are about 10 different codes for each month. The statisic columns are the totals for the month for each code.

PeriodEndDate Code Statistic1 Statistic2 Statistic3 Statistic4

XX/XX/XXXX XX 999 999 999 999

On my line chart I want to show one or more statistics for one year for a given code. (A line for each statistic)

On a different report I want to show one or more codes for one year for a given statistic. (A line for each code)

The report has parameters for the code and the statistic. I have figured out how to create the chart for one code for one year for a given statistic. Can any one help me out?

Thanks,

Fred

[Former Member · Accepted solution]

Hello Fred,

If you work with a multi-value parameter you could pass in a collection of x of 10 of your codes. I assume you have played with this idea?

Perhaps you are stuck because there are no design-time options in the chart design wizards to base your line chart off the numerous values that could be passed into a single multi-value "code" parameter?

If it is a limitation of the chart design options available to you then your only recourse may be to use one of the SDKs to massage data into a datatable which could be pushed to a report on the fly.

Cheers, Dylan

<p><strong>Dylan Lopez - </strong>604.628.4467 </p><p>Previously: Microsoft .NET Resource in Developer Support @ Business Objects</p><p>Currently: Principal @ Inno Software Inc / Independent Contractor Group</p>

[Former Member · Accepted solution]

Not sure what you mean by a collection of x of 10.

My problem is getting the line chart to show more than one line. I want to show one code with one or more statistics

Or one statistic with one or more codes.

How would massaging the data into a datatable help with showing the multiple lines in the chart.

I have worked for years with Crystal Reports but am very weak with programming skills. (a little VB)

Fred