Crystal Reports Advanced

Request info

Overview

This course enables users to create more complex Crystal Reports. Report objects such as cross-tabs and sub-reports will be used, and techniques such as Data Dictionaries and direct SQL queries are examined. This course is designed for users with basic report skills, needing to create more complex reports that include sub-reports, cross-tabs, advanced formulas, and charts. Users may or may not have programming and / or database experience

Duration

2 Days

Target Audience

Attendance at a Crystal Reports Introduction session is required; knowledge of SQL / Query tools would be helpful, as well as some understanding of database principles.

Topics

Advanced Formatting (Conditional)

Advanced Formula Techniques

Multiple-Pass Reporting

SQL/ODBC & SQL Designer

Crystal Dictionaries

Parameter Fields

Multiple Sections

Sub reports

Using Cross Tab Reports

Advanced Cross Tabs

Graphing / Charting

Duration: 2 Days

Cost: £750 + VAT

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) >= '2025-03-15' ) ) 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 (2283) 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