Basic Report Structure                          

Basic Report Structure

All reports have two components, a level that defines the report appearance, and a

query that defines report data.

Levels

You add level to a page when you create a report.Below are objects that you will use

often when building reports in 1KEY.

For more information about all objects, see "Creating a Level"

Queries

Queries determine what data items appear in the report. Sometimes you want detail rows of

data, which you obtain by using a simple SELECT statement. Other times you must calculate

totals or averages using aggregate functions and grouped columns, or must apply filters to show

only the data you want.

1KEY Query Builder automatically creates the queries you need as you build reports.

However, you can modify these queries or create your own custom queries to get the results you

want.

For more information about queries, see "Creating a Query"

User Guide 8