I would like to present the following use case and ask for suggestions on the best approach we can use in this situation:
My company provides customized reports on demand to our customers.
Customers buy new customized reports on our database. They will be available in the administrative environment of each client on our site. These reports are developed by us and implemented in VBA (Word and Excel). Usually, we develope a stored procedure that will provide data to the report and VBA is used to run the stored procedure and supply data to a spreadsheet or word document. VBA is dealing with a report queue and sending e-mail to customers with these reports attached. This structure has existed for about 12 years and we believe that it is necessary to improve this proccess. The main problem is the VBA instability to the volume of cases, high volume of decentralized code and difficult to maintain (typical procedural code).
We would like to implement improvements that will improve the quality and delivery time of these projects. Especially ensuring stability in the processing of reports and better error handling, among other expectations we have. And I would like to read suggestions and use cases that can assist us in making decisions.
Our doubts and ways we think of tread:
1) Replacement of VBA technology for a modern platform that adds time and quality in the generation of reports, since VBA is quite unstable. Including the SERVER and also SUBMITTED REPORT. We thought of many options: Jasper Reports, Pentaho, Crystal .. and continue research, but still no conclusive results, since I must ensure that the new technology could replace the VBA in everything he does;
2) The creation of stored procedures for data extraction for the report is the same as the best one? Or should we start from for BI tools that can assist in data extraction more efficiently? Something to help us to configure the data extractions easier.
Our plataform:
1. SQL SERVER;
2. Windows machine with VBA runing (control the report queue and proccess/generate reports).
We are open to platform changes. But with respect to use another database management system, it can be a little tricky… as in most cases, I believe.
What do you recommend? What usually employ on your company? Your suggestions will be most welcome!
thank you
My company provides customized reports on demand to our customers.
Customers buy new customized reports on our database. They will be available in the administrative environment of each client on our site. These reports are developed by us and implemented in VBA (Word and Excel). Usually, we develope a stored procedure that will provide data to the report and VBA is used to run the stored procedure and supply data to a spreadsheet or word document. VBA is dealing with a report queue and sending e-mail to customers with these reports attached. This structure has existed for about 12 years and we believe that it is necessary to improve this proccess. The main problem is the VBA instability to the volume of cases, high volume of decentralized code and difficult to maintain (typical procedural code).
We would like to implement improvements that will improve the quality and delivery time of these projects. Especially ensuring stability in the processing of reports and better error handling, among other expectations we have. And I would like to read suggestions and use cases that can assist us in making decisions.
Our doubts and ways we think of tread:
1) Replacement of VBA technology for a modern platform that adds time and quality in the generation of reports, since VBA is quite unstable. Including the SERVER and also SUBMITTED REPORT. We thought of many options: Jasper Reports, Pentaho, Crystal .. and continue research, but still no conclusive results, since I must ensure that the new technology could replace the VBA in everything he does;
2) The creation of stored procedures for data extraction for the report is the same as the best one? Or should we start from for BI tools that can assist in data extraction more efficiently? Something to help us to configure the data extractions easier.
Our plataform:
1. SQL SERVER;
2. Windows machine with VBA runing (control the report queue and proccess/generate reports).
We are open to platform changes. But with respect to use another database management system, it can be a little tricky… as in most cases, I believe.
What do you recommend? What usually employ on your company? Your suggestions will be most welcome!
thank you
1 Answer, 1 is accepted
0
Hello Diego,
Telerik Reporting can be used to replace your current platform for report generation. Note that Telerik Reporting provides a SqlDataSource component which allows you to connect your report to data without using any custom code. You can connect to SQL Server, Oracle, MySQL and many more as described in the above help article.
If it is required to perform any manual modifications of the data retrieved from your stored procedures, Telerik Reporting allows you to execute custom code to retrieve your data via the ObjectDataSource component.
You can download the Telerik Reporting demo and the Report Server demo and test how the products perform for your particular scenario. If any questions come up you can refer to our online documentation, or contact the support staff via a support ticket.
Regards,
Nasko
Telerik
Telerik Reporting can be used to replace your current platform for report generation. Note that Telerik Reporting provides a SqlDataSource component which allows you to connect your report to data without using any custom code. You can connect to SQL Server, Oracle, MySQL and many more as described in the above help article.
If it is required to perform any manual modifications of the data retrieved from your stored procedures, Telerik Reporting allows you to execute custom code to retrieve your data via the ObjectDataSource component.
You can download the Telerik Reporting demo and the Report Server demo and test how the products perform for your particular scenario. If any questions come up you can refer to our online documentation, or contact the support staff via a support ticket.
Regards,
Nasko
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