Report is indeed a new thing for me. It took a long time to get a basic understanding of the report. First, there is a report control grid ++ report engine5.0typelibrary in VB. Second, the report is produced through the "Grid ++ report designer" software. Finally, this is a report, interaction between VB and SQL.
1. Report creation steps
- Download:
I guess I downloaded it too old. When I downloaded version 4.5, I had to register it myself. Later, VB showed me the error message of the uninstalled report. When I install version 5.0 or above, there is basically no such problem.
(: Http://www.rubylong.cn/Download.htm)
- Production:
- Click Insert, and select the header, footer, detail grid, report header, and report end. (I forgot the report header and end. Only tables are displayed in the results .) Use a static text box.
- Insert parameters. In my understanding, variables are inserted. The content in square 1 and 2 is inserted with parameters. First, click Insert and select parameters. On the right side of the software, you can select the parameter name and type. Next, click Insert integrated text box, double-click the text box, and select insert field to insert the variable.
- Connect to SQL. Click 3 to display "set database connection string and query SQL-Detail grid". You can copy and paste the contents in connectstring in the data center billing system. Then fill in the query SQL statement. Click Edit. query the SQL statements to generate fields and table columns Based on fields.
- Modify the title line. You can double-click the content under the heading line to directly modify it.
- Finally, we can save it directly.
- Production Summary: The report design stage mainly involves the interaction between reports and SQL.