SQLConfiguration SQLConfiguration


Refining Queries  «Prev 

Working with Crosstab queries


Details of a Crosstab query

Crosstab Query

1)Total Row
As with Totals queries, you can pick aggregate functions to perform. For the row heading and column heading, this is set to Group By.
2)Row heading
In this case, ProjectDescription, this is the value that will be displayed for each row.
3)Column heading
This option specifies the column heading across the page. In this case, it isMonths.
4)Value
This is the value that will be displayed for each column and row.