Tag Archives: amsterdam

All trainings in Brussels, Training Development

Training ASP / Advanced – 2 days

Leave a comment

Class overview :

In this advanced ASP training course, students will learn to use sophisticated programming strategies and advanced features to add polish, speed and efficiency to Active Server Pages Web applications. In this ASP training course, students will work more thoroughly with ASP components for Web-to-database integration and use the server’s file system to add features and functionality to a website.

Class goals :

Learn to implement advanced drill-downs
Learn to debug ASP code
Learn to work with stored procedures
Learn to use batch updating
Learn to work with 3rd-party vendor components
Learn to work with the file system of the server

Content of Training ASP / Advanced

Class Outline

  1. File Conventions
    1. Connection Pooling
    2. Dynamic Connection Strings
    3. Default METHOD and ACTION Values
  2. Advanced Data Drill-Downs
    1. Passing Data via the Query String
    2. Using Drill-Downs to Reformat Data
    3. Creating Sortable Tables
  3. Displaying Variables
    1. Creating an Include to Display Variable Values for Debugging
  4. Displaying a Portion of a Recordset
    1. Displaying the Next n Records
    2. How the Process Works
  5. Password Protection with Session Variables
    1. Adding Password Protection to Pages
  6. Stored Procedures in ASP
    1. Creating a Stored Procedure in the Database
    2. Advantage of Stored Procedures
    3. Calling a Stored Procedure
    4. Using Stored Procedures to Insert and Update Data
  7. Working with the File System in ASP
    1. The FileSystemObject
    2. Creating or Opening a Text File
    3. Methods of the TextStream Object
    4. Storing Text to a File
    5. The File Object
    6. The Folder Object
    7. Working with Files and Directories
  8. Processing File Uploads
    1. Obtaining a Component for Processing File Uploads
    2. The AspUpload Component
    3. Building an HTML Form that Supports File Uploads
    4. Processing the File on the Server with AspUpload
    5. Processing Files and Entered Text
    6. SetMaxSize
    7. Manipulating Files via AspUpload
    8. Creating an New Directory
    9. Restricting Your Upload to Certain File Extensions
    10. Building a Resume Submission Interface
  9. Batch Updating
    1. Opening a Recordset for Batch Updating
    2. Editing the Records Row by Row
    3. Updating the Batch
    4. Benefits of Batches
    5. Some Useful VBScript Functions
  10. Using rs.Update Instead of INSERT
    1. rs.Update
  11. Form Validation with Server-Side JScript
    1. Server-Side Form Validation with JScript
  12. Transactions in ASP
    1. Transactions
    2. Handling Errors
    3. Catching Database Errors
  13. Creating Message Boards
    1. The HTML Files
    2. The Database
    3. The Interface
  14. Regular Expressions
    1. Creating and Executing Regular Expressions with exec()
    2. Special Characters for Pattern Matching
    3. Escape Sequences for Special Characters
    4. Specifying Ranges in Patterns
    5. Matching a Specified Number of Occurrences
    6. Character-Range Escape Sequences
    7. Matching at the Beginning or End of a String with ^ and $
ASP / Advanced
Training ASP / Advanced

Onze voordelen :

  • Type of training: Inter-company, intra-company and individual
  • 100% flexible & personalised training : You choose the place, the dates and the training program
  • Offer request : Response within 24 hours
  • 50% discount for SME’s from Brussels-Capital Region
  • Free parking, lunch & drinks
  • Free use of our Digital Competence Centre: Manuals, courses, exercises, …
All trainings in Brussels, Training Development

Training Active Server Pages / Introduction – 3 days

Leave a comment

Class overview :

In this ASP training course, students will learn to build full-featured, database-driven Web sites. This introductory course for new programmers lays out the basics of server-side Web programming with an introduction to classic programming structures and good programming practices. Students will apply these programming skills to the development of a fully functional data-driven website with ASP written in VBScript.

Class goals :

Learn how ASP works
Learn the basic syntax of ASP
Learn to create dynamic interactive pages with ASP
Learn to work with VBScript control structures
Learn to use VBScript built-in functions
Learn to work with ASP’s built-in objects
Learn to validate forms with ASP
Learn to write functions and subroutines in ASP
Learn to work with ASP Session, Application, and Cookie objects
Learn to connect to a database with ASP
Learn to send email with ASP

