Make dynamic association filtering for report's data input

Last Post 16 Apr 2009 09:54 PM by freezea. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
freezea
New Member
New Member

--
16 Apr 2009 09:54 PM
Background
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.

Difficulty
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.

Solution
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.
You are not authorized to post a reply.

Acceptable Use Policy