VB.net report Production-"over snag cheats"

The reconstruction of the computer room toll system report production, can be said to be laborious. Finally made to look back, feel very simple. But it is worth remembering is to do not come out of the time that melancholy tangled, especially hard to search for Ganchangcunduan and fruitless wringing ...

From discovery to production to completion, each step is a "snag", this we later brought to you "over snag cheats".

In fact, very early attention to the report, from the online search about vb.net production reports of various methods, what use external plug-ins, Crystal Reports and Vs comes with the ReportViewer are looked at, and finally to consider the ease of operation and compatibility, the use of VS2013 to choose the report.

Reference Blog: http://blog.csdn.net/xiaoxian8023/article/details/7106588

Now, to everyone Grand launch: "Over snag cheats".

Snag: My God, the report "Lost"?

First, follow the action to open VS, right-click "Add"-"New item" and you should be able to find Report Designer, () but I didn't start ...

Over snag mode one: in the VS2013 Online search ReportViewer control, repeatedly lost no fruit; so go to Baidu no brain hit "ReportViewer control " Download, or vb.net from the report about the plug-in download, did not, even to the official web search for a long, or not.

Finally found a possible yes, downloaded an installation is actually SQL Server2014, official online is said to be able to view the report, and only this one, in a try to become the "innocent was tried."

Mode two: Think how also can not, go to see with me the "homologous" of that classmate's have wood, tragedy is somebody else really have! Someone laughed three days more than ... Later can only be repaired with the installation package (do not uninstall, the process and reinstall the same), took a full two hours, finally succeeded ~

Snag two: SQL Server Configuration Manager service "Falling Down".

When I turned on VS, I found that I couldn't connect to the database, so I thought about SQL Server Configuration Manager first. When open, a "remote Procedure call failed" (for example) occurs.

Over snag: On-line check, is VS2012 and SQL Server2008 compatibility problems, need to uninstall a software from the control Panel, see.

Snag three: When making a report, always prompt for "error during local report processing".

Over snag mode one: This hint generally indicates that there is a problem with parameter passing, that is, the parameter name, type (time type) is inconsistent with the settings in the program. Check carefully, indeed because of the omission of one, but changed the later still not.

So, has had the snag mode two: After unceasingly searches, finally discovered is in the code to set the report resource name, the address writes the wrong. While the "UI" is written on the right, when you open the Properties window, you see that "root namespace" is the name of the entire program, "main form" (), and then it's fine.

Snag four: When doing statistics "summary item", want to add the data in the database checkout table, but after inserting the table and then running always have duplicates (for example), this solution does not say more, we look at the following blog is good. Small series Hard search for half a day to learn the solution.

Reference: http://blog.csdn.net/zhaolijing2012/article/details/12450561

Summary: A full struggle for a day to complete the seemingly "easy" report. Although the great God seems to be extremely sophisticated, comprehensive blog as a guide, but do not practice, there is no way to find the part of the problem is not suitable for themselves, it is easy to later problems. In the final analysis: practice is the only standard for testing truth.