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

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.