Deployment of rdl files to Report Server

[Richard Broadley]

Does anyone know how to automatically deploy new, and updated, rdl files to the Syncfusion Report Server?

We have a number of rdl reports served by the Syncfusion Report Server that we currently deploy manually, i.e. for each new report, or update to an existing report, we have to manually log on to Syncfusion Report Server and update the Reports manually. What we want to do is automate this process using PowerShell scripts so that we can have the rdl reports under source control and to ensure the correct versions are deployed. Is there an api call, for example, that would allow us to deploy and update rdl files?

Likewise, the DataSources would need deploying/updating automatically too.

Many thanks.

[Rajesh Rajendiran]

Hi Richard Broadley, 

Thank you for contacting Syncfusion Support. 

We have created a new support incident under your Direct-trac account. Please follow-up with the incident created for further assistance. 

https://www.syncfusion.com/support/directtrac/incidents 

Regards, 

Rajesh. R 

[Troy Stone]

What was the resolution to this?  We are currently evaluating this product and have a need to store reports/data sources in source control and deploy them to environments.  It would be helpful if the resolution wasn't hidden behind a support case specific to the user logging the issue.

[Mageshyadav M]

Hi Troy,  

 

Thanks for contacting Syncfusion support.  

 

We have provided the support for Adding and updating the Report/Datasource using API. Please find the API details below,  

 

API	REQUEST	PARAMETERS TO BE PASSED	RESPONSE	HELP LINK
Add Report	POST:/api/v2.0/reports	{"Name":"string",   "Description":"string",   "CategoryId":"string",   "ServerPath":"string",   "IsPublic":true,   "DataSetMappingInfo":[{"DataSetId":"string","Name":"string"}],   "DataSourceMappingInfo":[{"DataSourceId":"string","Name":"string"}],   "ItemContent":"string"}	Report was created successfully	https://help.syncfusion.com/report-platform/report-server/api/v2.0/#operation/Items_AddReport
Update Report	PUT:/api/v2.0/reports	{"ItemId":"string",   "Name":"string",   "Description":"string",   "CategoryId":"string",   "VersionComment":"string",   "ServerPath":"string",   "IsPublic":true,   "DataSetMappingInfo":[{"DataSetId":"string","Name":"string"}],   "DataSourceMappingInfo":[{"DataSourceId":"string","Name":"string"}],   "ItemContent":"string"}	Report was modified successfully	https://help.syncfusion.com/report-platform/report-server/api/v2.0/#operation/Items_UpdateReport
Add Datasource	POST:/api/v2.0/reports/data-sources	{"Name":"string",   "Description":"string",   "DataSourceDefinition":{"ConnectString":"string","CredentialRetrieval":"Prompt","ImpersonateUser":true,"Password":"string","Prompt":"string","UserName":"string","WindowsCredentials":true,"ServerType":"None"}}	Datasource was created successfully	https://help.syncfusion.com/report-platform/report-server/api/v2.0/#operation/Items_AddDataSource
Update Datasource	PUT: /api/v2.0/reports/data-sources	{"ItemId":"string",   "Name":"string",   "Description":"string",   "VersionComment":"string",   "DataSourceDefinition":{"ConnectString":"string","CredentialRetrieval":"Prompt","ImpersonateUser":true,"Password":"string","Prompt":"string","UserName":"string","WindowsCredentials":true,"ServerType":"None"}}	Datasource was modified successfully	https://help.syncfusion.com/report-platform/report-server/api/v2.0/#operation/Items_UpdateDataSource

 

Also, we have exposed the sample for all our Report Server API in below GitHub location  

 

https://github.com/syncfusion/enterpriseserver-reportapiclient 

 

Note: Actually, we don’t have this above api option when this forum was created and we traversed to support incident for logging feature task and follow up properly. Hence the solution was not available directly in the forum itself.  

 

Regards, 

Mageshyadav.M 

[Troy Stone]

Thank you for the response. Just so I'm clear. The proper way to handle report source control is use the APIs to add them to different environments?? This seems a bit odd, but if that is the solution I'll see what I can do with that.

[Mageshyadav M]

Hi Troy,  

 

Yes, Using the API is the best way to automate the deployment of reports and data source in different environments. 

 

We have created a new support incident under your Direct-trac account to provide a PowerShell script to automate the report, data source deployment for simplifying further to you and due to some timeline needed to deliver this script we have followed up with incident. Please follow-up with the incident created for further assistance.  

 

https://www.syncfusion.com/support/directtrac/incidents   

 

Regards,  

Mageshyadav.M