Column types in the report generator

Summary

Each column on your report can contain a different 'type' of information.

More Information

Column Types

File Variable

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.

Text

This column type will allow you to have the text result of a formula.

$UPSTR{A03} would convert all the characters in the company name to upper case.

Concatenation You can 'add' text together (concatenate) using the '+' character. "Hello" + " World" would be output as "Hello World". $UPSTR{"Hello" +" "+"World"} would be output as "HELLO WORLD". "Account Code:" + A02 would append the account code to the end of "Account Code:" to produce "Account Code:ABC001" (if the account code was 'ABC001').

Numeric

This column type allows you to perform numeric calculations.

Document Total T11 + T12 will add the Nett & V.A.T. of a document to give the Gross amount of the document.

Quote

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.

Date

Format the resulting date using your configured date format.

A short cut for having a 'Text' column type and using the DATE$ function.

See also

• 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

Feedback

Thank you for using our Knowledge Base, we value your feedback. Did you find this article useful? 'Yes' or 'No'

Keywords AND Misspellings

columns, report generator