|
Provided by: Mullan Training Advanced Crystal ReportsComputer |
![]() |
Training
Provided by Mullan Training
Review
- Creating reports
- Formatting
- Grouping
- Summarizing
- Selecting records
- Summary Drill Down
- Linking
- Formulas
- CrossTabs
Advanced Formulas
- Creating multiple statement formulas
- Using variables
- Understanding two-pass reporting
- Using evaluation time functions
- Creating running totals
- Adding User Functions Libraries (UFLs)
Conditional Formatting
- Types of formatting
- Absolute formatting
- Conditional on/off formatting
- Conditional attribute formatting
- Using the highlighting feature
Multiple Sections
- Inserting sections
- Splitting Sections
- Moving sections
- Deleting sections
- Multiple section formats (underlay following sections)
- Example uses (watermark, shading every other record, creating different header/footers, different form letters, suppress blank lines)
Parameter Fields
- Creating parameter fields
- Using parameter fields in record selection formula
Advanced CrossTabs
- Multiple rows, columns and summarised fields
- Formatting CrossTabs
- Using formulas, parameter fields in crosstabs
- Simulated CrossTabs
Subreports
- What are subreports?
- Linked subreports
- Unlinked subreports
- On-demand subreports
SQL/ODBC Query Designer
- What is the SQL/ODBC?
- What is the Query Designer?
- What is an ODBC data source?
- SQL statement components
- Creating queries
Creating Data Sources
- Using Access files
Graphing
- Creating a graph on summary fields
- Graphing on multiple summary values
- Graphing on CrossTabs
- Editing and formatting graphs
Dictionaries
- What are Dictionaries?
- Using dictionaries to create reports
- Creating dictionaries
Reporting
- Crystal Web Report server installation
- Introduction to Web Reporting
- Viewing Crystal Reports on the
LOCATIONS
Courses can be delivered at our offices in Belfast city centre (opposite the Europa Hotel) or in your own workplace (where we can provide 8 laptops, projector & flipcharts).
ADDITIONAL INFORMATION
If you would like more information please do not hesitate to contact us.
For a course outline visit our website
www.mullantraining.com
or email us at
info@mullantraining.com
or telephone
0289032 2228
- Creating reports
- Formatting
- Grouping
- Summarizing
- Selecting records
- Summary Drill Down
- Linking
- Formulas
- CrossTabs
Advanced Formulas
- Creating multiple statement formulas
- Using variables
- Understanding two-pass reporting
- Using evaluation time functions
- Creating running totals
- Adding User Functions Libraries (UFLs)
Conditional Formatting
- Types of formatting
- Absolute formatting
- Conditional on/off formatting
- Conditional attribute formatting
- Using the highlighting feature
Multiple Sections
- Inserting sections
- Splitting Sections
- Moving sections
- Deleting sections
- Multiple section formats (underlay following sections)
- Example uses (watermark, shading every other record, creating different header/footers, different form letters, suppress blank lines)
Parameter Fields
- Creating parameter fields
- Using parameter fields in record selection formula
Advanced CrossTabs
- Multiple rows, columns and summarised fields
- Formatting CrossTabs
- Using formulas, parameter fields in crosstabs
- Simulated CrossTabs
Subreports
- What are subreports?
- Linked subreports
- Unlinked subreports
- On-demand subreports
SQL/ODBC Query Designer
- What is the SQL/ODBC?
- What is the Query Designer?
- What is an ODBC data source?
- SQL statement components
- Creating queries
Creating Data Sources
- Using Access files
Graphing
- Creating a graph on summary fields
- Graphing on multiple summary values
- Graphing on CrossTabs
- Editing and formatting graphs
Dictionaries
- What are Dictionaries?
- Using dictionaries to create reports
- Creating dictionaries
Reporting
- Crystal Web Report server installation
- Introduction to Web Reporting
- Viewing Crystal Reports on the
LOCATIONS
Courses can be delivered at our offices in Belfast city centre (opposite the Europa Hotel) or in your own workplace (where we can provide 8 laptops, projector & flipcharts).
ADDITIONAL INFORMATION
If you would like more information please do not hesitate to contact us.
For a course outline visit our website
www.mullantraining.com
or email us at
info@mullantraining.com
or telephone
0289032 2228
|
|
||||||||||||||||||
Advanced Crystal Reports
--
About The Training Provider: Mullan Training
Mullan Training - Mullan Training are a computer training company in Belfast city centre.
We deliver high quality computer training in Belfast and throughout Northern Ireland.
We can deliver computer training courses in our training suites OR in your own offices. We are an authorised
Microsoft Office Specialist (MOS) Testing Centre so delegates can prepare for & sit exams with us.
Courses we deliver...

