Mastering Crystal Reports Made EasyMastering Crystal Reports Made Easy DVD-ROM Self-Study Training Course Product Name: Mastering Crystal Reports Made Easy Manufacturer: TeachUcomp, Inc. Versions Covered: 2011, 2008, 11 (XI) & 10 Course Length: 8 Hours Video Lessons: 119 Instruction Manuals: 2 (PDF) Learn Crystal Reports 2011 with this comprehensive course from TeachUcomp, Inc. Mastering Crystal Reports Made Easy features 119 video lessons with over 8 hours of introductory through advanced instruction. Watch, listen and learn as your expert instructor guides you through each lesson step-by-step. During this media-rich learning experience, you will see each function performed just as if your instructor were there with you. Reinforce your learning with the text of our two printable classroom instruction manuals (Introductory and Advanced), additional images and practice exercises. You will learn all about how to establish data connections, create complex and detailed reports, advanced charting techniques and much more. Whether you are completely new to Crystal Reports or upgrading from an older version, this course will empower you with the knowledge and skills necessary to be a proficient user. We have incorporated years of classroom training experience and teaching techniques to develop an easy-to-use course that you can customize to meet your personal learning needs. Simply insert the DVD-ROM into your computer to launch the easy-to-use interface, click to launch a video lesson or open one of the manuals and you’re on your way to mastering Crystal Reports. This course also includes bonus material that covers differences in versions prior to 2011. 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. ADO.NET (XML) 5. Database Files 6. Java Beans Connectivity 7. JDBC (JNDI) 8. ODBC (RDO) 9. OLAP 10. OLE DB (ADO) 11. Salesforce.com 12. SAP BW MDX Query 13. SAP Info Sets 14. SAP Operational Data Source 15. SAP Table, Cluster, or Function 16. Universes 17. XML and Web Services 18. Repository 19. More Data Sources 20. Selecting Report Data and Tables 21. Making a "Favorite" Connection 22. The Data Explorer 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 4. Printing Reports Using Formulas1. Crystal Reports Formula Syntax2. The Formula Workshop- Formula Editor Window3. Creating Formula Fields4. Crystal Syntax5. Basic Syntax6. 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 5. Formatting Selected Chart Items 6. Formatting a Data Series 7. Formatting Chart Gridlines 8. Formatting a Chart Grid 9. Setting Chart Axes Options 10 . Adding Chart Trendlines 11 . Modifying a 3D Chart View 12. Using Chart Templates 13. 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. Report Alerts 7. 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 3. Creating a Cross-Tab Report Advanced Database Concepts 1. Viewing the SQL Code 2. Using Table Aliases 3. Verifying the Database 4. Setting the Datasource Location 5. Mapping Fields 1 GHz Intel Pentium Processor or equivalent Windows 8, 7, Vista, XP, Mac OS X 10.1 or later 1 GB RAM 256 color SVGA capable of 1024x768 resolution Speakers or headphones DVD-ROM Drive Which methods of payment do you accept? PayPal (preferred) or VISA/MC/AMEX/DISC. Payment is due within 3 days following the product (72 hours). After 4 days, we file an eCRATER non-paying buyder alert. Where do you ship? We ship all over the world. Please check the shipping options for each item for specifics. We ship Monday-Friday (except Holidays). Orders placed by 2 pm Eastern ship the same day. Where do you charge sales tax? Sales tax applies to Michigan, USA orders only. If you are a tax exempt entity please fax usyour tax exempt license at 517-333-2958. 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. I have more questions. How can I contact you? Please use the eCRATER message center to contact us. This assures that we receive your message. We are open Monday through Friday 9-5 Eastern and will answer you within one business day. We're always happy to answer questions. We want to make your buying experience as pleasurable as possible. ©TeachUcomp, Inc. All Rights Reserved. inkfrog terapeaki000000,RcmdId ViewItemDescV4,RlogId p4%60bo7%60jtb9%3Fvo%7B%3Dd70f%2Bf%60%60%3E-14178719f68-0xf9-->
