Tricks Export to Excel using VB.NET

in #steemit7 years ago

wefh.jpg

Why Reporting is important

From the time we were in elementary school or maybe still sitting in a kindergarten bench, the report or ordinary we named it with a RAPOT was already introduced as a final result during our study in those times. We used to be used by naming them for Rapot event at the end of the semester of schooling. Even until we get to the higher stage of the lecture. A report / report is still presented in order to find out the end of the semester that we can name the GPA

"why a report or report becomes important in an application program ?? is not it all can be seen in the database ??"

Yes ... that's about a question asked by a first-year student to the author. the answer is because the report or report is needed as the end result of a process in accordance with the required of a program. For example, a retail program application, it will certainly require a report or report purchases, sales reports and other reports that facilitate the User or users of the application program to analyze or further process the report or report.

"loh is not it all can be seen in the database and can be in Quary to see the desired results ???"

Yeah not all users or users can be allowed to login or login to the database and not all users can run queries or recognize SQL database queries, and also not all users of users of the application program is a computer person or IT person or programmer. so obviously well ..... a report or report is already very commonly required in a program application in order to obtain the final results in accordance with the needs of a process application program itself.

Once a report from an application can be paired with a report from the default language programming itself. for example, when the author uses visual basic 2008 as a programming language in the making of the application, then for the report the author uses Crystal report that has been included in visual basic 2008. indeed in this repotr Crystal has been greatly simplified in customize report in accordance with what we want.

Along with the development of the times, a reporting of an application is not always presented in the form of standard documents. But from the results of this reporting should be in the process or manupulasi again in accordance with the needs of each individual. When the author usually displays a report of a program application with a standard document layout (ready-made document that can not be edited and ready to print), then there is a request from the user that the reporting must be in the process back in accordance with the needs of the user . Then comes the idea to display Report layout or reporting in the form of Microsoft documents (MS Excel). From Ms Excel this all forms of reports can be forwarded or processed in accordance with the needs of each user to produce a calculation or the end result of a process itself. For example, when the author displays a sales report (in the form of MS Excel), then the report can be processed back or re-analyzed by the relevant part to then be calculated in accordance with the analysis or sales calculation.

I will discuss making reporting or reporting of an application using microsoft office excel. lately I have a lot of order making application with the report in the form of MS Excel, well ... with the reason that the report so that it can be processed to be processed by the related sections. Shapes, formats and templates also vary. From a simple report to a report with a customized template or a dashboard report. okay go to the material yaah basic techniques to create reports using MS Excel document template.