It Performs - Business Intelligence Specialists

IT-Performs - Business Intelligence Specialists

Follow us on Facebook See us on YouTube See us on GuruOnline.tv Connect with us on LinkedIn Follow us on Twitter Email this Print this

Crystal Reports Advanced Workshop

Workshop Description

trainingSince you've probably completed the first workshop, 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 like subreports and cross-tabs, you'll also learn how to increase the speed and efficiency of your reports by using SQL queries and dictionaries.

Topics Covered

Lesson 1: Report Creation Review

  • Review learning from the introductory session

Lesson 2: Using the Repository

  • Using the repository
  • Updating repository objects

Lesson 3: Formulas

  • String formulas
  • Nested functions
  • Numbered functions
  • Date and time functions
  • If-then-else statements
  • Select statements

Lesson 4: Managing Reports

  • Using the workbench
  • Publishing to BusinessObejcts Enterprise

Lesson 5: Variables and Arrays

  • Defining variables
  • Declaring variables
  • Referencing variables
  • Defining arrays
  • Declaring arrays
  • Referencing arrays

Lesson 6: Report Templates

  • Applying report templates
  • Building a template without a data source

Lesson 7: Parameters

  • Common uses of parameters
  • Dynamic versus static parameters
  • Responding to a parameter
  • Multiple parameters
  • Edit masks
  • Grouping with parameters

Lesson 8: Cross-tabs

  • Building a basic cross-tab
  • Formatting a cross-tab

Lesson 9: Report Sections

  • Using the section expert conditionally
  • Underlay
  • Multi-column reporting

Lesson 10: Specialised Reports

  • Running totals
  • Form letters
  • Hyperlinks
  • Dynamic graphics
  • Alerts
  • Top N reporting

Lesson 11: Sub-Reports

  • Adding a sub-report
  • Changing sub-report links
  • On-demand sub-reports
  • Shared variables
  • Linking on un-linkable data

Audience

The target audience for this session is Crystal Reports report designers.

Pre requisite Knowledge, Experience and Education

  • SAP Crystal Reports Introduction Workshop

Delivery & Duration

This is a three day workshop. The training can take place either on your site or at one of our venues around the UK.

Request More Information

For more information regarding this workshop, please call today 0845 124 9495 and speak to one of our team or complete our short form below.

Return to IndexIndex