Table of contents
- Designer Help
- Introduction
- Getting Started
- Effective Workspace Techniques
- Mastering Appearance Conditions
-
Creating Professional Tables
- Using Advanced Features With the Report Structure
- Practice: Defining the Report Structure Correctly
- Modifying the Fields and Columns
- Defining Multiple Line Layouts
- Defining Column Contents
- Defining Group Lines
-
Table Layouts
- Align Columns
- Fixed Size
- Printing Header Lines and Footer Lines Again
- Defining the Size of the Table Variably
- Forcing a New Page
- Creating a Conditional Page Break
- Keeping Lines Together
- Defining Totals and Counters
- Outputting Free Content Before and After a Table
- Defining Columns Across Multiple Lines
- Producing Analyses
- Advanced Functions
- Different Layout Techniques
- Output Options
-
Variables, Formulae and Expressions
- Variable List
- The Elements of an Expression
-
Working With Functions
- Notation of Functions
- Value Types
- Overview of the Functions
-
Using Functions
- Convert a Number to a String With Str$()
- Convert a String to a Number With Val().
- Convert a String to a Date With Date()
- Convert a String to a Barcode With Barcode()
- Convert a String to a Picture With Drawing()
- Truncate Strings
- Formatting a Data Value With Date$()
- Formatting a Number Value With FStr$()
- Formatting Currencies With LocCurrL$() or LocCurr$()
- Page Numbers With Page$() or Page()
- Counting Values With Count()
- Only Count Certain Values With CountIf()
- Totaling With Sum()
- Obtaining User Input via a Dialog With AskString$()
- Appearance Conditions With Lastpage()
- Logical Conditions With Cond()
- Working With Null Values
- Working With Operators
- Overview of LL Variables and LL Fields
-
Overview of Functions
- Abs
- AddDays
- AddHours
- AddMinutes
- AddMonths
- AddSeconds
- AddWeeks
- AddYears
- Alias$
- ArcCos
- ArcSin
- ArcTan
- Asc
- AskString$
- AskStringChoice$
- ATrim$
- Avg
- Barcode
- Barcode$
- BarcodeType$
- BasedStr$
- BinaryAND
- BinaryNOT
- BinaryOR
- BinarySHL
- BinarySHR
- BinaryXOR
- BMPMapToGray
- BMPRotate
- Capitalize$
- Case$
- Ceil
- Century
- CheckMod10
- Chr$
- ChrSubst$
- Cond
- Constant.Pi
- Contains
- Continued
- Cos
- Count
- CountIf
- Crosstab.Cells.Avg
- Crosstab.Cells.Max
- Crosstab.Cells.Min
- Crosstab.Col$
- Crosstab.Col
- Crosstab.Row$
- Crosstab.Row
- Crosstab.Value
- CStr$
- Date
- Date$
- DateDiff
- DateDiff$
- DateHMS
- DateInLeapYear
- DateInRange
- DateToJulian
- DateYMD
- Day
- Day$
- Decade
- Distinct
- Dow
- Dow$
- Drawing
- Drawing$
- DrawingHeightSCM
- DrawingWidthSCM
- Empty
- EndsWith
- Evaluate
- Even
- Exists
- Exp
- Exp10
- FirstHeaderThisTable
- Floor
- Frac
- FStr$
- GeometricAvg
- GetValue
- GetVar
- Hour
- HSL
- Hyperlink$
- If
- IssueIndex
- Int
- IsNull
- IsNullOrEmpty
- Join$
- JulianToDate
- LangCase$
- LastFooterThisTable
- Lastpage
- Left$
- Len
- LoadFile$
- Locale$
- LocCurr$
- LocCurrL$
- LocDate$
- LocDateTime
- LocNumber$
- LocTime$
- LocVal
- Log
- Log10
- Lower$
- LTrim$
- Max
- Maximum
- Median
- Mid$
- Min
- Minimum
- Minute
- Mode
- Month
- Month$
- Now
- NthLargest
- NthLargestIndex
- NthValue
- Null
- NullSafe
- NumInRange
- Odd
- Ord
- Page
- Page$
- Pow
- Previous
- PreviousUsed
- ProjectParameter$
- ProjectPath$
- Quarter
- RainbowColor
- RegExMatch$
- RegExSubst$
- RemainingTableSpace
- Rep$
- RGB
- Right$
- Round
- RTrim$
- Second
- SetVar
- Sign
- Sin
- Sqrt
- StartsWith
- StdDeviation
- Str$
- StrPos
- StrRPos
- StrSubst$
- Sum
- Tan
- Time$
- Today
- Token$
- ToRTF$
- Total$
- TotalPages$
- Translate$
- UnitFromSCM
- Upper$
- Val
- Variance
- Woy
- Year
- Year$
-
Overview of Properties
- Project Properties
- Common Object Properties
- Text Objects
- Line Objects
- Rectangle Objects
- Circles and Ellipses
- Picture Objects
- Barcode Objects
- Report Container Object
- Table Objects
- Chart Objects
- Gauge Objects
- Crosstab Objects
- Formatted Text Objects
- Form Control Objects
- HTML Text Objects
- OLE Container
- Form Template Objects