Length of Expressions
When creating layout calculations that use complex
expressions, limit the length of the expression to less than 1,000
tokens. A token is a keyword, identifier, constant, or special character
symbol that the server identifies when it parses the SQL. For example,
the expression 1+1+1+1+1+1+1+1+1+1 contains approximately 28 tokens,
whereas the expression 1+1+1...+1 (400 times) contains more than 1000
tokens.
Tip: The Sales Commissions for Central Europe sample report
in the GO Data Warehouse (analysis) package includes expressions.
For more information about The Sample Outdoors Company samples, see Sample Reports and Packages.