Base on powershell this (basic) tool is used to manage reporting services (SSRS).
CreateFolder -ReportServerUri reportServerUri -folderName foldername -folderPath "/" -folderDescription "Description"
with parameters:
- ReportServerUri: web service url
- folderName: name of the folder
- folderpath: path of the folder ("/" for root)
- folderDescription: Set description properties to the created folder
UploadReport -ReportServerUri "https://server/service_path/ReportService2010.asmx?wsdl" -reportPath "/" -reportName "Report Name" -rdlFile "report.rdl" -description "Report Description"
with parameters:
- ReportServerUri: web service url
- reportPath: path of the report
- reportName: Name of the report
- rdlFile: SSRS report (*.rdl file)
- description: SSRS description
ListFolder -ReportServerUri "https://server/service_path/ReportService2010.asmx?wsdl" -targetPath "/";
with parameters:
- ReportServerUri: web service url
- targetPath: path
ListReport -ReportServerUri "https://server/service_path/ReportService2010.asmx?wsdl" -targetPath "/"
with parameters:
- ReportServerUri: web service url
- targetPath: path
ListAllReports -ReportServerUri "https://server/service_path/ReportService2010.asmx?wsdl"
with parameters:
- ReportServerUri: web service url
- targetPath: path
ListDataSourceReport -ReportServerUri "https://server/service_path/ReportService2010.asmx?wsdl" -report "report_path"
with parameters:
- ReportServerUri: web service url
- report: the complete path of the report
ListDataSource -ReportServerUri "https://server/service_path/ReportService2010.asmx?wsdl"
with parameters:
- ReportServerUri: web service url
CreateDataSource -ReportServerUri "https://server/service_path/ReportService2010.asmx?wsdl" -DataSourceName "DatasourceName" -ConnectionString "Data Source=name;initial catalog=catalog_name" -CredType s -CredUsername "username" -CredPassword "password"
with parameters:
- ReportServerUri: web service url
- DataSourceName: name of the datasource
- ConnectionString: connection string definition
- CredType: (p)rompt, (s)tore, (i)ntegrated, (n)one
- CredUsername: username when CredType = s
- CredPassword: password when CredType = s
ReportProperties -ReportServerUri "https://server/service_path/ReportService2010.asmx?wsdl" -ReportName "ReportName"
with parameters
- ReportServerUri: web service url
- ReportName: name of the report (use can use * for searching a report)
SetDatasourceReport -ReportServerUri "https://server/service_path/ReportService2010.asmx?wsdl" -reportPath "report_path" -datasource "datasource" -newDataSourcePath "newdatasource_reference_path"
with parameters
- ReportServerUri: web service url
- reportPath: Report path
- datasource: Datasource name (will be linked with the datasource with the path newDataSourcePath)
- newDataSourcePath: Datasource reference