I am very new to Telerik Reporting and I have downloaded the trial version of it to see if Telerik reporting is able to fulfill the reporting requirements.
Before, I have been using SSRS to generate the reports but I faced some issues and bugs that made me look for other options out there. I have some reports that have quite a complex logic in generating the data that is going to be used on the report. With RDLC, I had created some dataset that would serve as data source for the report and afterwards, I would fill the data on these datasets from code. Moreover, I used to create some partial views that were used for keeping custom parameters. I did not use any parameters on RDLC report, but instead, I would fill the datasets with already filtered data because in this way I keep the logic of data that should be displayed more under control.
What would be the way how to implement the same with Telerik reporting? I mean, can I somehow interfere on the logic how the data are filtered on the report, or maybe use the same approach as I was using with RDLC? I.e., I use some custom parameters via the partial views that I have already created and using these values, I fill the datasets which will serve as data source to the reports? In this way I would not use the filters of Telerik reporting.
To add some complexity logic to this, I have a report which uses two data sources which are basically two datatables of the same dataset. One data source will be used on the header of the report, meanwhile the second one will be used on the details section of the reports. So I will need to apply the filtering on both datasources.
I tried to find some solutions to my case, but I am just not sure what would the best approach...
Thanks a lot