SQLServerCentral / Reporting Services / Reporting Services / Line Chart with Conditional Line / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 20 Jun 2013 03:45:55 GMT20RE: Line Chart with Conditional Linehttp://www.sqlservercentral.com/Forums/Topic1353286-150-1.aspxAnother option would be to add the "total line" data to the dataset inself (maybe using a Union / Union All query). Then Report Services would just think it is another line in the dataset.Mon, 03 Sep 2012 04:11:43 GMTScott Murray-240410Line Chart with Conditional Linehttp://www.sqlservercentral.com/Forums/Topic1353286-150-1.aspxMay - 1250 - CorpMay - 860 - Branch1May - 765 - Branch2May - 650 - CorpJune - 700 - CorpJune - 890 - Branch1etc.Sun, 02 Sep 2012 16:32:06 GMTtom1371