Make dynamic association filtering for report's data input

Dynamic filtering for Report

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.

It is very difficult to realize dynamic association filtering by writing JavaScript. According to the example above, difficulties are as follows:
1. Save a JavaScript dataset which contains all the cities.
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. Each time the value of the province drop-down box changed, the algorithm will be used. Therefore, the efficiency of the JavaScript should be much high. But it is very difficult.
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.



No responses found. Be the first to comment...

  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name: