|
Peace2007
Posting Yak Master
239 Posts |
 Posted - 2009-03-01 : 01:25:08
|
Hi,
I've created a line chart in which x axis displays years and y axis displays numeric values. However, it doesn't draw any line in the chart! when I change it to column chart everything is displayed okay.
What might cause this problem? |
|
|
Cody
Starting Member
24 Posts |
Posted - 2009-03-01 : 19:40:57
|
Are you trying to use multiple data points from the same row? Like in your SELECT you have amount_1, amount_2, amount_3 and you're trying to create a line that has each of these as a point?
That won't work. I know it works for bars and columns, but it doesn't for line charts. What actually shows in the chart is three LINES, each with a single point (and so it shows nothing).
What I did was change the SELECT so it would have an additional 'amount_value' field of 1, 2, 3, etc, and fill in just which field was necessary. So:
value_1, value_2, value_3
1, 1, 1
Would become:
identifier, value_1, value_2, value_3
1, 1, 0, 0
2, 0, 1, 0
3, 0, 0, 1
I had to do it that way so I could still SUM properly on the value fields.
Then in the data area of the chart, instead of using =Fields(Something!Something.value), I do an IIF(Fields!identifier.value = 1, Fields!value_1.value, IIF(Fields!identifier.value = 2, Fields!value_2.value, Fields!value_3.value)))
Of course this triples the amount of data you're pulling from the SQL server but I don't know any better way :-(
|
 |
|
Problem in Line chart