Content of Training Active Server Pages / Introduction

Class Outline

  1. Active Server Pages: A Web Server-Side Technology
    1. Client-side vs. Server-side Web Technologies
    2. The Web’s Client-Server Relationship
    3. Which Web Servers Support Active Server Pages?
  2. Writing ASP Pages
    1. ASP Code in an HTML Context
    2. ASP Code is « Language Neutral »
    3. VBScript in ASP
    4. ASP Scriptlets
    5. VBScript Strings
    6. An Abbreviation for Response.Write
    7. Developing ASPs
    8. ASP Directives, Statements, Expressions and Comments
    9. VBScript Flexibility and Good Programming Practices
  3. Processing Data from Online Forms
    1. The FORM Tag and its Attributes
    2. ASP Objects
    3. The Request and Response Objects
    4. Scalar Variables in ASP
    5. Customizing a Page for the Visitor
  4. Conditional Constructs – IF Statements
    1. Comparison Operators in VBScript
    2. Adding an Else Clause
    3. Implementing an IF…ELSE…END IF Conditional
    4. Adding One or More ELSEIF Clauses
    5. The Logical AND and OR
    6. Combining the Form and its Processing Code in One ASP File
  5. Working with Cookies
    1. Setting and Retrieving a Cookie
    2. Cookie Properties
    3. Expiring a Cookie
  6. Maintaining State with the Session and Application Objects
    1. The Session Object
      1. Storing and Retrieving Values in the Session Object
      2. Session Properties and Methods
    2. The Application Object
  7. Working with Components
    1. Instantiating Component Objects
    2. Sending Email with CDONTS
  8. Writing to a Text File
    1. Writing to a Tab-Delimited Text File
  9. Loop Structures in ASP
    1. For…Next Loops
    2. Populating Select Lists
    3. Collections in ASP
    4. For Each…Next Loops and Collections
  10. ASP-to-Database Integration with ADO
    1. Database Commands with SQL
    2. The ADO Object Model
    3. Retrieving a Record from the Database with ASP
    4. The Connection Object’s Execute Method
    5. Building an Interface for Updating Client Records
  11. VBScript Subroutines and Functions
    1. Subroutines
    2. Functions
  12. Drilling Down and the Query String
    1. Building the Query String into a Link
    2. Generating Drill Down Links Dynamically
    3. Building an Interface for Deleting a Record
Active Server Pages / Introduction
Training Active Server Pages / Introduction

Onze voordelen :

  • Type of training: Inter-company, intra-company and individual
  • 100% flexible & personalised training : You choose the place, the dates and the training program
  • Offer request : Response within 24 hours
  • 50% discount for SME’s from Brussels-Capital Region
  • Free parking, lunch & drinks
  • Free use of our Digital Competence Centre: Manuals, courses, exercises, …
All trainings in Brussels, Training Development

Training Ajax with ColdFusion – 3 days

Leave a comment

Class overview :

In this Ajax training course, students learn to make calls to the server with JavaScript and to manipulate XML content returned from the server. Ajax opens the door to creating sophisticated web-based applications with much more of the logic (and therefore code) is handled on the client. While Ajax allows for more dynamic and responsive applications, it changes the traditional role of JavaScript dramatically and forces developers to rethink how they write and manage JavaScript code.

Class goals :

Learn how Ajax works.
Learn to write cross-browser Ajax code.
Learn to use Ajax to make a call to the server without a page refresh.
Learn to modify content blocks on a page without refreshing the whole page.
Learn to use server-side form validation with Ajax.
Learn to move elements around the page with Dynamic HTML.
Learn to show and hide elements.
Learn to manipulate XML documents with JavaScript using the DOM.
Learn to manipulate XML documents with JavaScript using XSLT.
Learn to program in JavaScript using Object-Oriented techniques.
Learn to work with various JavaScript/Ajax libraries, such as Prototype, Scriptaculous, and Sarissa.

Content of Training Ajax with ColdFusion

