I need to show telerik report with some table, images and chart. The data for report is coming from REST API. This report needs to be severed from MVC application.
I designed report from standalone designer (.trdx) file and used as CSV data source (File location provided as Url of MVC App) into the report. Used this report file in MVC application to show in report viewer. This works fine, but I have one problem there, I have filter field (Report Parameters) of type String with Multivalue with following values:
- This week
- Last week
- Last month
Based on this selection value, I need to fetch report data from REST service and need to convert this report data into CSV. To achieve this I need to get the filter value in backend when user clicks on preview button of report. I am not able to find a way to do this, I checked examples comes with reporting installation but not able to find a way there. Does anyone know how to achieve this?
Another question is, does CSVDataSource component is good choice, or need to switch to Object Data Source as most of video's recommend that. If yes the how to get the parameter value in the class.