Before the exhibition finally finished the finishing work of the computer room--Report
As for the report of VS how the whole, in fact, many students have written the blog like the instructions, in this, please allow me to stand on the shoulders of giants, directly paste the corresponding blog link address: Machine Room Reconstruction--report (Zhang Huan)
This blog mainly describes the issues I have when implementing the report function and the solution :
The weekly checkout list is not intended to be complete, because the students say that the way the data source violates the seven layer, so, the daily bill to use the seven-storey. Since none of the previous functions used to bind the data source, it was decided to try it out at the end of the refactoring work,
It turns out that the price of learning is =bug, when you bind a data source, you first report one such error: the Tablix "Tablix1" references an invalid DatasetName "Daydataset".
The reason for the error is that my daily and weekly knots are in the database a table (t_check_info) design Week checkout and daily checkout orders with different data source names. Because I was too lazy, and then design the weekly statement, the day of the knot in the form of the table directly copied over, resulting in an error, as follows:
After the code is not wrong, start running, error--Other information: User ' sa ' login failed.
Emergency call degree Niang, found the solution, but also confirmed what Master said-as long as the computer room charge system problems, not found on the internet (accelerated's power is really great)
?
After solving the above problems, I thought everything was all right, did not expect to report the following mistake, took one hours to solve:
Where is the reason? Look at the following two photos:
The code for the UI layer form has been sequentially uploaded to the t_check_infotableadapter in the order that the start date one by one corresponds to the code in the Configuration wizard:
Me.T_Check_InfoTableAdapter.Fill (Me.LinkDataSet.T_Check_Info, startdate, EndDate)
So you don't have to set the parameters.
Through the two methods of the report, feel that the parameters of the report data is set to go to the 7-tier preparation, directly connected to the data source, if set parameters, it will not recognize, will report the above error.
VB.net Edition computer room charge system--vs report production and function realization problems and solutions (the cost of studious =bug)