It is a very common requirement to sort report items by clicking report header.
With traditional reporting tools, users have to write SQL statements and web page to realize this requirement, and it consumes too much time and energy. As a new generation of Excel-like Web reporting tool, RAQ Report can help users to realize the requirement easily.
In RAQ Report, through the combination usage of macro, parameter, and hyperlink, users can pass different parameters to dataset function dynamically to control the sorting of a field. Then, they can click the report header to sort report items.
Step 1: Set parameter and macro in the report template.
Step 2: Use macro and hyperlink to realize sorting.
For detailed information, please refer to http://www.raqsoft.com/