Course details
Crystal Reports 8.5 Advanced is a hands-on instruction book that will introduce you to the some of the advanced features within Crystal Reports. You will use variables and multiple statements in formulas, create and use parameter fields, develop conditional format statements and work with multiple sections.
Prerequisites:
This course is designed for users with a basic knowledge of Crystal Reports but who require the use of advanced formulas and formatting, need to access information that is not PC-based, or need to set up reports that other users will access and run. Although no database experience is necessary, some of the concepts may be more meaningful if the user has worked with database applications before. A basic knowledge of relational data concepts is also recommended.
Review Exercises:
- Creating a Basic Report
- Adding and Linking Databases to a Report
- Selecting, Grouping, and Summarizing
- Creating Formulas
- Formatting Sections for Summary/Drill-Down
Conditional Formatting:
- Absolute versus Conditional Formatting
- On/Off Formatting
- Conditional Attribute Formatting
- The Highlighting Expert
- Restoring Conditional Formats
Advanced Formulas:
- Using Variables in Formulas
- Creating a Running Total
- Understanding Multiple-pass Reporting
- Using Evaluation Time Functions
- Creating Formulas Using Multiple Variables
Multiple Sections:
- Inserting Sections
- Moving Sections
- Splitting Sections
- Multiple Sections and Conditional Formats
Parameter Fields:
- Creating Parameter Fields
- Using Pick Lists
- Using Parameter Fields in Record Selection
- Using Edit Masks
- Using Parameter Fields to Set Sort Criteria
- Using the Like Statement
- Setting Conditional Formats Using ParameterFields
Using Report Alerts:
- What are Report Alerts
- Creating Report Alerts
- Modifying Report Alerts
- Deleting Report Alerts
Advanced Cross-tabs:
- Inserting Multiple Rows, Columns, and SummarizedFields
- Editing a Cross-tab
- Using Formula Fields in a Cross-tab
- Using Parameters in Cross-tabs
- Creating a Cross-tab Object for Each Group Value
Subreports:
- Identifying Subreport Features
- Inserting Unlinked Subreports
- Formatting Subreports
- Inserting Linked Subreport
- Using On-demand Subreports
SQL/ODBC and Crystal SQL Designer:
- Introducing Structured Query Language (SQL)
- Introducing ODBC Data Sources
- Introducing the Crystal SQL Designer
- Using a Query to Create a Report
Crystal Dictionaries:
- Defining Dictionaries
- Using Existing Dictionaries
- Creating Dictionaries
- Enhancing Your Dictionary
- Modifying a Dictionary
Graphing:
- Using Chart Types and Layouts
- Using the Chart Expert to CreateGraphs
- Modifying Existing Charts with the Chart Editor
- Formatting Charts
Course Location
About Professional Training Solutions Ltd
Professional Training is a group of experienced specialists providing specific training and consultancy solutions, within Management Skills, I.T. systems, Human Restheirce Development, Credit Management, Sales, Finance and Engineering.
they believe in using a combination of tailored, flexible approaches and real-life business knowledge to develop and provide techniques and solutions for immediate implementation.
their recent projects include supporting major initiatives for clients in utilities, telecoms, manufacturing and software, covering:
restructuring for competitiveness
productivity improvements through updating work processes to match new technology
managing outstheircing
strategic financial planning and engineering
their methodology is to:
Work closely with clients to understand and help them prioritise their needs
Design and deliver the best mix of training activities and consultancy to establish the competencies required
Provide ongoing coaching to sustain the improved practices and processes
they create relevant, targeted, enjoyable, and interactive, training sessions which are designed to improve the retention of information by participants and create a clear link from the training to the workplace. This creates a planned, visible improvement in key business indicators such as productivity, motivation, loyalty, employee retention, and ultimately, profit.
their collaborative approach builds long-term relationships with clients. Together, they can deal effectively with the inevitable challenges all businesses face.
See all Professional Training Solutions Ltd courses View more Virtual classroom training for IT, Computing and Technology online courses View more similar courses
IT, Computing and Technology Related Questions
Are you from Professional Training Solutions Ltd ? Claim your course!
Courses you can instantly connect with... Do an online course on IT, Computing and Technology starting now.
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- AED 167
AED 426Duration: 1 To 2 Months - Mastering Your iPhone Study 365AED 125
AED 832Duration: Upto 5 Hours - AED 34,889Duration: 18 - 20 Months Live virtual classroom
- AED 10,896Duration: 12 Weeks Live virtual classroom
