Line graph combo
Are there any good tutorials on combining 2 datasets so i can view one graph with 2 lines instead of having 2 separate graphs. Thanks
October 29th, 2011 12:50am

Hi SBolton, Generally, SSRS doesn't support merging datasets at report level. Workarounds: 1. Assuming both queries connect to the same database, use an UNION query. 2. Create a wrapper stored procedure that merges the datasets: http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/e0cf8f54-9895-472f-846c-c08a185e5530/ Thanks, Lola Please remember to mark the replies as answers if they help.
Free Windows Admin Tool Kit Click here and download it now
October 30th, 2011 10:36pm

Hi SBolton, using 2 separate graphs is an easier solution. use secondary axis in the graphs which will enable clearer display of information in your report
October 31st, 2011 6:24am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics