Databases Reference
In-Depth Information
•
Report Settings | Header/Footer
: It is used to set headers and footers for
our report. It has a few default variables that can be shown, such as page
number, date, time, filename, report name. An image can be included as well;
this can be useful to add a logo on our reports.
•
Report Settings | Selections
: Instead of basing our report on the current
selection in our document, we can also clear all selections or define a
bookmark as a starting point. Besides selections, we can use the
Banding
function to loop the report over all possible values of a field. By setting
Banding
at the report level, instead of applying it to a single report page,
it is applied to all pages in the entire report.
Although it is technically a "static report", it's also dynamic because the report
output, either a printed page or a PDF file, will be generated the moment the user
executes the report by selecting it from the
Reports
menu. This means that all
selections the user has in place when creating the report will also be applied to the
output, unless otherwise specified via the
Report
settings.
Now that we have created our
Reports
sheet and have created a static report, this
chapter is almost at its end. The new objects we encountered in this section are the
straight table, table box, and pivot table. Besides these objects, we also learned about
variables, cyclic and drill-down groups, auto minimizing, and the Report Editor.
Now let's go to the final part of this chapter, in which we will take a short look at
some of the objects that have not been covered in detail.
Other charts
Over the course of this chapter, we looked at the most common charts found within
QlikView. There are, however, some charts that we did not use, and we will use
this final section to take a quick glance at them. Do not worry though; with the
knowledge you picked up earlier in this chapter you should have no problem
creating these charts as well. Examples of these charts are also included on the
Other
Charts
tab of this chapter's solution file.