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.
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Deployment of rdl files to Report Server

Thread ID:

Created:

Updated:

Platform:

Replies:

128866 Feb 13,2017 11:47 AM UTC Aug 28,2018 11:51 AM UTC WPF 5
loading
Tags: ReportViewer
Richard Broadley
Asked On February 13, 2017 11:47 AM UTC

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 [Syncfusion]
Replied On 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 


Troy Stone
Replied On 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.

Mageshyadav M [Syncfusion]
Replied On 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 


Troy Stone
Replied On 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.

Mageshyadav M [Syncfusion]
Replied On 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 


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;