Class Outline

  1. Ajax Basics
    1. The Purpose of Ajax
      1. Traditional Web Application
      2. An Ajax Web Application
    2. The XMLHttpRequest Object
      1. Creating an XMLHttpRequest Object
      2. Using an XMLHttpRequest Object
      3. Handling the Response
    3. Conclusion
  2. Ajax Frameworks
    1. The Purpose of Frameworks
      1. Choosing a Framework
    2. Dojo
      1. Downloading Dojo
      2. Using Dojo for Ajax
    3. Prototype
      1. Downloading Prototype
      2. Using Prototype for Ajax
    4. Other Popular Frameworks
      1. Direct Web Remoting (DWR)
      2. AjaxAnywhere
      3. Simple Ajax (SAJAX)
      4. Sarissa
      5. Other Frameworks
    5. Conclusion
  3. The HTML Document Object Model
    1. Accessing Nodes
      1. Accessing Element Nodes
      2. Accessing Attribute Nodes
      3. getAttribute
      4. attributes[]
      5. Accessing Nodes by Type, Name or Value
      6. Accessing Nodes by Class Name
    2. Removing Nodes from the DOM
      1. DOM Differences: The Whitespace Problem
    3. Creating New Nodes
    4. Conclusion
  4. XML and Ajax
    1. Creating a DOM Document with JavaScript
    2. Accessing, Creating and Modifying XML Nodes
      1. Creating an AddChild() Function
    3. Receiving XML Responses
    4. Conclusion
  5. Ajax Applications
    1. Login Form
    2. Quick Lookup Form
    3. Preloaded Data
      1. Ajax Slideshow
      2. Navigable Tables
    4. Conclusion
  6. OO JavaScript and Refactoring Ajax
    1. Illustrating the Problem
    2. Object-Oriented JavaScript
      1. JavaScript Classes
      2. Prototypes
      3. Extending Built-in Objects
    3. Refactoring the Ajax Request Code
    4. Conclusion
  7. JavaScript Object Notation (JSON)
    1. Object Literals
      1. Arrays
      2. Objects
      3. Arrays in Objects
      4. Objects in Arrays
    2. JSON
      1. JSON Syntax
      2. JSON Parsers
        1. CFJSON
      3. JSON Advantages and Disadvantages
    3. Conclusion
  8. XSLT Transformations with JavaScript
    1. XSLT
      1. Basic XSLT
    2. XSLT in the Browser
      1. XSLT in Internet Explorer
      2. XSLT in Mozilla
    3. Sarissa
      1. Advantages and Disadvantages of XSLT in Ajax Applications
    4. Conclusion
  9. Drag and Drop
    1. Drag and Drop Basics
    2. script.aculo.us
      1. Draggables
      2. Droppables
      3. A More Interesting Example
    3. Conclusion
  10. More Ajax Applications
    1. Inline Editing
    2. Detailed Information on Demand
    3. Autologout
    4. Autocompletion
    5. Conclusion
Ajax with ColdFusion
Training Ajax with ColdFusion

Onze voordelen :

  • Type of training: Inter-company, intra-company and individual
  • 100% flexible & personalised training : You choose the place, the dates and the training program
  • Offer request : Response within 24 hours
  • 50% discount for SME’s from Brussels-Capital Region
  • Free parking, lunch & drinks
  • Free use of our Digital Competence Centre: Manuals, courses, exercises, …
All trainings in Brussels, Training Development

Training Ajax with PHP – 3 days

Leave a comment

Class overview :

In this Ajax training course, students learn to make calls to the server with JavaScript and to manipulate XML content returned from the server. Ajax opens the door to creating sophisticated web-based applications with much more of the logic (and therefore code) is handled on the client.

Class goals :

Learn how Ajax works.
Learn to write cross-browser Ajax code.
Learn to use Ajax to make a call to the server without a page refresh.
Learn to modify content blocks on a page without refreshing the whole page.
Learn to use server-side form validation with Ajax.
Learn to move elements around the page with Dynamic HTML.
Learn to show and hide elements.
Learn to manipulate XML documents with JavaScript using the DOM.
Learn to manipulate XML documents with JavaScript using XSLT.
Learn to program in JavaScript using Object-Oriented techniques.
Learn to work with various JavaScript/Ajax libraries, such as Prototype, Scriptaculous, and Sarissa.

Content of Training Ajax with PHP

