Skip to Content
0

Line Chart Results in horizontal lines

May 02, 2017 at 04:26 PM

21

avatar image
Former Member

I'm working with CR inside of Visual Studio. I have a dataset in a table that I want to write out to a line chart with 8 lines.

The data has the description field in the first column and then the next 8 columns each contain counts I want to display. Set up similar to below:

Description,a,b,c,d,etc...
1-150,5,0,12,44,etc...
150-300,44,123,0,154,etc...

I set the report to a line chart, and select On Change of Description, and then under Display I add columns a, b, c, d, etc...

When I preview the chart I see the descriptions along the bottom of the line chart, which is great. I have 8 separate lines, one for each column, but instead of each line showing a different value for each description, each of the 8 lines is just a straight horizontal line across the whole chart, each with a value of 1 through 8.

I want the lines to show the values in the database. For Description row "150-300" under column "a" it has a value of 44. How do I get the line representing "150-300" to trace out 44, then 123, then 0, then 154, and so on?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Don Williams
May 02, 2017 at 09:33 PM
0

I updated the tag to CR Designer, this is more of a design question....

Share
10 |10000 characters needed characters left characters exceeded