Report from unfamiliar to use

The room charging system has basically been completed, and the rest is the acceptance and correction. This blog focuses on how to learn and use reports when I print daily and weekly reports.

 

In short, reports are dynamically displayed in tables, charts, and other formats. The formula can be used to represent: Report = diverse formats + dynamic data. It is like our previous bookkeeping. We can draw different charts based on our own needs and requirements, and fill in the weekly and monthly bills. In fact, reports play this role!

 

In the data center billing system, two forms are displayed: day and week. The function is to read data from the database and display the closing information for the current day or for a period of time, which is convenient for printing and handed over to the Manager for review and closing. Such a function is a good choice for reports.

 

After learning about the report, we first add the report placement control in VB and add components in the project:

 

 

 

In this way, we can place the report, and we can find a way to prepare the report.

　　

Before creating a report, we need to download the report preparation tool. Here I recommend this: Grid ++ report. Because it is a C/S integrated report tool with B/S, it features easy to learn and use. C/s development is applicable to VB. NET, C #, VB, Vc, Delphi, BCB, VFP, and easy language. B/S development is applicable to ASP. NET, ASP, PHP, JSP, etc. It supports all web servers. C/s reports and B/S reports share the same development knowledge and design resources. Provides a unique REPORT query and display function, allowing you to integrate functions such as REPORT query display, print, print preview, and data export. Easy to implement general reports, table reports, dynamic reports, multi-layer headers, invoicing, cross tabulation, table tables, and various special reports. All in all, it is not only powerful, but more importantly, it is easy to learn.

Below I will explain how to use it:

1. After installation, we can enter the main interface:

 

2. In the file creation wizard, We can first create the basic attributes of the report to be designed, such as the title and database to be connected. Here I want to talk about the database connection:

 

Here I want to say that we must test the connection to ensure the connection is successful.

 

　　

3. After the model is created, we can add what we want to the report. Here I want to say that everyone must make good use of this insert button, its components provide almost all of our functions.

 

4. After inserting a widget, we need to set the properties of the Properties window to set its related properties, such as name, size, alignment, appearance, and position, make it meet the functions we want to implement. Here I would like to say that part 3 and Part 4 are basically the same as those of the vbprogram. They are all component attributes, but they are different in operation objects.

 

 

5. After the Basic settings are complete, we can use various views to preview the reports we have created to help us make them more perfect.

 

6. The report was created in the first five steps. Next, we needed to display the report to VB. In the VB interface, we first drew the grdisplayviewer control where the report was placed, below is the code we need to write. below is the code for simple display for your reference:

 

Dim withevents report1 as grprolibctl. gridppreportset report1 = new grprolibctl. gridppreport'create a report object report1.loadfromfile app. path & "\ daily report of the IDC billing system. GRF "'load the report file grdisplayviewer1.report = report1 grdisplayviewer1.start' through the path to start the report running

In this way, the data in the database can be displayed in the report. Of course, it is very easy to print and preview reports:

 

In this way, the data in the database can be displayed in the report. Of course, it is very easy to print and preview reports:

 

Private sub publish print_click () 'Code of the print button report1. [print] (true) end subprivate sub cmdrash_click () 'refresh the code of the display button grdisplayviewer1.refreshend subprivate sub cmdyulan_click () 'print the preview button report1.printpreview (true) end sub

 

In this way, we can basically complete the task, take the daily statement we printed, and submit the weekly statement to our leaders!