We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date
Starting in 2019, the Reporting control is no longer included in Essential Studio. If you're experiencing issues with the Syncfusion Reporting Platform, Report Viewer, Report Designer, or Report Writer, we recommend migrating to Bold Reports, our dedicated reporting platform.

Bold Reports offers a comprehensive suite of tools and features for all your reporting needs, and we will help you make a smooth transition from the discontinued control. Our support team at https://support.boldreports.com/ is here to assist you with any questions or difficulties you may encounter during the migration process.

We thank you for choosing Syncfusion and appreciate your understanding.

Deployment of rdl files to Report Server

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.

5 Replies

RR Rajesh Rajendiran Syncfusion Team February 14, 2017 11:26 AM UTC

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. 

Regards, 
Rajesh. R 



TS Troy Stone August 24, 2018 12:29 PM UTC

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.


MM Mageshyadav M Syncfusion Team August 27, 2018 09:26 AM UTC

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  
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  
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  
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  
 
Also, we have exposed the sample for all our Report Server API in below GitHub location  
 
 
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 



TS Troy Stone August 27, 2018 12:10 PM UTC

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.


MM Mageshyadav M Syncfusion Team August 28, 2018 11:51 AM UTC

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.  
 
 
Regards,  
Mageshyadav.M 


Loader.
Up arrow icon