You are previewing Crystal Reports 2008: The Complete Reference.
O'Reilly logo
Crystal Reports 2008: The Complete Reference

Book Description

Your One-Stop Guide to Enterprise Reporting with Crystal Reports 2008

Transform disconnected corporate data into compelling, interactive business intelligence using all of the powerful tools available in Crystal Reports 2008. Through detailed explanations, real-world examples, and expert advice, this comprehensive guide shows you how to create, maintain, and distribute dynamic, visually appealing enterprise database reports.

Crystal Reports 2008: The Complete Reference explains how to select and gather pertinent business data, organize it into manageable groups, and assemble it into user-friendly business reports. You will learn how to improve report interactivity with sort controls and the parameter panel; solve complex reporting problems with cross-tabs and subreports; integrate Crystal Xcelsius dashboards; reduce development time; and publish your results to Web and Windows applications.

  • Integrate pictures, multimedia files, graphs, and charts

  • Allow user-controlled report sorting with new sort controls

  • Develop sophisticated formulas and custom functions with the Formula Workshop

  • Embed Flash files, including Xcelsius 2008 interactive dashboards

  • Create complex cross-tab reports with new derived rows and columns

  • Export reports into Word, Excel, Acrobat, and updated XML formats

  • Enhance Web interactivity with the new parameter panel and optional parameter fields

  • Work with SQL databases, OLAP cubes, and proprietary systems

  • Centralize design elements and auto-update reports using the repository

  • Schedule and distribute reports with the latest BusinessObjects Enterprise XI 3.0

  • Embed reports in Web and Windows applications using Visual Studio 2008

