Csv DataSource dynamic URL

3 posts, 1 answers
  1. Chris
    Chris avatar
    4 posts
    Member since:
    Feb 2015

    Posted 05 Jul 2017 Link to this post

    Hello - 

    I am currently connecting to a URL that is serving CSV data in order to bring data into a report.  The URL looks something like like this :

    http://www.myreportdata.com?orgId=1234

    In order to specify the data that I would like to load, I would love to be able to change this URL to something like this :

    http://www.myreportdata.com?orgId=1234&date=7-5-2017

    or this:

    http://www.myreportdata.com?orgId=1234&date=7-10-2017

    based an a parameter in the report.  I am using the Angular 4 viewer to view all reports.  It seems like this might not be possible, to change the DataSource Uri based on a report parameter, I was hoping that I could assign the DataSource to something like this:

    http://www.myreportdata.com?orgId=1234&date=[Report.Parameters.Date.Value] in order to accomplish this task, but I can't get anything to work that way.  It seems maybe the other alternative would be to add a custom report resolver to my Report Server, but I was hoping for a simpler solution.  So my question is two-fold.

     

    1.  Is there any way to accomplish this goal SIMPLY and without using a Custom Report Resolver?

    2.  If not, are there any great documents on implementing a Custom Report Resolver when using Report server?

     

    Thanks much for any assistance.

     

     - Chris 

     

  2. Answer
    Stef
    Admin
    Stef avatar
    3610 posts

    Posted 06 Jul 2017 Link to this post

    Hello Chris,

    You can download the CSV content and load it in a custom .NET object for further usage via ObjectDataSource component.
    Please consider the example in Connecting Telerik Reporting to OData feeds. Note that the data retrieval method is parameterized, and you can pass information for the query string via report parameters.

    In case you need to load the data access layer in the Standalone Report Designer, please check Extending Report Designer.


    Let us know if you need further help.

    Regards,
    Stef
    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
  3. Chris
    Chris avatar
    4 posts
    Member since:
    Feb 2015

    Posted 12 Jul 2017 Link to this post

    Thank you for the response.  I was able to get what I needed out of using an ObjectDataSource tied to a DataTable coming from a C# class I built, and it seems to be working, so thanks!

     

     - Chris

Back to Top