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