locked
Multiple Databases in single report RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    User1663023729 posted

    Hi,

    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.

    Thursday, May 15, 2014 5:25 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote
    User-1028151323 posted

    Reports can use stored procedures, can you make a stored procedure on the main server and use that?

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, May 15, 2014 11:23 AM