Crystal Reports
Crystal Reports Course Content :
1. Overview of Crystal Reports
- Formatting and summarizing data
- Filtering, sorting and grouping data
- Customizing reports with business logic
- Connecting to SQL Server, Oracle and Access databases
- Adding charts and subreports to a report
2. The Crystal Report Writer
3. Writing a basic report
- Selecting a format
- Adding text and fields
- Connecting to remote data sources
- Configuring the reporting environment
4. Formatting and styling
- Tailoring sections within a report
- Annotating header and footer fields
- Designing fields for quality presentations
- Adding color, borders and pictures
- Highlighting data with Highlight Expert
5. Linking Crystal Reports to Data
6. Connecting to popular data sources
- SQL Server
- Oracle
- Access
- Web logs
- Reporting from stored procedures and views
7. Establishing data connections
- Creating a connectivity checklist
- Configuring ODBC and OLE DB
- Integrating SQL commands in a report
8. Interpreting Structures and Retrieving Data
9. Navigating complex data
- Deciphering data structures
- Identifying data relationships
10. Gathering the right data
- Merging data from multiple tables
- Building business queries
- Optimizing data retrieval
11. Combining Powerful Report Techniques
12. Organizing and summarizing reports
- Sorting user sort control and grouping
- Grouping with formulas
- Summary and Rolling Total fields
- Using Report Alerts
13. Building advanced reports
- Embedding linked and unlinked subreports into reports
- Creating crosstab and drill-down reports
- Designing dynamic and cascading prompts
- Multipass reporting, Hyperlinking Reports and Multilingual Reports
- Achieving reusability with templates
14. Visualizing complex data
- Simplifying data with charts and graphs
- Organizing fields into sections
- Adding, merging, suppressing sections
15. Programming Data Functionality
16. Coding in formula language
- Working with variables and operators
- Deciphering formula syntax
- Adding and modifying formulas with the Formula Workshop
- Calling and working with functions
- Sharing formulas with the Repository
17. Writing effective formulas
- Building if/then/else statements
- Converting and comparing data
- Debugging the code
- Employing the Formula Workshop
18. Converting to Basic Syntax
- Writing formulas with Basic Syntax
- Laying a foundation for complex reporting logic
19. Deploying Reports to the Internet, Intranets, Visual Basic and .NET
20.Deploying Crystal Reports
- Deciding among Push, Pull, Static and Dynamic reports
- Migrating to production by switching databases
- Determining when to use the Crystal Reports Server
21. Publishing reports to a Web site
- Exporting reports to HTML
- Publishing to CrystalReports.com
22. Integrating into custom applications
- Adding Crystal Reports to Visual Basic and .NET
- Exploring application development options with Crystal Reports
Course Reviews
No Reviews found for this course.
Write a Review