Professor Joe training you CRYSTAL REPORTS in video

Topics Covered | Min System Requirements | Selling Policies | FAQs | About Us

You may also be interested in our Microsoft Access & Microsoft Excel tutorials available at auction or in our eBay store

The best Crystal Reports tutorial available.

• Designed by software training professionals.
• Learn at your office or home - at your own pace.
• Comprehensive! Includes all of the topics covered in classroom trainings.
• Customize your training with the easy-to-use menu.
• Clear, easy-to-follow, step-by-step instruction.
• Watch the training sessions as many times as you want while you practice in your software.
• No messy set-up, no internet connections needed. The menu will launch automatically and you will be on your way to learning!
• The best way to learn on your own.
• The confidence in knowing your tutorial was created by software training professionals - designed with you in mind.

Back to Top

The Crystal Reports Environment
1. Starting Crystal Reports
2. The Menu Bar
3. Using Toolbars
4. The Design View

Creating Data Connections
1. Creating a New Blank Report
2. The Database Expert
3. Access/Excel (DAO)
4. ACT!
5. Btrieve
6. Database Files
7. Exchange Message Tracking Logs
8. Field Definitions Only
9. File System Data
10. JDBC (JNDI)
11. Legacy Exchange (CR 11)
12. Mailbox Admin
13. Microsoft CRM (CR 10)
14. MS IIS/Proxy Log Files
15. NT Archived Event Log
16. NT Current Event Log
17. ODBC (RDO)
18. OLAP
19. OLE DB (ADO)
20. Outlook
21. Outlook/Exchange (CR 11)
22. Public Folder ACL
23. Public Folder Admin
24. Public Folder Replica
25. Web/IIS Log Files
26. xBase
27. XML
28. Creating Additional Data Connections and Selecting Tables
29. Making a “Favorite” Connection

Creating Basic Reports
1. Adding Data Fields to a Report
2. Browsing Field Data
3. Selecting, Moving, and Resizing Fields
4. Using the “Size” and “Align” Commands
5. Creating Text Objects
6. Saving a Report
7. Previewing a Report
8. Refreshing the Report Data

Linking Tables in a Report
1. Basic Table Structures and Terms
2. Linking Multiple Tables
3. Table Joins
4. Enforcing Table Joins and Changing Link Types

Basic Formatting Techniques
1. Formatting Report Objects
2. The Format Editor
3. Drawing Lines
4. Drawing Boxes
5. Format Painter
6. Formatting Part of a Text Object
7. The Template Expert
8. Inserting Pictures

Record Selection
1. The Select Expert
2. Setting Multiple Filters
3. Editing the Selection Formula

Sorting and Grouping Records
1. The Record Sort Expert
2. The Group Expert
3. Managing Groups
4. Summarizing Groups
5. Hierarchical Groupings
6. The Group Sort Expert

Printing Reports
1. Inserting Special Fields
2. Page Setup
3. Print Setup (CR 10)
4. Printing Reports

Using Formulas
1. Crystal Reports Formula Syntax
2. The Formula Workshop- Formula Editor Window
3. Creating Formula Fields
4. Crystal Syntax
5. Basic Syntax
6. Finding Function and Operator Assistance

Advanced Formatting
1. The Highlighting Expert
2. The Section Expert
3. Conditionally Formatting a Section
4. Conditionally Formatting a Field
5. Manipulating Multiple Sections

Summary Reports
1. Summarizing Report Data
2. Using the DrillDownGroupLevel Feature

Charting
1. The Chart Expert
2. Editing Charts
3. Setting General Chart Options
4. Changing Chart Titles (CR 10)
5. Formatting Selected Chart Items
6. Formatting a Data Series
7. Formatting a Chart Grid
8. Setting Chart Axes Options (CR 11)
9 . Adding Chart Trendlines
10 . Modifying a 3D Chart View
11. Using Chart Templates
12. Auto-Arranging Charts

Advanced Reporting Tools
1. Using Running Totals
2. Creating Parameter Fields
3. Parameterized Record Selection
4. Entering Parameter Values
5. Creating Subreports
6. Creating Cross-Tab Reports
7. Report Alerts
8. Report Alert Functions

Advanced Formula Creation
1. Evaluation Time Functions
2. Declaring Variables
3. Using and Displaying Variables
4. Using Array Values
5. Using “If… Then… Else…” Statements
6. Using the “Select/Case” Statement
7. Using “For” Loops
8. Using “Do… While” Loops
9. The IIF Function

Advanced Reporting
1. Creating a Report Template
2. Exporting Report Results
3. Exporting as HTML
4. Setting Default Options
5. Setting Report Options

Using Report Wizards
1. Using the Report Wizards
2. Report Wizard Types

Advanced Database Concepts
1. Viewing the SQL Code
2. Creating SQL Commands
3. Creating SQL Expression Fields
4. Using Table Aliases
5. Verifying the Database
6. Setting the Datasource Location
7. Mapping Fields

Back to Top

128 MB RAM
256 color SVGA capable of 1024x768 resolution
Sound Card
Speakers or headphones
4x CD-ROM drive

