I am trying to deploy SSRS report in SQL Server 2012 environment, and facing some difficulty in doing so.
I want to deploy reports in specific folder structure like,
------Reports(Module Level Report)
------DataSource(Module Level Report)
------Datasets(Module Level Report)
Please suggest, how can I provide such folder structure in my SSRS Report Deployment using Octopus Deploy.
I have gone through the blog written by Sean Bedford, http://sean-bedford.com/SSRS-Deployment-Automation/ but its not having proper steps to follow the deployment process.
I am looking for package like posted here, https://library.octopusdeploy.com/#!/step-template/actiontemplate-deploy-ssrs-reports-from-a-package
But this too has issue while connecting to the server.(I am newbie to powershell script).
Please suggest, what changes I make(in powershell script OR in Octopus Variables) to,
1> Pass the username, password required for the ReportServer
2> Create folder for Dataset(shareddataset) and associate it to report