Click here to Skip to main content
15,935,259 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
I have a data set like below.
type month1 month2 month3 month4 month5 month6
1      22     33     12     14     34      55
2      6      12     324    33     55     534

I would like to show these data in a chart in SQL server report, where series is type and x axis is months.

What can I do?
Posted
Updated 12-Nov-11 1:01am
v3

When you want to summarize data in a visual format, use the Chart data region. Charts enable you to present large volumes of aggregated information at a glance. It is important to carefully prepare and understand your data before you create a chart, as this will help you design your charts quickly and efficiently.
Ref: http://msdn.microsoft.com/en-us/library/aa964128%28v=sql.90%29.aspx[^]
 
Share this answer
 
Comments
faezeh66 12-Nov-11 5:44am    
i read it but i cant mak chart with these data?
do you know how can i do it?
here is good link[^] to draw chart in excel using c#
 
Share this answer
 
solved............................
the best way is returned dataset like below
Months type1 type2
Jan 22 33
March 6 12
. . .
. . .
. . .
 
Share this answer
 
v2
Comments
koolprasad2003 12-Nov-11 7:26am    
accept any of the answer it is "solved" by above answer, otherwise can you put solution ?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900