The report is really a new thing for me. It took him a long time to get the main idea of the report.
First,VB has a report in the control Grid++report engine5.0typelibrary. Secondly. The production of the report is made through the software "grid++report Report Designer". At last. This is the report. the interaction between VB and SQL .
First, the production steps of the report
- Download:
I reckoned is I download too old when I download 4.5 The version number of the time also to register their own, the results later vb Middle-aged displays error messages for reports that are not installed.
When I install 5.0 above the version number basically does not have this problem.
(: http://www.rubylong.cn/Download.htm )
- Production:
- First click Insert , select Header . footer , detail grid, report header, and end of report . (I've forgotten the report header and the end of the report.) The results show only a table. Text can be used with a static text box .
- Insertnumber of references. My understanding is to insert variables. China Grid1,2is to insert a number of references. First of all. ClickInsert, selectnumber of references
Next, click Insert synthetic text box insert Field
- start with sql 3 appear" Set database connection string with query sql --detail grid "can be in the computer room charging system connectstring sql
Then click Edit-based on detail query sql generate fields and generate table columns from fields.
- Change the header row. You can directly double-click the title row below the content directly change.
- Finally we are able to save directly.
- Production Summary: The design report stage is mainly related to the report and SQL alternating.
Copyright notice: This article blog original articles, blogs, without consent, may not be reproduced.
Room rate System--statement (1)