Column types in the report generator
Each column on your report can contain a different 'type' of information.
These extract information from your database such as Stock Codes, Transactions etc. Use <Shift+F2> when entering a variable to browse the available list.
See the Report Generator category for an overview of the variables in the Report Generator.
This column type will allow you to have the text result of a formula.
You can 'add' text together (concatenate) using the '+' character.
This column type allows you to perform numeric calculations.
Enter any literal text you want to appear on the report in this column type.
A short cut for having a 'Text' column type as it will work out the width of the text entered. If you were quoting text in a 'Text' column type you will need to encase your text in quotes. e.g.
"Profit :" if you missed the quotes you would get an error.
Format the resulting date using your configured date format.
A short cut for having a 'Text' column type and using the DATE$ function.
- Hidden report generator columns
- How do I use calculation sequence?
- Why are there three report ranges?
- What is a report generator variable?
- Accessing the values of other columns.
- Useful Keys