SQL Server Performance

ssrs reports1

Discussion in 'ALL SQL SERVER QUESTIONS' started by navya krishna, Jan 19, 2013.

  1. navya krishna New Member

    Dear all,

    i am new for ssrs .i need some clarifications on ssrs.

    we have a client he is maintaining different databases seperatly in single server.so he need to display sales report by customer wise in single report with different databases.how i can i display multiple databases in single report.could you please any one explain me clearly how to do that.
  2. satya Moderator

    Welcome to the forums.

    Yes it is possible, just create multiple datasets - each for 1 database and write up a query to combine those datasets.

    Within the SSRS a RDL report can reference as many databases or data sources (data from other database engines or external sources) as needed.

    Sample query in BOL:
    SELECT A1.[Name],A2.Color FROM Adventureworks.Production.Product A1, AdventureWorks2008.production.product A2
    WHERE A1.ProductID = A2.ProductID AND A1.Color = 'Black'

    See this http://social.msdn.microsoft.com/Fo...ad/48de91f9-1844-40c1-9614-5ead0b4b69a5#P1Q11 related posts in MSDN too.

Share This Page