I want to create a line chart using 2 set of values.First value (i.e line) will show open report and second value(i.e line) with show closed report. The x axis will show months and y axis will show number(i.e sum of report). I tried using the following expression in the values box of chart data but i am getting a straight line.
=Sum(Fields!Count.Value, "DataSet1") for line 1
=Sum(Fields!Count.Value, "DataSet2") for line 2
I am using cube to create my Dataset.
You cannot combine two datasets in the same chart. You need to combine the data into a single dataset or use the Lookup function if you have a common field between Dataset1 and Dataset2:
http://msdn.microsoft.com/en-us/library/ee210575(SQL.105).aspx