Last post May 15, 2014 11:23 AM by DarthSwian
May 15, 2014 05:25 AM|A Sireesha|LINK
I have two databases, one is main database and other is Audit database.
I need to build a report combining these two databases.
I have created join query and its working fine in sql.
My question is how can i connect to Multiple databases for a single dataset in ssrs report.
Please help me.
May 15, 2014 11:23 AM|DarthSwian|LINK
Reports can use stored procedures, can you make a stored procedure on the main server and use that?