This is a migrated thread and some comments may be shown as answers.

How to dynamically set the Service Url field of a Web Service Data Source

14 Answers 2000 Views

Report Designer (standalone)

This is a migrated thread and some comments may be shown as answers.

14 Answers, 1 is accepted

answered on 23 Oct 2018, 10:43 AM

Hello Edward,

I suggest to provide the Service Url as an inline parameter, i.e Service Url property of the WebServiceDataSource can be set as an inline parameter @Url, and then the value of @Url can be provided as an Expression (i.e. taken from a Report Parameter) so that its value to be evaluated run time. Please refer to this screen shot - https://www.screencast.com/t/jtcgJ2EAK

Regards,
Silviya
Progress Telerik

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items

answered on 28 Oct 2019, 08:11 AM

url-result-on-server.png

url-parameters.png

I am trying to implement the inline url, and have 2 problems:

1. It does not work

2.I need to concat the controller's method name to the url, different to each service data source.

when I see the service url it is written as "@url" (attached picture of the parameters in the report, and the result on the server)

angular client side code:

let rs = {
      report: this.reportName,
      authenticationToken: token,
      parametersAreaVisible: false,
      parameters: {
        Url:'http://localhost:52913/api/alarms/'
      }
    } as unknown as JSON;

When I want to concat Url with method name do I do it on the parameters form like:

value= Parameters.Url,Value+"myMethodName

or on the ServiceUrl property like : @url myMethodName

maybe i need some brackets?

Tally

answered on 28 Oct 2019, 10:07 AM

OK I got it to work:

I had my own code problems, to make the problems above.

1. Add a parameter to the whole report, to represent the Url, lets call it Url

2. On the client side:angular client side code:
let rs = {
      report: this.reportName,
      authenticationToken: token,
      parametersAreaVisible: false,
      parameters: {
        Url:'http://localhost:52913/api/alarms/'
      }
    } as unknown as JSON;

3.add an inline parameter to each web service data source. Name: @Url Type: inline Value: = Parameters.Url.Value +'myMethodName'

4.set the service url of this web service data source to @Url

Hope I have helped.

answered on 25 Nov 2019, 07:51 AM

152ccf06d28b849829be87698ddf9b7f9.png

2654644bf58dc45f48152759ac1fa545a.png

37491c38f16c145afa9b89ef09fcc6787.png

479de1bd5222e4ffeb995e2b924bccebb.png

I'm using Telerik Reporting R3 2019 but still error: "Invalid URI: The hostname could not be parsed"

answered on 23 Jan 2020, 02:32 PM

dssitesparam.png

I have a slightly different scenario, but still along the same lines as this.

Our reports use WebServiceDataSource with the Service URL defined as @Url and at run-time this value set using the DataSource parameter passed into the report form our web page. (i.e. = Parameters.DataSource.Value). This all works fine. The DataSource value would be:

https://<domain>/api/Reports/v1.0/Security

Our reports also include parameters, one of which is a list of customer sites. So I created another WebServiceDataSourcecalled dsSitesParam and set the Service URL to @Url1. The API would be similar to the DataSource value except the 'Security' text would be replaced with 'Sites', so at run-time we are using the same DataSource paramater but using the Replace function to change the 'Security' to 'Site'. (i.e. = Replace(Parameters.DataSource.Value,"Security","Sites")

At design time when using the hard-coded path to the Sites api and can download the site just fine. See screenshot dsSitesParam.

The reports also have a Sites parameter. When using a CSV Data Source for this parameter, it works fine. When I set it to use the dsSitesParam data source, the report fails to load with the following error:

Invalid URI: Hostname could not be parsed

Should I be able to use the Replace function of the DataSource value to change it to the correct API to be used for getting the list of sites?

answered on 28 Jan 2020, 09:27 AM

Report1.zip

MyWebServiceDataSource.zip

Hi Shawn,

I tested the described scenario as I understood it and can confirm that you may use the Replace function when setting the WebServiceDataSource Url through an Expression. I have attached a demo report with the Web API project exposing the data services. The data services run on 'http://localhost:50160/api/data' and 'http://localhost:50160/api/site'. The parameter 'Parameter1' has AvailableValues coming from 'webServiceDataSource2', which Url is set with:

= Replace(Parameters.Url.Value,"data","site")

I suspect that there is something inaccurate in the final Url. You may use Fiddler to access the exact requests to check this.

Regards,
Todor
Progress Telerik

answered on 02 Sep 2020, 08:17 PM

telerikreporterror.png

[quote]Todor said:

Hi Marius,

Which version do you use? There is a known problem with our latest official release 13.2.19.918 related to WebServiceDataSource. It has been fixed in the Internal Build 13.2.19.1004 - 'WebServiceDataSource - Parameters are not correctly evaluated during processing'. You may upgrade to the Latest Internal Build.

Regards,
Todor
Progress Telerik

[/quote][quote]Todor said:

Hi Marius,

Regards,
Todor
Progress Telerik

[/quote]

Hello Todor
I am on version 14.1.20.618. Is this still a problem b/c i am getting it? I followed Silviya's example and i get data appearing when i go through the Configure Web Service Data Source, however, i still get this error.

Jeff

commented on 19 Jun 2024, 01:26 PM

Is this still an issue with 18.1.24.514? when I use @Url in Service Url of Web Service Data Source, make this Inline and the value being = Parameters.Url.Value, I get the error message "unable to cast object of type Telerik.Reporting.Processing.Expressions.ProcessingEvalProvider to type Telerik.Reporting.Expressions.IValueObject". It works if the actual Url is put in as a string constant.

Todor

commented on 20 Jun 2024, 10:28 AM

Hi Jeff,

The known problem has been fixed with R3 2019 SP1 (13.2.19.1030).

Please, check the article section Using Inline Parameters in Service Url for details on the configuration.

Jeff

commented on 20 Jun 2024, 11:28 AM

So it turns out you can use webDataSource URL of https://%Url/api/widgets/get/%widgetId and then set these up as inline parameters. The report will work, but the "Download" button in the Wizard gives the Telerik.reporting.expression.ExpressionEval etc etc exception. So basically don't trust the "download" button in the dataSource wizard for anything fancy, just run the report and see if it works.

Todor

commented on 25 Jun 2024, 08:35 AM

Hello Jeff,

I tested locally with the Standalone Report Designer and the Download button of the WebServiceDataSource Wizard worked as expected when I provided valid Design-Time values for the parameters - see the linked muted video. Please, ensure you have provided such values as they are respected when testing the Web Service with the Download button. The actual parameter values are applied in run-time.