Table of Contents

  1. Cover 
  2. Copyright
  3. About the Author
  4. Contents at a Glance
  5. Contents 
  6. Acknowledgments
  7. Introduction
  8. Part I: Designing Reports
    1. 1: Getting a Feel for Crystal Reports 2008
      1. Introducing Crystal Reports 2008
        1. Crystal Reports Screen Elements
        2. Starting Out: Opening or Creating a Report
      2. Using the Report Wizards
      3. Using the Blank Report Option
        1. The Database Expert
        2. The Design Tab and Field Explorer
        3. Report Sections
        4. Previewing the Report
        5. Moving and Sizing Objects
        6. Formatting Objects
        7. Customizing Crystal Reports Behavior
      4. The Report Explorer
      5. The Workbench
        1. Creating Projects and Adding Existing Reports
        2. Adding Report Packages
      6. The Dependency Checker
        1. Checking Dependencies in the Current Report
        2. Checking Dependencies for Workbench Projects
    2. 2: Sorting and Grouping
      1. Sorting Your Report
        1. New Interactive Sorting
      2. Grouping Records
        1. Manipulating Existing Groups
        2. The Group Expert
        3. Adding Summaries
        4. Multiple Groups
        5. Specified Order Grouping
        6. Drilling Down on Data
        7. Grouping on Date Fields
        8. Customizing Group Name Fields
        9. Grouping on Formula Fields
        10. Top N Reporting
        11. Hierarchical Groups
    3. 3: Analyzing with Advanced Selection Criteria
      1. Three Different Ways to Select Data
      2. The Select Expert
        1. Refreshing the Report Versus Using Saved Data
        2. Selection with Date Fields
      3. Manipulating the Selection Formula Directly
      4. Performance Considerations with Record Selection
    4. 4: Using Formulas
      1. The Formula Workshop
      2. The Formula Expert
      3. The Formula Editor
        1. Data Types
        2. Creating a New Formula
        3. Editing, Renaming, or Deleting an Existing Formula
        4. Copying Formulas
      4. Number Formulas
        1. Order of Precedence
      5. String Formulas
        1. The ToText Function
        2. Picking Apart Strings
      6. Date/Time Formulas
        1. Number of Days Between Dates
        2. Number of Hours and Minutes Between Times
        3. Month, Day, Year, Hour, Minute, and Seconds Functions
        4. DateValue Function
      7. If-Then-Else Formulas
        1. Data Types in If-Then-Else Formulas
        2. Multiple Actions with One If-Then-Else Statement
        3. Helpful Built-in Functions for If-Then-Else Formulas
      8. Other Crystal Reports Logic Constructs
        1. Select Case Statement
        2. For Loop
        3. While Do Loop
      9. Boolean Formulas
      10. Variables in Formulas and Evaluation Times
        1. Declaring a Variable
        2. Variable Scope
        3. Assigning a Value to a Variable
        4. Displaying a Variable’s Contents
        5. Evaluation Times and Report Passes
        6. When Not to Use Variables
      11. User Function Libraries
      12. Running Total Fields
    5. 5: Creating Custom Functions
      1. Custom Functions Defined
      2. Creating Your Own Custom Functions
        1. Extracting Custom Functions from Existing Formulas
        2. Creating Custom Functions from Scratch
        3. Modifying Existing Custom Functions
      3. Sharing Custom Functions with Other Users
      4. Using Custom Functions in Your Formulas
    6. 6: Making Your Reports Visually Appealing
      1. Setting Page Size, Orientation, and Margins
      2. General Formatting
        1. The Formatting Toolbar
        2. The Format Editor
      3. The Highlighting Expert
      4. Conditional Formatting Formulas
        1. Absolute Versus Conditional Formatting
        2. Creative Use of the Suppress Property
      5. Special Fonts, Graphics, Line Drawing, and Barcodes
        1. Using Special Fonts
        2. Using Bitmap Graphics
        3. Line and Box Drawing
        4. Printing Barcodes
      6. Text and Paragraph Formatting
        1. Format Editor Paragraph Formatting Tab
      7. The Format Painter
      8. Report Alerts
        1. Basing Report Formulas or Conditional Formatting on Report Alerts
      9. Crystal Reports Templates
        1. The Template Expert
        2. Creating Your Own Templates
      10. Adding Custom Text
        1. The Field Heading Text Object
        2. Combining Database Fields
        3. Combining Special Fields
        4. Formatting Individual Parts of Text Objects
        5. Importing Text from a File
    7. 7: Using Sections and Areas
      1. Formatting Sections with the Section Expert
        1. The Section Expert
      2. Creating Summary and Drill-Down Reports
        1. Drill-Down Reports
      3. Multiple-Column Reports for Labels and Listings
      4. Using Multiple Sections
      5. Conditionally Suppressing Sections
        1. Printing a Bonus Message for Certain Records
        2. Printing a Different Page Header on Page 2 and Later
        3. Printing Odd and Even Page Headers or Footers
      6. Underlaying Sections
    8. 8: Analyzing with Cross-Tabs
      1. Creating a Cross-Tab Object
        1. Editing an Existing Cross-Tab
        2. Creative Use of Grouping and Formulas
      2. Multiple Rows, Columns, and Summarized Fields
        1. Reordering Fields in the Rows, Columns, or Summarized Field Boxes
      3. New Derived Rows, Columns, and Cells
        1. Creating Calculated Members
        2. Using Embedded Summaries
      4. Customizing Cross-Tab Appearance
        1. The Style Tab
        2. The Customize Style Tab
        3. Labels or Legends with Cross-Tabs
        4. Conditionally Formatting Cross-Tabs
        5. Cross-Tab Virtual Page Formatting Options
    9. 9: Creating Charts
      1. Types and Layouts of Charts
        1. Chart Type
        2. Chart Layout
      2. Creating Charts
        1. The Type Tab
        2. The Data Tab
        3. The Axes Tab
        4. The Options Tab
        5. The Color Highlight Tab
        6. The Text Tab
        7. Placing and Sizing Charts
        8. Modifying Existing Charts
        9. Zooming In and Out on Charts
      3. Drilling Down on Charts
      4. Finer Points of Chart Formatting
        1. Customizing Charts with Chart Options
    10. 10: Creating Geographic Maps
      1. Different Map Types
      2. Adding a Map
        1. The Data Tab
        2. The Type Tab
        3. The Text Tab
      3. Drilling Down on Maps
      4. Changing the Map View
        1. The Map Navigator
        2. Resolving Data Mismatches
        3. Map Layers
    11. 11: Integration with Crystal Xcelsius and Flash
      1. Adding a Flash .SWF File to a Report
        1. Flash Formatting Options
      2. Integrating Crystal Reports 2008 with Xcelsius
        1. Using Flash Variables with Crystal Xcelsius 4.5
        2. Integration with Xcelsius 2008
    12. 12: Using Subreports
      1. Unlinked Subreports
        1. Drilling Down on Subreports
      2. Linked Subreports
        1. Linking Based on Formula Fields
        2. Linking to Existing Parameter Fields in Subreports
      3. Subreport Formatting with the Format Editor
      4. On-Demand Versus In-Place Subreports
      5. Passing Data Between Main Reports and Subreports
        1. Handling Empty Subreports
      6. Performance Considerations
    13. 13: Interactive Reporting with Parameter Fields
      1. Creating a Parameter Field
        1. Responding to Parameter Field Prompts
        2. Data Type Considerations
      2. Using Parameter Fields in Record, Group, or Saved Data Selection
      3. The New Parameter Panel
      4. Displaying Parameter Field Values on the Report
      5. Creating Pick Lists
        1. Static Pick Lists
        2. Dynamic and Cascading Pick Lists
      6. Special Parameter Field Features
        1. Optional Parameter Fields
        2. Multiple Values
        3. Range Values
        4. Controlling Parameter Field Data Entry
      7. Conditional Formatting with Parameter Fields
        1. Highlighting Data Based on Parameter Fields
        2. Conditional Suppression Based on Parameter Fields
      8. Using Parameter Fields with Formulas
        1. Using a Parameter Field for Partial Text Matches
        2. Using a Parameter Field to Change Sorting or Grouping
        3. Using a Parameter Field to Control Top N Reporting
    14. 14: Exporting Reports to Different Formats
      1. Exporting Reports to Office Applications
        1. Exporting to Different File Formats
        2. Exporting and Launching an Application
        3. Exporting to an ODBC Data Source
      2. Sending Reports via E-Mail and Messaging Systems
      3. New Crystal Reports 2008 XML Exporting
        1. Initial Export via Crystal Reports XML Schema
        2. Using an XSLT Transform
    15. 15: Reporting from SQL Databases
      1. Logging On to SQL Databases
        1. Direct Database Drivers
        2. ODBC
        3. OLE DB
        4. Choosing the Database
        5. Changing SQL Options
        6. Changing to a Different Database
        7. Adding Additional Tables to the Report
        8. Removing Unused Tables from the Report
      2. Linking Tables
        1. Database Expert Links Tab
        2. Using Multiple Database Types in the Same Report
        3. Join Types, Link Types, and Join Enforcement
      3. Viewing the SQL Query
      4. Crystal Reports SQL Commands
        1. Creating the SQL Command
        2. Using a SQL Command in a Report
      5. Using SQL Stored Procedures
        1. Choosing Stored Procedures
        2. Working with Stored Procedure Parameters
      6. Using SQL Expression Fields
        1. Creating SQL Expressions
      7. Grouping on the Database Server
        1. Enabling Server-Based Grouping
        2. What’s Required to Use Server-Based Grouping
        3. Effects of Drill-Down
      8. Accommodating Database Changes and Field Mapping
        1. Recognizing Database Changes
        2. Mapping Old Fields to New Names
      9. Performance Considerations
        1. Let the Server Do the Work
        2. Use Indexed Fields
    16. 16: Reporting from Proprietary Data Types
      1. Reporting from Microsoft Outlook
      2. Reporting from the File System Data
      3. Reporting from the Windows Event Log
      4. Reporting from Web Server Logs
      5. Crystal Reporting with XML Data Sources
        1. Using Local XML Data Sources
        2. Using Web-Based XML Data Sources
      6. BusinessObjects Enterprise Universes
      7. Reporting with Salesforce.com Web Data
    17. 17: Reporting from OLAP Cubes
      1. What Is OLAP?
      2. Crystal Reports OLAP Capabilities
        1. Supported OLAP Systems
        2. OLAP Report Creation Methods
      3. Using the OLAP Report Creation Wizard
      4. Adding an OLAP Grid to an Existing Report
        1. Adding an OLAP Grid Object
      5. Changing the OLAP Database Location
      6. Controlling OLAP Grid Appearance
        1. Virtual Page Formatting Options
      7. Interacting with the OLAP Grid
        1. The OLAP Worksheet
    18. 18: Sharing Report Items with the Repository
      1. The Repository Defined
        1. The Repository Explorer Enterprise Items Folder
        2. The Repository Explorer Categories Folders
        3. The Repository Explorer Repository Items Folder
      2. Adding To/Updating the Repository
        1. Creating Folders and Categories
        2. Adding and Deleting Repository Item Objects
      3. Adding Repository Items to Reports
        1. Text Objects or Bitmap Graphics
        2. Custom Functions
        3. SQL Commands and Business Views
      4. Changing Repository Items on Your Report
        1. Updating Repository Versions of Objects
      5. Controlling Repository Rights
        1. Controlling Rights at the Central Management Server Level
        2. Controlling Rights at the Folder and Object Level
    19. 19: Creating Crystal Reports Applications with Visual Studio .NET
      1. Crystal/VS.NET Bundle Options
      2. Crystal Reports Windows and Web Forms Viewer Control Objects
        1. Your First Application: Viewing a Report
      3. Crystal Report Object Types
      4. Integrated Report Designer
        1. Choosing a Data Source
        2. Selecting Records and Adding Field Objects
        3. Formatting Objects and Sections
        4. Sorting and Grouping
      5. VS.NET Report Customization Object Models
        1. Run-Time Customization with the CrystalReportViewer Object
        2. Report Viewer Events
        3. Run-Time Customization with the Crystal Reports Engine (ReportDocument)
      6. Distributing Crystal Reports Visual Studio .NET Applications
        1. General Concepts
  9. Part II: Crystal Reports Enterprise Reporting
    1. 20: Crystal Reports Web Alternatives
      1. Exporting to Static HTML
        1. Hyperlink Capabilities
        2. Cascading Style Sheet Support
      2. Navigating and Viewing Report Parts
        1. Using Navigation
        2. Displaying Report Parts
      3. Introduction to BusinessObjects Enterprise XI 3.0
        1. BusinessObjects Enterprise Defined
        2. BusinessObjects Enterprise XI 3.0 New Features
        3. BusinessObjects Enterprise XI 3.0 Architecture
    2. 21: Using InfoView
      1. Connecting to InfoView
        1. BOE Security Model
      2. InfoView Organization
        1. My Favorites and My Inbox
        2. The Document List
        3. Objects and Instances
        4. Viewing Reports: On Demand or Instance
        5. Viewing Third-Party Objects
      3. Setting InfoView Preferences
        1. General Preferences
        2. Change Password
        3. Crystal Reports Preferences
      4. Searching InfoView Objects and Instances
        1. Object-Level Search
        2. Content Search
      5. Viewing, Printing, and Exporting Reports
        1. Supplying Database Credentials and Parameters
        2. Using the Report Viewer
      6. Scheduling Objects
        1. Scheduling Options
        2. Scheduling Reports Containing Alerts
        3. Rescheduling Existing Instances
      7. Using Discussions
        1. Modifying or Deleting Existing Messages
      8. Organizing InfoView
        1. Working with Folders and Categories
        2. Organizing Objects and Instances
        3. The My InfoView Custom Layout
    3. 22: Administering Enterprise Reporting Systems
      1. Introducing the Central Management Console
      2. Managing Users and Groups
        1. Adding, Modifying, and Deleting User Accounts
        2. Password Settings
        3. Adding Groups
        4. Placing Users in Groups
      3. Integrating BusinessObjects Enterprise with Existing Security Environments
        1. Windows NT
        2. Windows Active Directory
        3. LDAP
      4. Managing Folders, Crystal Reports, and Third-Party Objects
        1. Managing Public Folders and Subfolders
        2. Managing Personal Subfolders
        3. Adding Reports
        4. Adding Program Objects
        5. Adding Third-Party Objects and Hyperlinks
      5. Working with Categories
        1. Manipulating Categories
        2. Assigning Categories to Reports and Other Objects
      6. Controlling Access Using Rights
        1. Setting Folder and Object Rights
        2. Setting Access Rights for CMC Functions
        3. Defining Custom Access Levels
      7. BusinessObjects Enterprise Architecture
        1. Central Management Server (CMS)
        2. File Repository Servers
        3. Crystal Reports Processing Server
        4. Crystal Reports Job Server
        5. Program Job Server
        6. Destination Job Server
        7. Crystal Reports Cache Server
        8. Event Server
        9. List of Values Job Server
      8. Defining Output Destinations
      9. Creating Calendars
      10. Using Events
      11. Configuring Success/Failure/Alert Notification
        1. Success/Failure Notification
        2. Alert Notification
      12. Other General Administrative Tasks
        1. Adding Additional Licenses
        2. Setting Instance Limits
        3. Specifying Default InfoView Settings
        4. Using Instance Manager
      13. Managing Servers
        1. Viewing Server Properties and Metrics
        2. The Server Intelligence Agent and the CCM
  10. Appendix: Formula Language Reference
    1. Functions: Additional Functions
      1. ByteToText
      2. DateTimeTo2000
      3. DateTimeToDate
      4. DateTimeToSeconds
      5. DateTimeToTime
      6. DateTo2000
      7. DTSTo2000
      8. DTSToDate
      9. DTSToDateTime
      10. DTSToSeconds
      11. DTSToTimeField
      12. DTSToTimeString
      13. EventNumber
      14. ExchGetId
      15. ExchGetOrganization
      16. ExchGetPath
      17. ExchGetSite
      18. ExtractString
      19. FRAccRecTurnover
      20. FRCashFlowVsTotalDebt
      21. FRCurrentRatio
      22. FRDebtEquityRatio
      23. FRDividendYield
      24. FREarningsPerCommonShare
      25. FREquityVsTotalAssets
      26. FRGrossProfitMargin
      27. FRInterestCoverage
      28. FRInventoryTurnover
      29. FRNetProfitMargin
      30. FROperatingProfitMargin
      31. FRPriceEarningsRatio
      32. FRQuickRatio
      33. FRReturnOnCommonEquity
      34. FRReturnOnEquity
      35. FRReturnOnInvestedCapital
      36. FRReturnOnNetFixedAssets
      37. FRReturnOnTotalAssets
      38. LooksLike
      39. Now
      40. Picture
      41. Soundex
    2. Functions: Alerts
      1. AlertMessage
      2. AlertNames
      3. IsAlertEnabled
      4. IsAlertTriggered
    3. Functions: Arrays
      1. Average
      2. Count
      3. DistinctCount
      4. MakeArray
      5. Maximum
      6. Minimum
      7. PopulationStdDev
      8. PopulationVariance
      9. StdDev
      10. Sum
      11. UBound
      12. Variance
    4. Functions: Conditional Formatting
      1. Color
      2. CurrentFieldValue
      3. DefaultAttribute
    5. Functions: Date and Time
      1. CurrentDate
      2. CurrentDateTime
      3. CurrentTime
      4. Date
      5. DateAdd
      6. DateDiff
      7. DatePart
      8. DateSerial
      9. DateTime
      10. DateTimeValue
      11. DateValue
      12. Day
      13. DayOfWeek
      14. Hour
      15. IsDate
      16. IsDateTime
      17. IsTime
      18. Minute
      19. Month
      20. MonthName
      21. Second
      22. ShiftDateTime
      23. Time
      24. Timer
      25. TimeSerial
      26. TimeValue
      27. WeekdayName
      28. Year
    6. Functions: Date Ranges
      1. Aged0To30Days
      2. Aged31To60Days
      3. Aged61To90Days
      4. AllDatesFromToday
      5. AllDatesFromTomorrow
      6. AllDatesToToday
      7. AllDatesToYesterday
      8. Calendar1stHalf
      9. Calendar2ndHalf
      10. Calendar1stQtr
      11. Calendar2ndQtr
      12. Calendar3rdQtr
      13. Calendar4thQtr
      14. Last4WeeksToSun
      15. Last7Days
      16. LastFullMonth
      17. LastFullWeek
      18. LastYearMTD
      19. LastYearYTD
      20. MonthToDate
      21. Next30Days
      22. Next31To60Days
      23. Next61To90Days
      24. Next91To365Days
      25. Over90Days
      26. WeekToDateFromSun
      27. YearToDate
    7. Functions: Document Properties
      1. ContentLocale
      2. CurrentCEUserID
      3. CurrentCEUserName
      4. CurrentCEUserTimeZone
      5. DataDate
      6. DataTime
      7. DataTimeZone
      8. FileAuthor
      9. FileCreationDate
      10. FileName
      11. GroupingLevel
      12. ModificationDate
      13. ModificationTime
      14. PrintDate
      15. PrintTime
      16. PrintTimeZone
      17. ReportComments
      18. ReportTitle
      19. SelectionLocale
    8. Functions: Evaluation Time
      1. BeforeReadingRecords
      2. EvaluateAfter
      3. WhilePrintingRecords
      4. WhileReadingRecords
    9. Functions: Financial
      1. ACCRINT
      2. ACCRINTM
      3. AmorDEGRC
      4. AmorLINC
      5. CoupDayBS
      6. CoupDays
      7. CoupDaysNC
      8. CoupNCD
      9. CoupNum
      10. CoupPCD
      11. CumIPMT
      12. CumPrinc
      13. Days360
      14. DB
      15. DDB
      16. DISC
      17. DollarDE
      18. DollarFR
      19. Duration
      20. Effect
      21. FV
      22. FVSchedule
      23. IntRate
      24. IPmt
      25. IRR
      26. ISPMT
      27. MDuration
      28. MIRR
      29. Nominal
      30. NPer
      31. NPV
      32. OddFPrice
      33. OddFYield
      34. OddLPrice
      35. OddLYield
      36. Pmt
      37. PPmt
      38. Price
      39. PriceDisc
      40. PriceMat
      41. PV
      42. Rate
      43. Received
      44. SLN
      45. SYD
      46. TBillEq
      47. TBillPrice
      48. TBillYield
      49. VDB
      50. XIRR
      51. XNPV
      52. YearFrac
      53. Yield
      54. YieldDisc
      55. YieldMat
    10. Functions: Grid Value
      1. CurrentColumnIndex
      2. CurrentRowIndex
      3. CurrentSummaryIndex
      4. GetColumnGroupIndexOf
      5. GetColumnPathIndexOf
      6. GetIndexOf
      7. GetNumColumnGroups
      8. GetNumRowGroups
      9. GetNumRows
      10. GetNumSummaries
      11. GetRowGroupIndexOf
      12. GetRowPathIndexOf
      13. GetTotalValueFor
      14. GridLabelAt
      15. GridRowColumnValue
      16. GridValueAt
      17. Row Or Column Names
    11. Functions: Math
      1. Abs
      2. Atn
      3. Ceiling
      4. Cos
      5. Exp
      6. Floor
      7. Int
      8. Log
      9. MRound
      10. Pi
      11. Remainder
      12. Rnd
      13. Round
      14. RoundUp
      15. Sgn
      16. Sin
      17. Sqr
      18. Tan
      19. Truncate
    12. Functions: Print State
      1. CountHierarchicalChildren
      2. CurrentPageOrientation
      3. DrillDownGroupLevel
      4. GroupNumber
      5. GroupSelection
      6. HasValue
      7. HierarchyLevel
      8. InRepeatedGroupHeader
      9. IsNull
      10. Next (Crystal Syntax only)
      11. NextIsNull
      12. NextValue (Basic Syntax only)
      13. OnFirstRecord
      14. OnLastRecord
      15. PageNofM
      16. PageNumber
      17. Previous (Crystal Syntax only)
      18. PreviousIsNull
      19. PreviousValue (Basic Syntax only)
      20. RecordNumber
      21. RecordSelection
      22. TotalPageCount
    13. Functions: Programming Shortcuts
      1. Choose
      2. IIF
      3. Switch
    14. Functions: Ranges
      1. HasLowerBound
      2. HasUpperBound
      3. IncludesLowerBound
      4. IncludesUpperBound
    15. Functions: Strings
      1. AscW
      2. ChrW
      3. Filter
      4. InStr
      5. InStrRev
      6. Join
      7. Left
      8. Length
      9. LowerCase
      10. Mid
      11. NumericText
      12. ProperCase
      13. Replace
      14. ReplicateString
      15. Right
      16. Roman
      17. Space
      18. Split
      19. StrCmp
      20. StrReverse
      21. ToNumber
      22. ToText
      23. ToWords
      24. Trim
      25. TrimLeft
      26. TrimRight
      27. UpperCase
      28. URLDecode
      29. URLEncode
      30. Val
    16. Functions: Summary
      1. Average
      2. Correlation
      3. Count
      4. Covariance
      5. DistinctCount
      6. Maximum
      7. Median
      8. Minimum
      9. Mode
      10. NthLargest
      11. NthMostFrequent
      12. NthSmallest
      13. PercentOfAverage
      14. PercentOfCount
      15. PercentOfDistinctCount
      16. PercentOfMaximum
      17. PercentOfMinimum
      18. PercentOfSum
      19. PopulationStdDev
      20. PopulationVariance
      21. PthPercentile
      22. StdDev
      23. Sum
      24. Variance
      25. WeightedAverage
    17. Functions: Type Conversion
      1. CBool
      2. CCur
      3. CDate
      4. CDateTime
      5. CDbl
      6. CStr
      7. CTime
    18. Functions: Xcelsius
      1. ToXMLColumn
      2. ToXMLData
      3. ToXMLRow
    19. Operators: Arithmetic
      1. Add (+)
      2. Divide (/)
      3. Exponentiate (^)
      4. Integer Divide (\)
      5. Modulus
      6. Multiply (*)
      7. Negate (–)
      8. Percent (%)
      9. Subtract (–)
    20. Operators: Array
      1. In
      2. Make Array
      3. Redim
      4. Redim Preserve
      5. Subscript ([])
    21. Operators: Boolean
      1. And
      2. Eqv (Logical equivalence)
      3. Imp (Logical implication)
      4. Not
      5. Or
      6. Xor (Logical exclusion)
    22. Operators: Comparisons
      1. Equal (=)
      2. Greater or Equal (>=)
      3. Greater Than (>)
      4. Less or Equal (<=)
      5. Less Than (<)
      6. Not Equal (<>)
    23. Operators: Control Structures
      1. Do While
      2. Exit For
      3. Exit While
      4. For
      5. If Then Else
      6. Option Loop
      7. Select Case
      8. While Do
    24. Operators: Conversion
      1. Currency ($)
    25. Operators: Other
      1. Assignment (:=)
      2. Comment (//)
      3. Date-time literal (#)
      4. Parentheses
    26. Operators: Pattern
      1. Like
      2. StartsWith
    27. Operators: Ranges
      1. Both End Points Excluded Range
      2. In Range
      3. Left End Point Excluded Range
      4. Make Range
      5. Right End Point Excluded Range
      6. UpFrom
      7. Up From But Not Including
      8. UpTo
      9. Up To But Not Including
    28. Operators: Scope
      1. Global
      2. Local
      3. Shared
    29. Operators: Strings
      1. Concatenate (& or +)
      2. In String
      3. Insert Empty String (“”)
      4. Subscript []
    30. Operators: Variable Declarations
      1. BooleanVar
      2. CurrencyVar
      3. DateTimeVar
      4. DateVar
      5. NumberVar
      6. StringVar
      7. TimeVar
  11. Index