| Chapter One - Configuring an
ODBC Data Source
Chapter Two - Systemizing the Actuate Common Interface
Setup Options
Toolbar and Palette Setup
Using Toolbars and Palettes
Chapter Three - Creating Reports, The Building Blocks
Report Wizard
Actuate Design Interface
Component Palette & Subpalettes
Structure Palette
Data Palette
Controls Palette
Pages Palette
Page Layout Pane
Page Flows
Establishing the Page Layout
Query Editor
Adding Data Aware Objects to the Design
The Field List
Create your Own Report
Chapter Four - Sections, Frames, and Groups
Frames
Headers
Nesting Frames
Before Section
Page Header Section
Content Section
Grouping Data
Nested Groupings
Scratch Pad
Chapter Five - Variables, Properties, and Methods
Variables
Variable Scope
Defining a Global Variable, .bas Files
Examining Properties
Methods and Properties
Control Objects by Data type
Suppressing Duplicate Column Values
Chapter Six - Building an Object Library
Why Object Libraries - Reuse and Inheritance
Building a High Level Object Library
Library Organizer
Adding Objects to the Library
Landscape Page Objects for Your Library
Subclassed Objects
Subclassing Objects from Your Top-level Library
Modular Report Development
Page Header Library Elements
Before Frame Library Objects
Content Section Library Elements
Reuse, Uniformity, Inheritance
Constructing an Object Library Step by Step
Create a New Library
Creating Objects Library: Design the Object in the Design
Editor
Set the Object's Properties and Methods
Creating a Specialized Reusable Object
Publish the Object to the Library
Copy the Library Element Back to the Application
Scope of an Object
Design Library for Your Organization
Chapter Seven - Parameters - User Input
Ad Hoc Parameters
Query by Example (QBE)
Adjusting the Visual Design - Dynamically & Parameter
Driven
AcConditionalSection
Creating the Visual Elements
Coding the Finish Method to Handle Dynamic Data Globals Browser
and NewPageHeader Method
Creating a Parameterized Connection Object
Parameter - Advanced Tab
Chapter Eight - Data
SQL Query Editor
Computed Fields
Conditions Tab
Order By Tab
ObtainSelectStatement Method
More on Debugging
Using the Frame's Finish Method to Compare Objects
Object Variables
Variables Browser
Textual Query Editor
Expression Builder
Aggregate Expressions
How Actuate Works with Data
Getting Data From/Inputting Data to Text Files
Getting .txt File Input for an Actuate Report
AFC Symbols / AcDataSource Class
Using Actuate Visual Basic to Open and Close a Text File
Outputting a Text File
Actuate Search Mechanisms
Exporting the Search
How Actuate Handles Data
Multiple Input Reports / Multiple Input Filters
Creating a Combined Data RowSort Filters
Multiple Databases, Many-to-one RelationshipSequential Reports
Nested Reports
Using a Driving Key
Parallel Reports
Labels page
Exercise page
Parallel - Relating the Columns: Subpages
Updating Tables
Chapter Nine - Hyperlinks and Drill-down Reports
Drill-down Reports
Source Object
LinkExp Property
Hyperlink Syntax
An Object's Scope
Identifying a Separate .roi (Report) in Hyperlink Syntax
Generating the Target Report on the Fly
The SetLinkTo Method / Passing Multiple Parameters
OnRow() Method/GetValue() Function
Chapter Ten - Graphs
Relating Data to a Graph
Graph Placement: the Role of Aggregates
Expressions Property (data links)
Graph Label-related Properties
ValuesColorList Property (e.g. colors of a bar graph)
Graph Legends (SeriesKey & SeriesLabel)
Advanced Chart Option
Chapter Eleven - Standard Reporting, OLAP, Crosstab Reports
Models & Products
Definitions (Data Warehousing, OLAP, MOLAP, ROLAP)
Standard Reporting
Ad Hoc Reporting
Ad hoc analysis of standard reporting (e.Analysis)
Definitions (Data Warehousing, OLAP, MOLAP, ROLAP)
Crosstab Reports
Proprietary ad hoc tools (Business Intelligence)
Chapter Twelve- Page Level Security
Setting Users & Roles on the Actuate Encyclopedia
Creating Roles
Assigning Users to a Role
Giving Users & Roles Access to a Report's Pages - Coding
the Design
GrantExp Property
CascadeSecurity Property
Using Live Data & Roles to set GrantExp to a particular
user or role
Setting CascadeSecurity to False
Setting Security on the Report Encyclopedia
Secure Read
Virtual Roles
SetSecurity Method
The Security Simulator
Visible vs. Actual Page Number
Page ACL/User ACL (Access Control List)
Chapter Thirteen - Configuration Files
Sample Template
Refreshing the Report's Configuration File
Runtime Option
Appendix A - Stored Procedures
Part I - Stored Procedures & Single Select Statements
Using the Actuate SP Icon
Placing the Stored Procedure into Your Report
Pitfalls & Tips in Stored Procedure Integration
Privileges and Other Complications
Stored Procedures & Oracle
Cursor Variables & Oracle
Part II - Stored Procedures & Multiple Select Statements
Open Cursor / Bind Column
Appendix B - Actuate & the Web
The Actuate Encyclopedia & the Web
Folder Level Security - Web View
Parameters & DHTML New Request Web Page
Browser Scripting Controls
How it Works - Dynamic lists/dynamic links
Alternative Text Property
BrowserCode Property, BrowserCode & BuildFromRow Methods
Coding Browser Scripting Controls
VISUAL BASIC FOR COBOL PROGRAMMERS (1 DAY OPTIONAL)
I. Variable Handling
II. Conditional Statements & Loops
III.Useful Functions
IV. Formatting Data
V. Date Handling including DatePart & DateDiff Functions
VI. Error Handling with Goto
VII. Arrays
VIII.Object-Orientated Variables & Techniques
|
