e.Report Designer Professional (Singapore)

Course Description

Course Length:                       
4 Days

Who Should Attend?                                                                  
Developers, Database Administrators, Project Managers

Prerequisites:                                                                                    Experience with Microsoft SQL, and a familiarity with object-oriented programming concepts.  Visual Basic programming experience is beneficial, but not required

Course Description:

This intensive course develops the skills needed to build and maintain a sophisticated corporate reporting system using Actuate’s e.Report Designer Professional.  Students learn Actuate’s reporting system theory, and then apply this knowledge to capture and present key data in an effective, concise and timely manner.
In a lab environment, students develop complex Actuate reports that require the customization of Actuate Basic code.  Although not required, it is strongly recommended that attendees have some level of programming experience with object-oriented languages, SQL and/or Visual Basic. 

Please note that Business Users should attend the Fundamentals of e.Report Design course, which teaches general reporting skills that are relevant to both the e.Report Designer and e.Report Designer Professional products.

Each student receives a comprehensive course manual, which functions both as a workbook during class, and as a detailed reference guide once the class is completed.

Topics:

  • Actuate Reporting System product overview and demonstration
  • Designing, building and viewing simple reports
  • Connecting to databases and custom data sources
  • Working with a report’s page layout
  • Creating SQL Queries with the Actuate Query Editors
  • Understanding the stored procedure builder
  • Understanding aggregate functions
  • Understanding report groups -- sections and subsections
  • Building sequential and parallel reports
  • Using Actuate’s dynamic text control and page sizing features
  • Creating Crosstab Reports
  • Working with Charts
  • Creating and using hyperlinks in Actuate reports
  • Designing report parameters
  • Understanding libraries and working with components
  • Understanding commonly-used Actuate Foundation Class methods
  • Debugging a report
  • Designing reports using Page-Level Security
  • Creating Information Objects for use with Actuate Query
  • Developing a report for the web
  • Designing browser scripting controls
  • Designing Actuate XML reports
  • Using and customizing configuration files