Last post Mar 21, 2016 03:57 PM by maggiemays
Mar 16, 2016 06:15 PM|maggiemays|LINK
I created some reports that have different data sources. I realized I should have created shared data sources instead, so I converted a data source to be shared.
How do I modify my rdl files to point to the new data source? I thought I would be able to do this in BIDS, but I don't see where. Do I need to recreate the report?
edit - I found that I can change it on the report server, but how to I change the data source in BIDS so they match?
Mar 17, 2016 12:47 PM|Weibo Zhang|LINK
I think you could have a look at below blog to achieve setting the datasource for a report programmatically. Maybe you could use this method to achieve your need.
Besides, the following article provides a demo about changing the report data source directly during running and maybe it’s want you need.
Mar 19, 2016 10:28 PM|maggiemays|LINK
Mar 21, 2016 03:57 PM|maggiemays|LINK
I am searching for the option where I can modify the shared dataset, but I don't seem to have that option. I am totally missing the 'Data' menu item, which I have looked for and tried to add. How do I add the 'data' menu so I can have the options to modify
a shared dataset?