How to Implement the drop-down tree in Web applications without writing code in. NET reports

Most programmers who have done client programs know that when End Users fill in data on the interface, if there is a drop-down tree (for example) for data with a large number of layers ), it adds a lot of colors to the application and increases the efficiency of end user operations. However, when developing web applications, the programmer finds that the drop-down tree control directly used in previous client programming tools is gone. What should I do?

In. NET reports, how does one implement the drop-down tree in Web applications without writing code?

There are three solutions: 1. Develop one by yourself; 2. download a free control from the Internet; 3. Use a commercial development tool.

We found that the 1st methods were time-consuming and labor-consuming, just like the tires of our own car were broken, and we didn't buy them if we didn't repair them. Instead, we produced a wheel on our own, which was a waste of energy. The 2nd methods seem to save money. In fact, it is not difficult to analyze them carefully. This method is actually more time-consuming and labor-intensive! The reason is: 1) controls downloaded from the Internet are usually intended by programmers, and the quality and performance are hard to guarantee. Once there is a problem, it is hard to solve. 2) if you need to modify this control and find the original person to modify it, it is impossible to understand the internal code by yourself-it takes more time than writing one by yourself! 3) if you still need drop-down lists (associated filtering, dynamic filtering), drop-down calendars, import excel files, upload images, upload files, and other controls, you can also download them online, as a result, the entire application becomes unstable and cannot be modified.

If you want to buy a commercial development tool, are there any suitable tools? Is it very cheap? Have you purchased after-sales service (Support, upgrade, and demand modification )?

You can certainly tell us that Boji reports are the development tools that can solve these problems! Boji reports are not only a powerful report tool, but also a zero-code development tool!

Here, let's take a look at the function of the drop-down tree of the blog report. Whether cheap, after-sales is in place, you can go to the site of Boji (http://www.bonzerreport.com/) to see, must be satisfied. ^_^.

It is very easy to add a drop-down tree for the programme development edition. You just need to modify the cell editing style and add the data correspondence relationship. The specific steps are as follows:

Add a dataset ds3 in the filling table, configure-> dataset-> Add-> SQL dataset-> specify the mode as PUBLIC-> select the "customer" data table, select the "Customer ID, customer name, country, region, city" fields to complete dataset settings. Finally, the automatically generated SQL statement is as follows:

In. NET reports, how does one implement the drop-down tree in Web applications without writing code?

 

Select the cells in the tree to be pulled down, right-click the menu, and enter properties. The data filling dialog box is displayed. In the editing style, set it to the drop-down tree, as shown below:

In. NET reports, how does one implement the drop-down tree in Web applications without writing code?

 

In the Settings dialog box of the drop-down tree, set the root node title "select by region", select only leaf nodes to the selected status, and add a node Layer 1.

In. NET reports, how does one implement the drop-down tree in Web applications without writing code?

 

Select node Layer 1 for editing, set the dataset to ds3, and set the display column and data column to the "country" field respectively. Then add node Layer 2, set the dataset to ds3, display columns and data columns as the "region" field, and set the filter condition to "Country =" $1 "", starting from the second layer, you can use $1, $2, $3… to filter conditions ...... Indicates the upper layer, the upper layer, and the upper layer ...... The data value of the node.

 

In. NET reports, how does one implement the drop-down tree in Web applications without writing code?

 

Similarly, we add leaf nodes and set them as follows:

 

In. NET reports, how does one implement the drop-down tree in Web applications without writing code?

 

After setting the drop-down property, enter ds3.select1 (company name, customer ID = value () in the displayed value expression attribute of cell B2 and publish it to the web for preview. The effect is as follows:

In. NET reports, how does one implement the drop-down tree in Web applications without writing code?