| Introduction |
Duration : 2 days |
|
Crystal Reports is designed to work with your database to help you analyze and interpret important information. Crystal Reports makes it easy to create simple reports, and, it also has the comprehensive tools you need to produce complex or specialized reports.
Crystal Report is a reporting tool, which supports 25 databases to create impressive reports, lists, form letters, pre-printed forms, or labels from data in your existing databases. Crystal Reports can produce reports by picking up data from various data sources, such as: Oracle, Informix, Sybase, Microsoft SQL Server, dBase, Clipper, FoxPro, Access, Lotus Notes, SAP, etc.
The flexibility of Crystal Reports doesn't end with creating reports; reports can be published in a variety of formats including Microsoft® Word and Excel, E-mail and even over the Web. Advanced Web reporting let’s other members of the workgroup view and update shared reports inside their web browser.
Application and web developers can save time and meet their users needs by integrating the report processing power of Crystal Reports into their database applications. Support for most popular development languages makes it easy to add reporting to any application.
|
| |
|
|
| |
Module 1: Simple Report |
| |
 |
Report creation options. |
|
Selecting the Database to use |
|
Saving the Report |
|
Adding a title to the report |
|
Formatting the report objects |
|
Format Painter |
|
Adding date to the report |
|
Adding Page Numbers to the report |
|
Adding Picture or OLE Objects to the report. |
| |
|
Module 1: Record Selection |
| |
|
|
Using the Select Expert . |
|
Deleting a criteria |
| |
|
| Module 2: Sorting Data |
| |
|
|
Sorting single and multiple fields |
| |
|
| Module 3: Group by Report |
| |
|
|
Grouping Data |
|
Grouping on Date field |
|
Creating custom groups |
|
Hierarchical Grouping |
|
Summarizing grouped data |
|
Top or bottom N groups or Percentages |
| |
|
| Module 4: Summary Reports |
| |
|
|
Introduction |
|
Creating a Summary Report |
|
Hide vs. Suppress |
| |
|
Module 5: Using Sections and Areas |
| |
|
|
Introduction . |
|
Changing the size of a section |
|
Formatting Sections with the Section Expert |
| |
|
| Module 6: Linking |
| |
|
|
Introduction |
|
Working with Links |
|
Using the Visual Linking Expert |
|
Smart Linking |
|
Adding/Removing Database from a Report |
| |
|
| Module 7: Formula Basics |
| |
|
|
Introduction |
|
Typical uses for formulas |
|
Creating a formula and inserting it into a report |
|
Copying formulas from one report to another |
|
Deleting formulas |
|
Crystal Syntax versus Basic Syntax |
| |
|
| Module 8: Custom Functions |
| |
|
|
What are custom functions? . |
|
Working with custom functions |
|
Viewing and modifying custom functions |
|
Calling custom functions |
|
Adding custom functions to the Crystal Repository |
|
Adding custom functions from the Crystal Repository |
|
Refreshing a report's repository custom functions |
|
Example of a function that returns Quarter using Crystal Syntax |
| |
|
| Module 9: Crystal Repository |
| |
|
|
Configuring a new repository |
|
Accessing the sample Crystal Repository |
|
Using repository objects in reports |
| |
|
| Module 10: Parameter overview |
| |
|
|
Parameter field considerations |
|
Creating a parameter field . |
|
To incorporate the parameter into the selection |
|
Refreshing report data . |
| |
|
| Module 11: Running Totals |
| |
|
|
Understanding running totals |
|
Creating a running total in a list |
|
Creating running totals for a group |
|
Creating conditional running totals |
| |
|
| Module 12: Conditional Formatting |
| |
|
|
Introduction |
|
Absolute Vs Conditional Formatting |
|
Conditionally Formatting Fields and Objects |
| |
|
| Module 13: About Report Alerts |
| |
|
|
Creating Report Alerts |
| |
|
| Module 14: Cross-Tab Objects |
| |
|
|
Introduction |
|
Creating a Cross-Tab Object |
|
Formatting Cross-Tabs |
| |
|
| Module 15: Graphing |
| |
|
|
Introduction |
|
Creating a Simple Graph . |
| |
|
| Module 16: Subreports |
| |
|
|
What are subreports? |
|
Unlinked vs. linked subreports |
|
Inserting subreports |
|
Saving a subreport as a primary report |
|
Updating subreports |
|
Creating an on-demand subreport |
|
Adding captions to on-demand subreports |
| |
|
| Module 17: Report Distribution |
| |
|
|
Introduction |
|
Export Formats |
|
Export Destinations |
|
Faxing a report |
| |
|
| Module 18: Tips working with Crystal Reports |
| |
|
|
Page Title on Drill down Reports |
|
Repeating Group Headers |
|
Creating Formula with Parameter for Report Header |
|
Inserting Page Break after every 20 records |
|
Creating a Page Total in Crystal |
| |
|
| |
|
| |
|
| |
.
Microsoft Office
|
|
Creative Courses
|
|
Web Designing
|
|
|
|
|
|
|
|
| |
|
:
091-22-23676218, 23679302, 23671772, Fax: 091-22-23671772