How do I use the reportsync tool?
The use of this tool is quite simple, as it only requires you to specify the ReportServer URL of your SSRS server, with the user credentials to log on to the server. The following is the snapshot of this tool: You can download ReportSync tool from here. Loading…
How does the report server respond to subscriptions?
The report server responds to events that it monitors on an ongoing basis. When an event occurs that matches the conditions defined for a subscription, the report server reads the subscription to determine how to process and deliver the report. The report server requests the delivery extension that is specified in the subscription.
How do I create a subscription to a report?
To create a subscription, the report must use stored credentials or no credentials to retrieve data at run time. You cannot subscribe to a report that is configured to use the impersonated or delegated credentials of the current user to connect to an external data source.
What are the different types of subscriptions in reporting services?
Standard and data-driven subscriptions. Reporting Services supports two kinds of subscriptions: standard and data-driven. Standard subscriptions are created and managed by individual users. A standard subscription consists of static values that cannot be varied during subscription processing.
How to get the latest [link] in the report?
Note: To Get latest [Link] – You need to set up one of reports by manually setting the Datasource path and execute below query this will provide you latest [Link]. Now, only remains to update it with the same where clause.
How to move the datasources from reportserver to another database?
You can use the RS.exe or ReportSync utilities in order to move the reports and datasources. Also you can update the Catalog table from ReportServer database using a T-SQL script. Use this query to explore your datasources path.
How to update the catalog table from reportserver?
Also you can update the Catalog table from ReportServer database using a T-SQL script. Use this query to explore your datasources path. UPDATE the path for the datasources to point report path. Note it will work if the DataSource is not a shared datasource deployed to a specific folder.