Vs prepare a report (Daily Statement of the individual edition of the data center billing system)

Reports are required for daily and weekly settlement of the data center charging system. Remember to use the report designer to prepare reports for the VB data center charging system. Now vs comes with the report design function, you only need to bind the data source to display the statement. After reading the blogs of teachers, sisters, and students, I finally realized it. The following is a detailed tutorial:

1. Add a dataset

2. Add data items as prompted

3. Create a connection after the Configuration Wizard appears

4. Select the server, enter authentication, and select the database name.

5. Confirm the connection Configuration Wizard after the connection test is successful. Next Step

6. Select to use the SQL statement and click Next.

7. Enter an SQL statement to generate a query

8. Click Finish to add the dataset.

9. The next step is to add a report.

10. Then add a table from the toolbox.

11. automatically display the dataset attributes and select the added data source and dataset.

12. design the table header and data, and add a report control to the form.

13. After the report is added, F7 enters the code design interface and an error is prompted. The reason is that the SQL statement in step 1 does not assign a value to @ date, so that it is the value of the datetimepicture control. Here I use an entity to receive the datetimepicture value.

So far, the report is added. The implementation code of other layers may vary with each other, and the implementation methods are also different. I hope it will be helpful for you to make reports. If you have any shortcomings, please criticize and correct them!