vb.net Edition computer room charge system--vs report production and function realization problem and solution (the cost of studious =bug)

Source: Internet
Author: User

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)

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.