Crystal Reports – basic course
- Details
- Category: Education
- Published on 19 February 2011
- Hits: 297
Crystal reports I - 15 hours
Introductory part – work overview with database(2 h)
- Overview of reports and databases
- Preparing the source of information (relations, tables)
- Report’s purpose
- Report’s layout (about the concepts of a report)
Introductory part – overview of materials (2 h)
- Overview of programme’s options
- Creating steps in the process of report creation
- Initial editor settings
- Using the help system
The use of Report Expert (1 h)
- Adding and connecting databases
- Creating the basic report
- Creating a new report using Standard Report Expert
- Creating a new report using Mailing Labels Report Expert
- Editing reports using Edit Expert
Creating simple reports (4 h)
- Introduction into report sections
- Creating a new report
- Report preview before printing
- Shaping reports by changing the size and position of fields
- Adding report name
- Changing the font in the fields of a report
- Adding page numbers in a report, adding the logotype of a company and other graphic elements
- Saving a report
Working with reports (1 h)
- Data search
- Report printing
- Parts editor
Grouping the data (1 h)
- Defining a single grouping of data
- Defining a multiple grouping of data
- Changing the grouping options
- Insertion of subtotals and a sum of all totals
- Insertion of summary fields
- Insertion of percentages and totals
- Working with Top N/Sort Group Expert
Sorting out and selecting data of report records (1 h)
- Sorting out the records
- Working with Select Expert
- Addition of criteria for the display of data using “and” operator
- Modification of combined formulas and combined criteria of data display
1st part
- Preview, design
- Workspace
- Field explorer
- Undo
- Special fields, types of fields
- Templates
- Page setup
2nd part
- Line, Box
- Picture insertion
- Suppress (templates)
- Sort
- Select
- Browse data
- Format painter
- Hyperlink
- Format fields
- Report summary + special fields
3rd part
- Format fields
- Grids, Guidlines
- Application settings (options)
- Report summary
- Bold of a part of the text (connecting report fields)
- Conditional formatting
- Linking tables
- Alerts
- Spliting sections
- Queries
- Modification of the initial application settings
Section formatting (1 h)
- Overview of sections
- Changing of section size in Design View
- The use of Section Expert
- Creating overall fields and Drill Down report
Creating formulas (2 h)
- Creating formula components
- Creating a new formula using Formula Editor
- Editing formulas
- Creating String formulas
- Creating Date functions
- Creating If-Then-Else functions