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.
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.
