Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
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_31, 1, 1Would become:identifier, value_1, value_2, value_31, 1, 0, 02, 0, 1, 03, 0, 0, 1I 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