I am new to ssrs. I have a report that gets data from two databases. I can create two datasets that connect to two different databases. The databases are third party and I cannot create stored procedures on the databases. My issue is that I have to combine the data from the two queries.
Please help me with this issue or point me to locations where I can find answers.
Thanks in advance.
Answer by Jason Cumberland ·
You cannot merge 2 datasets in an SSRS report. You can do this a few ways:
I have a requirement from our client regarding one of the SSRS reports which we are developing for them having multivalue parameter seperated by commas accepting real time parameter entries like below