Class Outline

  1. Ajax Basics
    1. The Purpose of Ajax
      1. Traditional Web Application
      2. An Ajax Web Application
    2. The XMLHttpRequest Object
      1. Creating an XMLHttpRequest Object
      2. Using an XMLHttpRequest Object
      3. Handling the Response
    3. Conclusion
  2. Ajax Frameworks
    1. The Purpose of Frameworks
      1. Choosing a Framework
    2. Dojo
      1. Downloading Dojo
      2. Using Dojo for Ajax
    3. Prototype
      1. Downloading Prototype
      2. Using Prototype for Ajax
    4. Other Popular Frameworks
      1. Direct Web Remoting (DWR)
      2. AjaxAnywhere
      3. Simple Ajax (SAJAX)
      4. Sarissa
      5. Other Frameworks
    5. Conclusion
  3. The HTML Document Object Model
    1. Accessing Nodes
      1. Accessing Element Nodes
      2. Accessing Attribute Nodes
      3. getAttribute
      4. attributes[]
      5. Accessing Nodes by Type, Name or Value
      6. Accessing Nodes by Class Name
    2. Removing Nodes from the DOM
      1. DOM Differences: The Whitespace Problem
    3. Creating New Nodes
    4. Conclusion
  4. XML and Ajax
    1. Creating a DOM Document with JavaScript
    2. Accessing, Creating and Modifying XML Nodes
      1. Creating an AddChild() Function
    3. Receiving XML Responses
    4. Conclusion
  5. Ajax Applications
    1. Login Form
    2. Quick Lookup Form
    3. Preloaded Data
      1. Ajax Slideshow
      2. Navigable Tables
    4. Conclusion
  6. OO JavaScript and Refactoring Ajax
    1. Illustrating the Problem
    2. Object-Oriented JavaScript
      1. JavaScript Classes
      2. Prototypes
      3. Extending Built-in Objects
    3. Refactoring the Ajax Request Code
    4. Conclusion
  7. JavaScript Object Notation (JSON)
    1. Object Literals
      1. Arrays
      2. Objects
      3. Arrays in Objects
      4. Objects in Arrays
    2. JSON
      1. JSON Syntax
      2. JSON Parsers
        1. PHP JSON Extension (added in PHP 5.2)
        2. PEAR JSON
        3. ZEND JSON
      3. JSON Advantages and Disadvantages
    3. Conclusion
  8. XSLT Transformations with JavaScript
    1. XSLT
      1. Basic XSLT
    2. XSLT in the Browser
      1. XSLT in Internet Explorer
      2. XSLT in Mozilla
    3. Sarissa
      1. Advantages and Disadvantages of XSLT in Ajax Applications
    4. Conclusion
  9. Drag and Drop
    1. Drag and Drop Basics
    2. script.aculo.us
      1. Draggables
      2. Droppables
      3. A More Interesting Example
    3. Conclusion
  10. More Ajax Applications
    1. Inline Editing
    2. Detailed Information on Demand
    3. Autologout
    4. Autocompletion
    5. Conclusion
Ajax with PHP
Training Ajax with PHP

Onze voordelen :

  • Type of training: Inter-company, intra-company and individual
  • 100% flexible & personalised training : You choose the place, the dates and the training program
  • Offer request : Response within 24 hours
  • 50% discount for SME’s from Brussels-Capital Region
  • Free parking, lunch & drinks
  • Free use of our Digital Competence Centre: Manuals, courses, exercises, …
All trainings in Brussels, Training Development, Training Programming, Training Webdesign

Training Perl Programming and CGI Scripting – 5 days

Leave a comment

Class overview :

This hands on Perl programming course provides a thorough introduction to the Perl programming language, teaching attendees how to develop and maintain portable scripts useful for system management, data manipulation, and Web CGI programming.

Class goals :

Extensive hands on exercises provide practice in report creation, pattern matching, string manipulation, file I/O, command line processing, and debugging. Students are shown how to extend Perl’s basic functionality with packages and loadable modules. The final day encompasses CGI scripting with Perl as well as database access using the DBI module. Attendees are shown how to validate form data, how to perform robust database access, and how to generate HTML output in order to create a dynamic web site.

