Contents | Index | Search


  • Introduction
    • General
    • Screen
  • Effective Workspace Techniques
    • View Mode
      • Layout
      • Layout Preview
    • General Procedures
      • Choosing a Page Layout
      • Zoom
      • Status Line
      • Ribbon
        • Text Tools
        • Table Tools
        • Drawing Tools
        • Minimize the Ribbon
        • Quick Access Toolbar
        • The File menu
      • Mini-toolbar
      • Default Settings for Font and Frame
      • Undo or redo an action
        • Undo an action
        • Redo an action
      • Variable/field list and drag & drop
    • Inserting and Arranging Objects
      • Inserting Objects
      • Size and Position of Objects
      • Arrangement as an Object List
      • Grouping of Objects
      • Copies of Objects
        • Copy objects
        • Multiple Copies of Objects
      • Importing Objects
    • Alignment of Objects
      • Displaying the Alignment Grid
      • Aligning Objects
      • Guides in the Workspace
    • Project Options
      • Options for the Project
      • Default Settings for Font and Frame
      • Preview
      • Options for the Workspace
        • Font for formula wizard
        • Settings for Usability
        • Changing Column Widths Using the Cursor
        • AutoRecover
  • Mastering Appearance Conditions
    • Where Will the Objects be Printed?
    • Working With Appearance Conditions
    • Working With Layers
      • Defining Layers
      • Assigning Objects to a Layer
  • Creating Professional Tables
    • Working with the Report Container
      • Report Container and Object list
      • Multiple Report Containers
    • Modifying the Fields and Columns
      • Table Tools and Mini-toolbar
      • Object Dialog
      • Variables-/Field-List and Drag & Drop
    • Defining Multiple Line Layouts
    • Defining Column Contents
    • Defining Group Lines
    • Tables in columns (Nested Tables)
    • 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
      • Anchored Lines (Overlapping Cells)
      • Expandable Regions
    • Sort Orders in the preview
  • Producing Analyses
    • Creating Charts
      • Inserting a Chart Object
      • Pie, Donut or Circle Chart
      • Clustered Bar Chart
      • 100% Stacked Bar Chart
      • Multi-Row Line Chart
      • Stacked Area Chart
      • Distributed Bubble Chart
      • Funnel
      • Map/Shapefile
      • Radar/Web chart.
      • Treemap
      • Using Series to Determine the Values
      • Mixing Chart Types
    • Creating a Checkbox
      • Inserting a Checkbox
      • Specify Properties
    • Creating a Data Graphic
      • Inserting a Data graphic
      • General
      • Define Bar
      • Define Symbol
    • Creating Gauges
      • Inserting a Gauge
      • Specify Properties
    • Creating a Crosstab
      • Creating a Crosstab Object
      • Defining Groupings
      • Defining Cell Properties
      • The Layout Option and Wrapping Behavior
      • Special Functions
    • Creating a Gantt Chart
      • Insert
      • Properties
    • Creating Statistical Reports With Footers
    • Drilldown Reports (Increase Detail Level)
      • Drilldown via Relations
      • Drilldown via Report Parameters
    • Multi-Column Reports
  • Advanced Functions
    • Linking Objects
      • Object List
      • Creating Interlinks
      • Sequential Interlinking
      • The Individual Size and Position Adaptations
      • The "at end, keep size" Interlink
    • Filter
      • Project Filter
      • Data Filters for Objects
    • Sum Variables
    • User Variables
    • Collection Variables
    • Project Includes
    • Insert PDF Pages
    • Insert HTML Pages
    • Insert OLE Documents
    • Insert Form Template Objects
  • Page Layout
    • Specifying the Page Layout
      • Printer Settings
        • Size Adjustment
        • Use Physical Page
        • Force Paper Size
      • Export Media
      • Templates for Label Formats
      • Defining Your Own Label Format
        • Saving your own label formats in the label template list
    • Layout Regions
      • Active Design Layout
    • Report Sections
      • Table of Contents and Index
      • Reverse Side
  • Output Options
    • Output Options
    • Export in another Format (PDF, XLS ...)
    • Test Print in the Designer
    • Report Parameters
  • Variables, Fields and Expressions
    • Variables-/Field-List
    • The Elements of an Expression
      • Different Expression Modes
      • The Tabs
      • The Editing Line
      • Inserting Data
      • Insert Fixed Text
        • Inserting Linefeed
        • Inserting Tab Stops
      • Inserting Comments
    • 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
      • Arithmetic Operators
      • Relational Operators
      • Logical Operators
      • Formula Errors
  • Overview of LL Variables and LL Fields
    • Overview of Variables
    • Overview of Fields
  • Overview of Functions
    • Abs
    • AddDays
    • AddHours
    • AddMinutes
    • AddMonths
    • AddSeconds
    • AddWeeks
    • AddYears
    • Alias$
    • ApplicationPath$
    • ArcCos
    • ArcSin
    • ArcTan
    • Asc
    • AskString$
    • AskStringChoice$
    • ATrim$
    • Avg
    • Barcode
    • Barcode$
    • BarcodeType$
    • BasedStr$
    • BinaryAND
    • BinaryNOT
    • BinaryOR
    • BinarySHL
    • BinarySHR
    • BinaryXOR
    • BMPMapToGray
    • BMPRotate
    • Capitalize$
    • Case$
    • Ceil
    • Century
    • ChangeLightness
    • CheckMod10
    • Chr$
    • ChrSubst$
    • Cond
    • Constant.Pi
    • Contains
    • Continued
    • Cos
    • Count
    • CountIf
    • Crosstab.Cells.Avg
    • Crosstab.Cells.Max
    • Crosstab.Cells.Min
    • Crosstab.Cells.Sum
    • Crosstab.Col$
    • Crosstab.Col
    • Crosstab.Row$
    • Crosstab.Row
    • Crosstab.Total
    • Crosstab.Value
    • CStr$
    • CurrentDataLineIndex
    • CurrentLineIndex
    • CurrentLineTypeIndex
    • Date
    • Date$
    • DateDiff
    • DateDiff$
    • DateHMS
    • DateInLeapYear
    • DateInRange
    • DateToJulian
    • DateYMD
    • Day
    • Day$
    • Decade
    • DisplayValues$
    • Distinct
    • Div
    • Dow
    • Dow$
    • Drawing
    • Drawing$
    • DrawingHeightSCM
    • DrawingWidthSCM
    • Empty
    • EndsWith
    • Evaluate
    • Even
    • Exists
    • Exp
    • Exp10
    • ExtractDate
    • ExtractTime
    • FirstHeaderThisTable
    • Floor
    • Frac
    • FStr$
    • GeometricAvg
    • GetIniString$
    • GetRegistryString$
    • GetValue
    • GetVar
    • GS1Text$
    • HeatmapColor
    • Hour
    • HSL
    • HTMLtoPlainText$
    • Hyperlink$
    • IBAN$
    • If
    • IssueIndex
    • Int
    • IsNull
    • IsNullOrEmpty
    • Join$
    • JulianToDate
    • LangCase$
    • LastFooterThisTable
    • Lastpage
    • Left$
    • Len
    • LibraryPath$
    • LoadFile$
    • Locale$
    • LocCurr$
    • LocCurrL$ 
    • LocDate$
    • LocDateTime
    • LocNumber$
    • LocTime$
    • LocVal
    • Log
    • Log10
    • Lower$
    • LTrim$
    • Max
    • Maximum
    • Median
    • Mid$
    • Min
    • Minimum
    • Minute
    • Mode
    • Month
    • Month$
    • NativeAvg
    • NativeCount
    • NativeMax
    • NativeMin
    • NativeStdDevPop
    • NativeStdDevSamp
    • NativeSum
    • NativeVarPop
    • NativeVarSamp
    • Now
    • NthLargest
    • NthLargestIndex
    • NthValue
    • Null
    • NullSafe
    • NumInRange
    • Odd
    • Ord
    • Page
    • Page$
    • PlainTexttoHTML$
    • Pow
    • Precalc
    • Previous
    • PreviousUsed
    • ProjectParameter$
    • ProjectPath$
    • Quarter
    • RainbowColor
    • RegExMatch$
    • RegExSubst$
    • RemainingTableSpace
    • Rep$
    • ReportSectionID$
    • RGB
    • Right$
    • Roman$
    • Round
    • RTFtoPlainText$
    • Rtrim$
    • Script$
    • ScriptBool
    • ScriptDate
    • ScriptVal
    • Second
    • SetVar
    • Sign
    • Sin
    • Sqrt
    • StartsWith
    • StdDeviation
    • Str$
    • StrPos
    • StrRPos
    • StrSubst$
    • Sum
    • TableWidth
    • Tan
    • TextWidth
    • Time$
    • Today
    • ToFrac$
    • Token$
    • ToNumber
    • ToRTF$
    • ToString$
    • Total$
    • TotalPages$
    • Translate$
    • UnitFromSCM
    • URLDecode$
    • URLEncode$
    • Upper$
    • Val
    • Variance
    • WildcardMatch
    • Woy
    • Year
    • Year$
  • Overview of Properties
    • Project Properties
      • General Settings
        • Project Description
        • Active Design Layout
        • Number of Issues
        • Display Condition for Issue Print
        • Embed Drilldown Reports
        • Minimum Page Count
        • Language for the Print
        • Design Scheme
        • Sort Order
        • Transition Effects for Slideshow Mode
      • Fax and Mail Variables
    • Common Object Properties
      • Appearance Condition
      • Background / Filling / Zebra Pattern
      • Color
      • Conditional Formatting
      • Content
      • Design Scheme
      • Display Condition for Issue Print
      • Export as Picture
      • Font
      • Format
      • Frame
      • Index Level
      • Locked
      • Name
      • Page Break Before Outputting Object
      • Pattern
      • Position
      • Table of Contents Level
    • Text Objects
      • Object Properties
      • Paragraph Properties
    • Line Objects
      • Object Properties
    • Rectangle Objects
      • Object Properties
    • Circles and Ellipses
      • Object Properties
    • Picture Objects
      • Object Properties
    • Barcode Objects
      • Object Properties
      • Special Functions
      • Barcode Content
      • Supported Barcode Formats
        • Overview of the General 1-D Codes
        • Overview of the General 2-D Codes
        • Overview of Post Codes (1-D and 2-D Codes)
    • Report Container Object
      • Object Properties
      • Element Properties
    • Table Objects
      • Object Properties
      • Special Functions
      • Line Properties
      • Group Line Properties
      • Column Properties
    • Chart Objects
      • Special Fields
      • Circle/Donut
        • Data Source
        • Segment
        • Chart
      • Bar/Line/Areas/Bubbles/Treemap
        • Category and Series Axes
        • Value Axis Settings
        • Chart
      • Funnel
        • Data Source
        • Funnel Segment
        • Chart
      • Map/Shapefile
        • Shapefile Selection
        • Assignment
        • Value
        • Colors
      • Diagram Area (All Diagram Types)
      • Colors (All Diagram Types without Shapefiles)
    • Crosstab Objects
      • Special Functions
      • Cell Properties
      • Properties for the Crosstab Area
    • Gantt Chart
      • Object Properties
      • Special Fields
      • Content
    • Gauge Objects
      • Content
    • Data Graphic
      • General
      • Bar Properties
      • Symbol-Properties
    • Checkbox Objects
      • Object Properties
    • Formatted Text Objects
      • Object Properties
    • Form Control Objects
      • Edit
      • Checkbox
      • Combobox
      • Button
    • HTML Text Objects
      • Object Content
    • PDF
      • Object Content
    • OLE Container
      • Object Content
    • Form Template Objects
      • Object Properties