How do I add a forecast line in an SSRS 2008 reporting Services line graph.
I have a query that returns the following values
Date Product Target Sales Salesperson
201003 B 200 250 Joe
201003 C 200 150 Bill
201004 B 100 75 Joe
201004 c 100 75 Bill
201005 B 250 Joe
201005 c 350 Bill
The report should be for each product and show the sales total (bar graph) and then
I need the target values as the trend line and then the x-axis would show the time period 200103,201004,201005.