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

Csv DataSource dynamic URL

2 Answers 196 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Chris
Top achievements
Rank 1
Chris asked on 05 Jul 2017, 04:16 PM

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 Answers, 1 is accepted

Sort by
0
Accepted
Stef
Telerik team
answered on 06 Jul 2017, 03:01 PM
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
0
Chris
Top achievements
Rank 1
answered on 12 Jul 2017, 02:38 PM

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

Tags
General Discussions
Asked by
Chris
Top achievements
Rank 1
Answers by
Stef
Telerik team
Chris
Top achievements
Rank 1
Share this question
or