Page Comparison

...

This action sequence will compose the following queries:
If the user selects the department report, the query will look like this:

select

department

as

column1,

 sum(actual)

from

quadrant_actuals

where

region

=

'{region}'

group

by

department

order

by

actual

desc

If the user selects the position report, the query will look like this:

select

positiontitle

as

column1, sum(actual)

from

quadrant_actuals

where

region

=

'{region}'

group

by

positiontitle

order

by

actual

desc

Note that in both cases, the first column is selected and renamed as column1. This is an important thing to note because when the report is built using the Report Design Wizard, column1 will be the column that's used for getting at the data.

...