PC: 450 MHz Intel Pentium Processor (or equivalent) and later
Windows 98 or later (including Vista)
-or-
Macintosh: 500 MHz Power PC G3 and later
Mac OS X 10.1 or later

Back to Top

Payments

Methods Accepted: PayPal (preferred) or VISA/MC/AMEX/DISC.

Other: Payment is due within 3 days following the auction (72 hours). After 7 days, we file an eBay non-paying bidder alert.

Shipping

Where Shipped: Anywhere in the world.

We ship via USPS First Class (or Global Priority) mail. Delivery time is estimated by the USPS as 3-5 business days for domestic and 7-10 business days for international orders. You will receive an email confirmation & receipt once we process your order for shipment.

Delivery

When Shipped: Items paid for by 2:00 pm Eastern will be shipped the same business day.

Frequency of Shipping: Monday-Friday (except Holidays).

Refunds and Returns

Software is new and sealed. Software policy is no returns. Please feel free to contact us if you need more information before you bid.

Contact Information

E-mail at sales@teachucomp.com. We will normally respond by the next business day.

Back to Top

Product Specifics

• Why are these tutorials better than others?
• What are the different packages that are available?
• What versions of the software are covered on the tutorials?
• Do I have to have the software installed on my computer?
• What are the minimum system requirements?
• Are these for MAC or PC?

Payment Methods

• Which payment methods are accepted?

Return Policy

• What is your return policy?

Shipping and Delivery

• Domestic (U.S.) Shipping
• International Shipping

Sales Tax

• Where do you charge sales tax?

License Information

• Can I copy the tutorial or manuals?
• Can I install the tutorial(s) on my corporate network or use them to teach classes?

Privacy & Software Policies

• What is your privacy policy?
• Who can sell TeachUcomp, Inc. products on eBay?
• Copyright, Trademark Infringement / Software Piracy

Product Specifics

Why are these tutorials better than others?

Our tutorials were created by software training professionals, using the knowledge and expertise gained from years of classroom training. You won't get the static displays or poor sound quality you see with other trainings. Instead, you'll be guided through an animated tour of every lesson, showing you how to perform each function. The menu and easy-to-use interface allow you to quickly find the topics you want to customize your training to fit your needs. Our instruction e-manuals (in PDF) further assist your training by providing additional instruction, as well as step-by-step practice exercises to simulate the classroom-learning environment. Watch and listen as the instructor demonstrates a function, then refer to the exercises in the manual to get hands-on practice in your software.

Back to FAQs | Back to Top of Page

What are the different packages that are available?

CPE Editions are for tax professionals seeking to meet their Continuing Professional Education requirements. Our CPE products include practice exams and final exam submission.

CD-ROM Versions are physical products shipped to you. The CD-ROMs do not install on your computer and can be used at different machines (at different times).

Online Versions are the same products as the CD-ROM versions, delivered instead to you via a subscription to our online training site. Once you purchase your subscription, we will send you your secure password and login information within one business day. Then, simply login to our website for instant access to your courses.

Back to FAQs | Back to Top of Page

What versions of the software are covered on the tutorials?

Many of our products cover multiple versions. The products are "backwards compatible" -
meaning that they cover recent as well as earlier versions. When there are differences
in functionality, it is demonstrated within the same lesson or in an entirely different
lesson. This makes our products as flexible as possible for offices with PCs on different versions or for people who upgrade. Please refer to the specific auction or store listing to determine the versions that are covered.

Our tutorials run on both PC and Macintosh. The version of software taught is the PC version. Because the majority of the training is menu-driven, most of the material will be the same. However, there are some differences between PC and MAC versions of the software. We encourage you to view the sample lesson (link at the top of this page) to gauge the differences and determine if the training suits your needs.

Back to FAQs | Back to Top of Page

Do I have to have the software installed on my computer?

Our tutorials will run without the software being installed on your computer. However, we strongly recommend that you have the software installed, so you can practice after watching the lessons.

Back to FAQs | Back to Top of Page

What are the minimum system requirements?

128 MB RAM
256 color SVGA capable of 1024x768 resolution
Sound Card
Speakers or headphones
4x CD-ROM drive

PC: 450 MHz Intel Pentium Processor (or equivalent) and later
Windows 98 or later (including Vista)
-or-
Macintosh: 500 MHz Power PC G3 and later
Mac OS X 10.1 or later

Back to FAQs | Back to Top of Page

Are these for MAC or PC?

Our tutorials run on both PC and Macintosh. The version of software taught is the PC version. Because the majority of the training is menu-driven, most of the material will be the same. However, there are some differences between PC and MAC versions of the software. We encourage you to view the sample lesson (link at the top of this page) to gauge the differences and determine if the training suits your needs.

Payment Methods

Which payment methods are accepted?

For your convenience, we offer these payment methods:

PayPal

This is our preferred payment method. It's fast, easy and secure for both parties.

Pay Us Directly by Credit Card (Only after you win an auction or use Buy It Now)

1. Call us toll-free at 877-925-8080 in the U.S. & Canada, or 517-333-2560 (Monday-Friday 9-5 Eastern)
2. Be sure to have your eBay item number handy when you call, so we can properly credit your account
3. We accept VISA/MC/AMEX/DISC

