Crystal Reports 2011 Introduction – SAP Business Objects BI

Request info

Crystal Reports 2011 Training

CONTENT

  • Create, Modify and Display Reports
  • Use Formulas in Reports: Create, Edit and Filter Formulas
  • Work with Advanced Formulas, Functions and Null Values
  • Building Parameterised Reports
  • Grouping Report Data
  • Enhancing a Report using formatting, objects and templates
  • Creating, Modifying and Updating a Report from Excel Data
  • Distributing and Exporting Data, including Mailing Lists and Labels

AUDIENCE

  • This is a hands-on course designed to empower delegates whose job requires them to produce reports from databases.

PREREQUISITES:

  • Basic computer skills.
  • Familiar with basic database principles: table relationships, primary keys
  • Familiar with Microsoft Access or Excel
  • Familiar with SQL (desirable but not essential)

GOALS

  • Explore the Crystal Reports interface
  • Create and modify basic reports
  • Use formulas to calculate and filter data
  • Build parameterised reports
  • Group report data
  • Enhance reports
  • Create reports using data sourced from an Excel database
  •  Distribute data

Duration: 2 Days

Cost: £750 + VAT

Crystal Reports 2011 Training Inverness, Aberdeen, Glasgow, Edinburgh, Dunfermline and other sites throughout the UK including onsite closed company courses are available.

SELECT wp_posts.*, wp_p2p.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_p2p WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'start_date' AND CAST(wp_postmeta.meta_value AS DATE) >= '2024-06-13' ) ) AND ((wp_posts.post_type = 'schedule' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled'))) AND (wp_p2p.p2p_type = 'schedule_to_courses' AND wp_posts.ID = wp_p2p.p2p_from AND wp_p2p.p2p_to IN (SELECT wp_posts.ID FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (2228) AND ((wp_posts.post_type = 'courses' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled'))) ORDER BY wp_posts.post_date DESC )) GROUP BY wp_posts.ID ORDER BY CAST(wp_postmeta.meta_value AS DATE) ASC