{"product_id":"crystal-reports-training","title":"Crystal Reports Training","description":"\u003cdiv\u003e\n\u003cp\u003eIn this hands-on Crystal Reports course, you will learn to create sophisticated reports from the ground up and transform raw data into meaningful information. In addition, you will gain the knowledge and skills to link multiple data sources and create compelling presentations using Crystal Reports.\u003c\/p\u003e\r\n\u003cp\u003eAfter this training course, you will return to your organization with a detailed process to help you retrieve and format data, create meaningful reports for widespread distribution, and integrate your reports with a website or application, such as .NET.\u003c\/p\u003e\r\n\u003cul\u003e\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch3\u003eCrystal Reports Training Benefits\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003eIn this course, you will learn how to:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eDevelop reports to transform data into meaningful information.\u003c\/li\u003e\n\u003cli\u003eCreate advanced graphical and crosstab reports.\u003c\/li\u003e\n\u003cli\u003eAdd calculations and program logic with the Formula Workshop.\u003c\/li\u003e\n\u003cli\u003eConnect to data sources and extract data to meet reporting needs.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003ePrerequisites\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eYou should be comfortable using Windows and working with a spreadsheet or word processor and have experience working with formulas in a spreadsheet program.\u003c\/p\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\u003ch3\u003eCrystal Reports Training Outline\u003c\/h3\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 1: Overview of Crystal Reports\u003c\/h4\u003e\n\u003cul\u003e\n\u003cli\u003eFormatting and summarizing data\u003c\/li\u003e\n\u003cli\u003eFiltering, sorting and grouping data\u003c\/li\u003e\n\u003cli\u003eCustomizing reports with business logic\u003c\/li\u003e\n\u003cli\u003eConnecting to SQL Server, Oracle and Access databases\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 2: The Crystal Report Writer\u003c\/h4\u003e\n\u003cp\u003e\u003cstrong\u003eWriting a basic report\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eSelecting a format\u003c\/li\u003e\n\u003cli\u003eAdding text and fields\u003c\/li\u003e\n\u003cli\u003eConnecting to remote data sources\u003c\/li\u003e\n\u003cli\u003eConfiguring the reporting environment\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eFormatting and styling\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eTailoring sections within a report\u003c\/li\u003e\n\u003cli\u003eDesigning fields for quality presentations\u003c\/li\u003e\n\u003cli\u003eHighlighting data with Highlight Expert\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 3: Linking Crystal Reports to Data\u003c\/h4\u003e\n\u003cp\u003e\u003cstrong\u003eConnecting to popular data sources\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eSQL Server\u003c\/li\u003e\n\u003cli\u003eOracle\u003c\/li\u003e\n\u003cli\u003eAccess\u003c\/li\u003e\n\u003cli\u003eWeb logs\u003c\/li\u003e\n\u003cli\u003eXML\u003c\/li\u003e\n\u003cli\u003eReporting from stored procedures and views\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eEstablishing data connections\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eCreating a connectivity checklist\u003c\/li\u003e\n\u003cli\u003eConfiguring ODBC and OLE DB\u003c\/li\u003e\n\u003cli\u003eIntegrating SQL commands in a report\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 4: Interpreting Structures and Retrieving Data\u003c\/h4\u003e\n\u003cp\u003e\u003cstrong\u003eNavigating complex data\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eDeciphering data structures\u003c\/li\u003e\n\u003cli\u003eIdentifying data relationships\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eGathering the right data\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eMerging data from multiple tables\u003c\/li\u003e\n\u003cli\u003eBuilding business queries\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 5: Combining Powerful Report Techniques\u003c\/h4\u003e\n\u003cp\u003e\u003cstrong\u003eOrganizing and summarizing reports\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eSorting user sort control and grouping\u003c\/li\u003e\n\u003cli\u003eSummary and Rolling Total fields\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eBuilding advanced reports\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eEmbedding linked and unlinked subreports into reports\u003c\/li\u003e\n\u003cli\u003eCreating crosstab and drill-down reports\u003c\/li\u003e\n\u003cli\u003eDesigning dynamic and cascading prompts\u003c\/li\u003e\n\u003cli\u003eHyperlinking Reports and Multilingual Reports\u003c\/li\u003e\n\u003cli\u003eAchieving reusability with templates\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eVisualizing complex data\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eSimplifying data with charts and graphs\u003c\/li\u003e\n\u003cli\u003eOrganizing fields into sections\u003c\/li\u003e\n\u003cli\u003eAdding, merging, suppressing sections\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 6: Programming Data Functionality\u003c\/h4\u003e\n\u003cp\u003e\u003cstrong\u003eCoding in formula language\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eWorking with variables and operators\u003c\/li\u003e\n\u003cli\u003eDeciphering formula syntax\u003c\/li\u003e\n\u003cli\u003eAdding and modifying formulas\u003c\/li\u003e\n\u003cli\u003eCalling and working with functions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eWriting effective formulas\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eBuilding \u003cb\u003eif\/then\/else\u003c\/b\u003e statements\u003c\/li\u003e\n\u003cli\u003eConverting and comparing data\u003c\/li\u003e\n\u003cli\u003eDebugging the code\u003c\/li\u003e\n\u003cli\u003eEmploying the Formula Workshop\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eConverting to Basic Syntax\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eWriting formulas with Basic Syntax\u003c\/li\u003e\n\u003cli\u003eLaying a foundation for complex reporting logic\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e","brand":"Learning Tree","offers":[{"title":"268A38US \/ 2026-08-06T09:00:00 \/ Herndon, VA","offer_id":47534164476123,"sku":"US-126-IL","price":1640.0,"currency_code":"USD","in_stock":true},{"title":"269C24US \/ 2026-09-28T09:00:00 \/ Herndon, VA","offer_id":48216558305499,"sku":"US-126-IL","price":1640.0,"currency_code":"USD","in_stock":true},{"title":"26BA66US \/ 2026-11-24T09:00:00 \/ Herndon, VA","offer_id":48216558338267,"sku":"US-126-IL","price":1640.0,"currency_code":"USD","in_stock":true},{"title":"271A78US \/ 2027-01-19T09:00:00 \/ Herndon, VA","offer_id":48216558371035,"sku":"US-126-IL","price":1640.0,"currency_code":"USD","in_stock":true},{"title":"273A62US \/ 2027-03-22T09:00:00 \/ Herndon, VA","offer_id":48498606178523,"sku":"US-126-IL","price":1640.0,"currency_code":"USD","in_stock":true},{"title":"275A57US \/ 2027-05-25T09:00:00 \/ Herndon, VA","offer_id":48804197204187,"sku":"US-126-IL","price":1640.0,"currency_code":"USD","in_stock":true}],"url":"https:\/\/learningtreeinternational-dirinfosec-hhs.myshopify.com\/products\/crystal-reports-training","provider":"Learning Tree International","version":"1.0","type":"link"}