Step1: Create a table for the report as shown below:
Create Table SSRSReport(
Id Int Identity(1,1),
Insert the data in the table
Step2: Create data source and dateset so as to fetch the data from above table.
Create a SSRS report with chart type as Area and drag and drop Maximum and Minimum columns
from the dataset onto the chart data area.
Step3: Drag Period as the category field
Step4: Select Series Properties of "Minimum" and set its Fill property to White Color. Similarly set Silver for Maximum Series.
Step5: Drag MyBrand to the data region of the chart and change its "Type" property (from the property window) to Line,Plain. Similalry drag Comp Brand
and make the changes as done for MyBrand.
Step6: Select series MyBrand and set its "Marker" property to "Diamond". Also set the line color as "Blue". Similalrly set the marker as Square and line color as Red for CompBrand.
Replied on Jun 17 2011 4:55AM