Content of Perl Programming and CGI Scripting

  • Perl Fundamentals
  • Running Perl on UNIX and Windows
  • Using Scalar Variables
  • Using Arrays
  • Operators, Expressions and Precedence
  • Arithmetic and String Operators
  • Relational and Logical Operators
  • Using the Conditional Operator
  • Understanding File Test Functions
  • Conditional Constructs
  • Looping Constructs
  • Using Subroutines
  • Global vs. Local Variables and Scoping
  • Debugger Concepts
  • Using Perl Script Arguments
  • Using Regular Expressions
  • Reading and Writing Files
  • Understanding Scope
  • Understanding Modules
  • Writing to Files and Using Multiple Named Formats
  • The Common Gateway Interface
  • Configuring a Web Server for CGI
  • The Apache httpd.conf File
  • Aliasing CGI-Enabled Directories in Apache
  • Relationship Between HTML and CGI
  • The CGI Output Stream
  • Specifying MIME Types
  • Printing Dynamic Content
  • Working with Form Data
  • Using the Perl CGI.pm Module
  • Creating Forms with CGI.pm
  • Form Processing with CGI.pm
  • Setting Cookies
  • Using Relational Databases with Perl CGI
  • Connecting to a Database
  • Procedural and Object Oriented Programming
Perl Programming and CGI Scripting
Training Perl Programming and CGI Scripting

Onze voordelen :

  • Type of training: Inter-company, intra-company and individual
  • 100% flexible & personalised training : You choose the place, the dates and the training program
  • Offer request : Response within 24 hours
  • 50% discount for SME’s from Brussels-Capital Region
  • Free parking, lunch & drinks
  • Free use of our Digital Competence Centre: Manuals, courses, exercises, …

This hands on Perl programming course provides a thorough introduction to the Perl programming language, teaching attendees how to develop and maintain portable scripts useful for system management, data manipulation, and Web CGI programming.

All trainings in Brussels, Training Development

Training Adobe ActionScript 3 Advanced Techniques – 3 days

Leave a comment

Class overview :

This 3 day advanced ActionScript course is for people who want to push their Actionscript 3 skills further and learn advanced techniques in order to create and control effects with MovieClips, bitmaps, colour, audio, video, and 3D assets.

Class goals :

Additionally you we will cover some great open source class libraries that will help you in creating your effects and flash sites, and generally learn to take your ActionScript 3 skills to the next level.

Content of Adobe ActionScript 3 Advanced Techniques

Drawing

  • Drawing API
  • Triangles (and UVT)
  • Bitmap fills

3D transformations

  • rotationX/Y/Z transformations
  • scaleX/Y/Z transformations
  • x/y/z translations
  • Simple 3D drawing

Collision Detection

  • Hit tests
  • Using Bitmaps for detection

Tweening

  • Tween class
  • Applying tweens
  • Creating effects with tweens
  • Other tweening libraries

Transitions and the Transition Manager

  • Blinds
  • Fade
  • Fly
  • Iris
  • Squeeze
  • Wipe
  • Others

Colour

  • Manipulating colours with AS3
  • ColorTransform class

Transformations

  • Matrix class
  • Matrix3D class
  • Transform
  • Others

Video Effects

  • Bitmaps
  • Cameras
  • Movies

Sound effects

  • Loading sounds
  • Controlling sounds
  • Visualisation – waveforms and frequencies
  • Microphones

Image Effects

  • Bitmaps and BitmapData
  • Filters and Blend modes
  • PerlinNoise

Open source Classes

  • Papervision3D
  • Tweener
  • TweenMax
  • Minimal Components
  • Others

Open source frameworks

  • Gaia

Augmented Reality

  • FLARToolkit
  • Adding Papervision3D

Object Orientated Programming

  • Creating your own class
  • Creating methods
  • Creating getters/setters
  • Using your custom class
  • Creating Document classes

Flash and Flash Builder (Flex Builder)

  • Importing Flash work into Flash Builder
  • Setting up your classes in Flash Builder
  • Embedding Flash work as assets in your classes
  • Using Flash Builder with php and mysql

Components and Data

  • Components
    • Button
    • Checkbox
    • ColourPicker
    • Combobox
    • Datagrid
    • etc

Working with data

  • Database Integration
    • Setting up a server and database
    • Testing server/flash/db integration
    • Ways to connect Flash and data – AMFPHP
  • XML
  • DataProvider
Adobe ActionScript 3 Advanced Techniques
Training Adobe ActionScript 3 Advanced Techniques

