On my part time job, I was requested to find a way to move current reports with existing Subscriptions to new folder locations and maintain the existing subscriptions.
At the SQL Saturday this past weekend I was lucky enough to speak with Brian Knight, owner of Pragmatic Works. He was kind enough to clue me on a great trick.
In the ReportServer database, there is a table: [ReportServer].[dbo].[Catalog]
The two fields to be updated are PATH which contains the folder structure and PARENTID which contains the guid for the parent folder.
We would create the new folder structure manually and move the reports into those new folders based on SQL Update statements.
Path = '/Reports/Internal Reports/NewReportFolder/ExtraFastSQLCleanReport/'
where Name = 'ExtraFastSQLCleanReport'
And here's the SQL statement to view the update report in it's new location:
WHERE Name = 'ExtraFastSQLCleanReport'
That's what I like most about programming with the Microsoft Stack. The community is extensive and people are willing to share information.
I signed up for the Hortonworks Certified Associate exam last Thursday. Figured if I sign up, I'd have to take the test. And if I tak...
Saw a post today on Twitter, " Microsoft releases CNTK, its open source deep learning toolkit, on GitHub " This is big news. Be...
It seems like open source applications are the mainstream today. So many new products delivered through Aache foundation. Some do this. S...