How to display multiple lines in line Chart?
Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=15114
Printed Date: 05 May 2024 at 8:40pm
Topic: How to display multiple lines in line Chart?
Posted By: ThakurS
Subject: How to display multiple lines in line Chart?
Date Posted: 07 Dec 2011 at 11:08pm
|
Hi, M struggling to display multiple lines in line chart. All the values m fetching it from database into data table in below format & data type Category(String).....year(Int).....graph_values(Int).....table_value(String) Test.........................2006.......... -100............................(100) Avg..........................2006..........20................................20 Median......................2006...........5................................5 Test..........................2007...........500.............................500 Avg...........................2007............90..............................90 Median.......................2007............45..............................45 M using cross tab to display data and chart to plot line. Following fields I used in Cross tab Expert & Chart expert Cross tab expert- Rows – category Columns – year Summarized fields – Min of table_value In Chart Expert – On Change of - Year Show values - graph values In cross tab m able to see the data properly but not in graph.I have three categories. Hence it should plot three lines in line chart but m able to see only one line for test category. FYI – using VS 2008 and crystal report assembly version 10.5 Urgent. Please reply soon.
Thanks ThakurS |
Replies:
Posted By: ThakurS
Date Posted: 08 Dec 2011 at 6:53pm
|
I got the solution.
 In Chart Expert - I should use On Change of -- Year, Category Show values -- graph values Thanks, ThakurS |
Posted By: chrcar01
Date Posted: 13 Jan 2012 at 9:14am
|
Hi. I'm doing nearly the exact same thing as your solution, however where you have "graph values" for the Show Values, the field that I put in there keeps being summed, there doesn't appear to be a place to turn that off.
So I have something like this: Percentage, Year, Group 20, 2010, 1 30, 2011, 1 50, 2010, 2 60, 2011, 2 On Change Of -- Year, Group Show Values -- Percentage The actual values being graphed are: 20, 2010 30, 2011 70, 2010 90, 2011 Any ideas? I don't get an option to not sum on Percentage, any help is much appreciated. |
Posted By: chrcar01
Date Posted: 13 Jan 2012 at 9:24am
| Never mind, as usual, the problem was me. Had the wrong type of line chart selected(Stacked Line), just had to pick a different type. |