The Query Report is great for doing Adhoc Reporting
for anybody who understands SQL. For a business user,
they would have problems getting the correct syntax.
It would be great to maintain the existing Query
Report as is, but provide additional filters to
provide, arbitrary selection of the Columns, sort,
by, group by, and providing adhoc parameters during
execution time. These filters can be done using drop-
down widgets, text boxes...etc, so very small amount
of typing is reqired.