We use Web service datasource almost in all of our reports. In web service datasource we use OData query to get some information from our server. We usually customize web service data sources by using inline parameter @url to set value for Service Url property. Inline @url parameter will be calculated based on some formula (see ConfigureRequestParameters.PNG attached picture, @url parameter value can be complex). We use Html5ReportViewer, .NET5.
The question here is how to get complete odata url for the specific webservice datasource of the report programmatically (we also implemented custom report resolver in our project)? Meaning that what will be the final version of OData url on execution process?
As a sample report you can use attached report (TestProductReport.zip).
What we want is to get this complete odata url:
In design mode you see ConfigureRequestParameters.PNG.
- @url = Parameters.SourceUrl.Value+ Parameters.SourceTable.Value
- SourceUrl = https://services.odata.org/V3/Northwind/Northwind.svc/
- SourceTable = Products