Onze voordelen :

  • Type of training: Inter-company, intra-company and individual
  • 100% flexible & personalised training : You choose the place, the dates and the training program
  • Offer request : Response within 24 hours
  • 50% discount for SME’s from Brussels-Capital Region
  • Free parking, lunch & drinks
  • Free use of our Digital Competence Centre: Manuals, courses, exercises, …
All trainings in Brussels, Training Programming

Training Web 2.0 Programming using CherryPy and TurboGears – 5 days

Leave a comment

Class overview :

This course will cover the installation, configuration, development and deployment of Web Sites using the TurboGears framework.

Class goals :

This course will cover the installation, configuration, development and deployment of Web Sites using the TurboGears framework.

Content of Web 2.0 Programming using CherryPy and TurboGears

Overview of Web 2.0 Python and Frameworks

The role of AJAX in Web 2.0

Overview, and getting up to speed with classical web technologies – using a standard database driven web site example

  • XML
  • HTML
  • HTTP
  • SQL
  • Java Script
  • Python CGI

Introduction to Web Application Frameworks, CherryPy and TurboGears

  • Model View Controller (MVC) paradigm – which underlies most Web Develoment Frameworks
  • Features supported by most web development frameworks
  • History of TurboGears
  • Core TurboGears components – an overview
  • MVC architecture in TurboGears
  • Overview,by example, of application creation and deployment using TurboGears

TurboGears components in greater depth

  • CherryPy – and TurboGears controllers
  • SQL Objects – Object Relational Mapping
  • Kid template engine and MochiKit – processing and creating views
  • TurboGears Widgets

Case studies

  • Creating a Blog site
  • Managing user identity and tracking site visitors
  • Creating extended widgets
  • MVC design and implementation – team project
  • Adding RSS feed capabilities to a web site

Client side issues

  • Pythonic JavaScripting with MochiKit
  • Flash based interfaces and TurboGears
Web 2.0 Programming using CherryPy and TurboGears
Training Web 2.0 Programming using CherryPy and TurboGears

Onze voordelen :

  • Type of training: Inter-company, intra-company and individual
  • 100% flexible & personalised training : You choose the place, the dates and the training program
  • Offer request : Response within 24 hours
  • 50% discount for SME’s from Brussels-Capital Region
  • Free parking, lunch & drinks
  • Free use of our Digital Competence Centre: Manuals, courses, exercises, …
All trainings in Brussels, Training Development

Training Crystal Reports 2008 Level 2 – 2 days

Leave a comment

Class overview :

Until now, you have used Crystal Reports to build and modify reports. You want to use the advanced functionality of Crystal Reports to generate reports in the format you desire. In this course, you will create complex reports and data sources using Crystal Reports’ tools. You will not only create more sophisticated reports including subreports and cross-tabs, but you will also increase the speed and efficiency of your reports by using SQL queries.

Class goals :

After completing this course, students should be able to:

  • Create automatic and manual running totals
  • Work with cross-tab reports
  • Add subreports
  • Create drill-downs in a report
  • Use SQL statements in report processing
  • Create complex formulas
  • Add charts to reports
  • Enhance report functionality

Content of

Lesson 1: Creating Running Totals

Lesson 2: Working with Cross-Tabs

Lesson 3: Adding Subreports

Lesson 4: Creating Drill-Downs in a Report

Lesson 5: Using SQL Statements in Report Processing

Lesson 6: Creating Complex Formulas

Lesson 7: Adding Charts to Reports

Lesson 8: Enhancing Report Functionality

  • Appendix A: Managing Reports
  • Appendix B: Processing Data on the Server
  • Appendix C: Detecting and Fixing Problems
Crystal Reports 2008 Level 2
Training Crystal Reports 2008 Level 2

Onze voordelen :

  • Type of training: Inter-company, intra-company and individual
  • 100% flexible & personalised training : You choose the place, the dates and the training program
  • Offer request : Response within 24 hours
  • 50% discount for SME’s from Brussels-Capital Region
  • Free parking, lunch & drinks
  • Free use of our Digital Competence Centre: Manuals, courses, exercises, …
All trainings in Brussels, Training Development

Training Crystal Reports 2008 Level 1 – 2 days

Leave a comment

Class overview :

Organisations use reporting tools to access data sources and generate customised reports. Crystal Reports 2008 enhances report building and report processing techniques with a slew of features that add value to your presentation. In this course, you will create a basic report by connecting to a database and modifying its presentation.