Back to FAQs | Back to Top of Page

Return Policy

What is your return policy?

Software is new and sealed. Software policy is no returns.

Back to FAQs | Back to Top of Page

Shipping and Delivery

Domestic (U.S.) Shipping

Orders placed by 2:00 PM (EST) Monday-Friday ship the same day. Orders placed
after 2:00 PM will ship the following business day.

We ship via USPS First Class within the U.S.

Back to FAQs | Back to Top of Page

International Shipping

Yes! We ship anywhere in the world - via USPS Global Priority
All duties and taxes are the responsibility of the buyer.

Back to FAQs | Back to Top of Page

Sales Tax

Where do you charge sales tax?

Sales tax applies to Michigan, USA orders only. If you are a tax exempt entity please fax us
your tax exempt license at 517-333-2958.

Back to FAQs | Back to Top of Page

License Information

Can I copy the tutorial or manuals?

No. Our products are copyrighted and it is illegal to make copies. However, for physical products, our trainings run directly off the CDs and do not install on your PC. Therefore,
they can be shared with everyone in the office and used on multiple PCs. The
e-manuals may be stored on up to two (2) hard drives. We also grant unlimited
personal printing rights to the owner, strictly limited to the purposes of personal
or private education or research.

Back to FAQs | Back to Top of Page

Can I install the tutorial(s) on my corporate network or use it to teach classes?

No. These require special licensing not currently available on eBay.

Privacy & Software Policies

What is your Privacy Policy?

We value your right to privacy. When you order products from TeachUcomp, Inc., your personal information is kept in strict confidence. We do not rent, sell or provide your personal data to any other entity unless required by law.

Back to FAQs | Back to Top of Page

Who can sell TeachUcomp, Inc. products on eBay?

Individuals or companies offering TeachUcomp, Inc. products MUST be an authorized distributor. TeachUcomp, Inc. does NOT permit authorized distributors or others to sell our products on eBay.

Back to FAQs | Back to Top of Page

Copyright, Trademark Infringement / Software Piracy

TeachUcomp, Inc. is a registered trademark of TeachUcomp, Inc. As a member of eBay's VERO program, we take software piracy, copyright and trademark infringement very seriously. TeachUcomp, Inc. is the author, publisher, and copyright holder of all its products. Copyright Infringement ("software piracy") is a Federal Crime, punishable by up to FIVE (5) years in prison and/or a substantial fine. Any person attempting to sell "backup" or counterfeit copies of TeachUcomp, Inc. products will be prosecuted to the fullest extent of the law.

If you believe you have purchased a counterfeit copy of our software, please notify us immediately and we will pursue the matter. Please note that due to confidentiality and TeachUcomp, Inc.'s privacy policy, we cannot disclose our findings or any actions that may be taken.

Back to Top of Page

Founded in 2001, TeachUcomp, Inc. began as a licensed software training center, with headquarters in Holt, Michigan. Providing instructor-led, classroom-style instruction in over 85 different classes, including Microsoft Office, QuickBooks, Peachtree and web design, teaching staff at organizations such as the American Red Cross, Public School Systems and the Small Business Association.

At TeachUcomp, Inc., we realize that small business software can be confusing, to say the least. However, finding quality training can be a challenge. TeachUcomp, Inc. has changed all that. As the industry leader in training small business software, TeachUcomp, Inc. has revolutionized computer training and will teach you the skills to become a powerful and proficient user.

In 2002, responding to the demand for high-quality training materials that provide more flexibility than classroom training, TeachUcomp, Inc. launched our first product - Mastering QuickBooks Made Easy. The enormous success of our first tutorial led to an ever-expanding product line. TeachUcomp, Inc. now proudly serves customers in over 60 different countries world-wide including individuals, small businesses, non-profits and many others. Clients include the Transportation Security Administration, NASA, Smithsonian Institution, University of Michigan, Merrill Lynch, Sprint, U.S. Army, Oracle Corporation, Hewlett-Packard and the U.S. Senate.

Our full-time staff of software training professionals have developed a product line that is the perfect solution for busy individuals. Our comprehensive tutorials cover all of the same material as our classroom trainings. Broken into individual lessons, you can target your training to meet your needs - choosing just the lessons you want (and having the option to watch them all if you like). Our tutorials are also incredibly easy to use. It's as easy as using the Internet.

You will listen and watch as our expert instructors walk you through each lesson step-by-step. Our tutorials also feature the same instruction manuals (in PDF) that our classroom students receive - and include practice exercises and keyboard shortcuts. Everything in the tutorials is presented in full-motion animation - not sequential still screens. You will see each function performed just as if the instructor were at your computer. After the lesson has finished, you then "toggle" into the application and practice what you've learned - making it the most effective interactive training solution to learn on your own.

You are a just click away from discovering the true power and potential of your software.

Back to Top of Page

©TeachUcomp, Inc. All Rights Reserved.

TeachUcomp, Inc.® is a registered trademark of TeachUcomp, Incorporated. All other trademarks are the property of their respective companies.