A computer-implemented method includes selecting a first member of a first
dimension of a database to be included at a first location in a report.
The first member includes first data to be retrieved from the database. A
blank space to be added at a second location relative to the first member
is also selected. A database query is generated that includes a first
instruction to retrieve first data included in the first member. The
first instruction is located at a first position in the query and the
first data will appear in the report at the first location. The database
query also includes a second instruction to retrieve a null set of data.
The second instruction is located at a second position in the query and
the null set of data will appear in the report at the second location.