Class goals :

After completing this course, students should be able to:

  • Explore the Crystal Reports interface
  • Create a basic report and modify it
  • Use formulas for filtering data
  • Build a parameterized report
  • Group report data
  • Enhance a report
  • Create a report using data sourced from an Excel database
  • Distribute data

Content of Crystal Reports 2008 Level 1

Lesson 1: Exploring the Crystal Reports 2008 Interface

Lesson 2: Working with Reports

Lesson 3: Using Formulas in Reports

Lesson 4: Building Parameterized Reports

Lesson 5: Grouping Report Data

Lesson 6: Enhancing a Report

Lesson 7: Creating a Report from Excel Data

Lesson 8: Distributing Data

  • Appendix A: Up and Configuring Data Sources
  • Appendix B: Using Report Processing Techniques
  • Appendix C: Using Functions in Formulas
Crystal Reports 2008 Level 1
Training Crystal Reports 2008 Level 1

Onze voordelen :

  • Type of training: Inter-company, intra-company and individual
  • 100% flexible & personalised training : You choose the place, the dates and the training program
  • Offer request : Response within 24 hours
  • 50% discount for SME’s from Brussels-Capital Region
  • Free parking, lunch & drinks
  • Free use of our Digital Competence Centre: Manuals, courses, exercises, …
All trainings in Brussels, Training Development

Training Crystal Reports Version 11 Advanced – 2 days

Leave a comment

Class overview :

Now that you have completed the first course, or are familiar with the basics of building and modifying reports, you’re ready to move ahead to create complex reports and data sources using Crystal Reports’ tools. In this course, you’ll not only learn how to create more sophisticated reports including subreports and cross-tabs, but you’ll also learn how to increase the speed and efficiency of your reports by using SQL queries.

Class goals :

After completing this course, students should be able to:

  • Create running totals in a report
  • Build cross-tabs in your report
  • Add subreports to a report
  • Design a report that uses a drill-down
  • Improve processing speed in your reports
  • Chart single and multiple data series
  • Report from Excel data
  • Implement report prompts
  • Enhance report functionality

Content of Crystal Reports Version 11 Advanced

Creating Running Totals

  • Create a Running Total Field
  • Modify a Running Total Field
  • Create a Manual Running Total on Detail Data
  • Create a Manual Running Total on Summary Data

Building Cross-tabs in Your Report

  • Create a Cross-tab
  • Create a Specified Group Order
  • Filter a Cross-tab by Group
  • Change the Cross-tab Format
  • Conditionally Format Rows and Columns
  • Keep Groups Together

Adding Subreports

  • Insert a Subreport
  • Link a Subreport to a Primary Report
  • Edit a Subreport’s Structure
  • Format a Subreport Using the Format Editor
  • Share Variables Between Subreports and Primary Reports
  • Create an On-demand Subreport

Creating Drill-downs

  • Create a Drill-down
  • Create Separate Headings for Drill-down Data

Enhancing Report Processing by Writing SQL Statements

  • Create a Report Using SQL Queries
  • Summarize Report Data Using SQL Aggregate Functions
  • Create Joins Using SQL
  • Create Subqueries
  • Create a SQL Expression Field

Charting Data

  • Create a Bar Chart
  • Modify a Chart
  • Format a Chart
  • Create a Chart Template
  • Create a Top N Chart
  • Create a Cross-tab Chart

Reporting on Excel Data with Crystal Reports

  • Create a Report Based on Excel Data
  • Modify a Report Generated from Excel Data
  • Update Data in a Report Based on Excel Data

Working with Prompts

  • Create a Static Prompt
  • Create a Dynamic Prompt

Enhancing Report Functionality

  • Group Data Hierarchically
  • Create a Dynamic Image
  • Create a Report Alert
  • Create a Geographic Map
Crystal Reports Version 11 Advanced
Training Crystal Reports Version 11 Advanced

Onze voordelen :

  • Type of training: Inter-company, intra-company and individual
  • 100% flexible & personalised training : You choose the place, the dates and the training program
  • Offer request : Response within 24 hours
  • 50% discount for SME’s from Brussels-Capital Region
  • Free parking, lunch & drinks
  • Free use of our Digital Competence Centre: Manuals, courses, exercises, …