Hey everyone,
I am trying to combine like data from two different data sources into a single data set. Is there anyway I can do this? It seems like I can only add one data set, but is there some sort of workaround I could use?
thanks,
Keith
Not within the report I'm afraid.
However when building your own application, if you use the report viewer control then you can use .Net datasets to populate data sources. You could therefore populate the dataset manually in C-sharp or VB from the various data sources and pass that to the report viewer control.
The other option is to write your data delivery extension using the reporting services extensible object model.
|||What are the datasources? If they are two different database systems (SQL Server, Oracle, etc), you can consider using linked servers to combine the data before SSRS ever receives it. Just be aware of the performance implications of doing so.HTH...
Joe
No comments:
Post a Comment