Hi
With our current product we use Crystal for reporting. Report designers create the Crystal rpt file, a stored procedure for the data, and some report meta information to go into our database (the name of the rpt file, name of report, the stored procedure to use, the parameters that can be passed).
We then have an ASP site which reads the database to get the meta information of all the reports that are available on it's database. The site allows the user to navigate through and run the report they want, specifying the parameters as per the meta information. The Crystal report viewer then renders the report.
The site can also save the users parameter input to be run as a scheduled report later (a windows service checks the db periodically and renders the report to pdf for email)
This means that the ASP site never changes, report writers just need to know crystal and sql, and new reports can be added on the fly.
So, we are now looking for a modern, non-crystal solution, for our new product. One proposal is ASP.MVC with Telerik Reporting. I've seen that there is a standalone designer which is good and there are self contained trdx files. But is there the ability to create and drop in new reports on the fly like we have with our current crystal solution - without any changes to the mvc compiled code?
And if so are there any documents/guides/examples on getting that going?
Many Thanks
With our current product we use Crystal for reporting. Report designers create the Crystal rpt file, a stored procedure for the data, and some report meta information to go into our database (the name of the rpt file, name of report, the stored procedure to use, the parameters that can be passed).
We then have an ASP site which reads the database to get the meta information of all the reports that are available on it's database. The site allows the user to navigate through and run the report they want, specifying the parameters as per the meta information. The Crystal report viewer then renders the report.
The site can also save the users parameter input to be run as a scheduled report later (a windows service checks the db periodically and renders the report to pdf for email)
This means that the ASP site never changes, report writers just need to know crystal and sql, and new reports can be added on the fly.
So, we are now looking for a modern, non-crystal solution, for our new product. One proposal is ASP.MVC with Telerik Reporting. I've seen that there is a standalone designer which is good and there are self contained trdx files. But is there the ability to create and drop in new reports on the fly like we have with our current crystal solution - without any changes to the mvc compiled code?
And if so are there any documents/guides/examples on getting that going?
Many Thanks
1 Answer, 1 is accepted
0
Hello Tony,
Indeed, the purpose of the Standalone Report Designer is to create reports which can be used without the need to recompile projects. Each report is saved as a separate file and for displaying it, you have multiple options. The most straight-forward approach is to use UriReportSource (you will only need an URI pointing to the .trdx file). You can also read the .trdx from the DataBase, deserialize it and use it along with an InstanceReportSource. Either way, you will only need the .trdx file and some metadata associated with it. More info can be found in the Report Sources article.
As to the viewer part - we are currently developing a new viewer (you can download a preview from your account) which will be released for Q3 2013. You can read more about it here: Bringing the Power of HTML5 to Telerik Reporting.
Regards,
Elian
Telerik
Indeed, the purpose of the Standalone Report Designer is to create reports which can be used without the need to recompile projects. Each report is saved as a separate file and for displaying it, you have multiple options. The most straight-forward approach is to use UriReportSource (you will only need an URI pointing to the .trdx file). You can also read the .trdx from the DataBase, deserialize it and use it along with an InstanceReportSource. Either way, you will only need the .trdx file and some metadata associated with it. More info can be found in the Report Sources article.
As to the viewer part - we are currently developing a new viewer (you can download a preview from your account) which will be released for Q3 2013. You can read more about it here: Bringing the Power of HTML5 to Telerik Reporting.
Regards,
Elian
Telerik
Have you tried the new visualization options in Telerik Reporting Q2 2013? You can get them from your account.