hi,
I have 2 databases from which my data will be coming from. How can I join this 2 databases in reporting services?
cherriesh
It depends on the structure of the data. There are a few options you can try, though none really involve joining 2 data sources together in Reporting Services - transforming the data for reporting is usually done with an ETL layer.
Build an ETL package to load the data into a temporary staging database or
Build a view in SQL Server using linked servers or 4-part naming to union the data together.
These are two ways to get the data together.
cheers,
Andrew
No comments:
Post a Comment