Corporate Training in
Excel, Advance Excel, VBA Macros for Excel
Classroom Training Available @ Kemps Corner( Grant Rd West) , Mehboob Studio(Bandra West) & Lokhandwala (Andheri West)
For Details visit www.compufield.com
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.
Course Content
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
:
091-22-23676218, 23679302, 23671772, Fax: 091-22-23671772