The data of report usually have various interrelations. Therefore, when designing a data input interface, we usually meet two drop-down boxes with direct relations. In this condition, dynamic association filtering will be very helpful for data input.
For example, one is province, and another is city. Then, after selecting a province, only the cities of that selected province should be available.
According to the example above, difficulties are as follows:
2. In the province drop-down box, keep a record that which cell is the city drop-down box.
Then, when the value of the province drop-down box changed, the dynamic association filtering of corresponding cell will be triggered.
3. Write dynamic association filtering algorithm.
Above is only a case with two drop-down boxes. In fact, there are some more complex situations.
Sometimes, a drop-down box controls several drop-down boxes.
When the value of it changed, the values of all related drop-down boxes should be changed correspondingly.
Another complex condition is cascade association filtering.
It means that drop-down box A controls drop-down box B, and drop-down box B controls drop-down box C, and so on.
Even if dynamic association filtering can be realized by writing programs, the workload must be very huge.
For users’ convenience, RAQ Report
provides the function of dynamic relation filtering directly. With RAQ Report, users only need to define condition expression for dynamic association filtering and select a trigger cell.
This post is from freezea's blog. You are welcomed cc it anywhere, and please indicate the source.
If you would like to read more articles about reporting tool, you are also welcome to refer to my blog