SSRS : How to call API from shared xml datasource with parameters in SSRS?

Question

I have a report that uses both a shared SQL DataSource and an XML DataSource. I've tested the shared SQL DataSource connection and it works. The XML DataSource is calling an API with the parameters that I send to the report.

The URL is constructed like this Parameters!API_Url.Value & "u_ID=" & Parameters!u_ID.Value & "&sourceType=" & Parameters!sourceType.Value & "&clientID=" & Parameters!clientID.Value & "&applicationID=" & Parameters!applicationID.Value

I have added a dataset with this shared XML data source but when I open the report the error showed.

How can I solve this?

I want to use the shared XML data source in the dataset.

Answer 1

Hi @76719856

For information on using XML Data Source and Data Set in SSRS, you can check out these links.

https://learn.microsoft.com/en-us/sql/reporting-services/report-data/xml-query-syntax-for-xml-report-data-ssrs?view=sql-server-ver16

https://www.mssqltips.com/sqlservertip/3148/sql-server-reporting-services-xml-data-source-and-data-set/

Hope these can help you.

Best regards,

Aniya