SAP Crystal Reports 2020 User Guide

1 PUBLICSAP Crystal Reports 2020 Document Version: 2020 2020-06-12 SAP Crystal Reports 2020 User Guide 2020 SAP SE or an SAP affiliate company. All rights BEST RUN Content1 Document Introduction to SAP Crystal Reports About Crystal About the Crystal Reports information Quick Learning how to use Crystal data - Report Creation Quick start for new you the and the Quick start for advanced a report type and data with report elements on the Design other reporting Report Design Basic report Deciding on the content of the the the layout of the report ..48 Finding the the printing area Developing a prototype on Introduction to Crystal Reports 2020 User Report creation Choosing data sources and database Database Field About the report design Preview Creating a new the data multiple data on the (Binary Large Object) , sorting, and summarizing the drill-down option on summarized the zoom page headers and a title page to the summary information to the Exploring Reports and working with multiple Report Dependency and docking Beyond basic SAP BusinessObjects Enterprise What is the SAP BusinessObjects Enterprise Repository?

2 88 Work Accessing the SAP BusinessObjects Enterprise open the SAP BusinessObjects Enterprise Repository Explorer Adding subfolders and subcategories to the add a new subfolder or Adding items to the a text object or bitmap a text object or bitmap image - another a custom a Crystal Reports 2020 User Using repository objects in Reports ..94 Adding a text object or a bitmap image to a a custom function to a a command to a a list of values to a Modifying objects in the modify a repository Updating connected repository objects in set the update Deleting items from the delete an object from the Using Undo in the Designing Optimized Web strategies for optimizing web Scale with SAP BusinessObjects Business Intelligence platform ..101 Evaluation times for date functions in SAP BusinessObjects Business Intelligence platform .. Making the right design faster report between live and saved summary subreports other design elements Reports to maximize data Streamlining your reporting the fastest database and table table-linking thread-safe database stored procedures for faster Using enhanced record selection formulas.

3 110 Pushing down record selection an selection performance for writing efficient record selection parameter fields into record selection SQL expressions where Improving grouping, sorting, and grouping on of grouping on server - an SQL Expressions for groups, sorts, and Crystal Reports 2020 User GuideContentUsing SQL Expressions for Case summary and running total fields where Formatting Reports for viewing on different Record Selecting for selecting which field(s) to the Select of the Select Expert and the Formula data selection Using formula selection formula Pushing down record selection to the database Troubleshooting record selection troubleshoot record selection selections that do not generate Sorting, Grouping, and Sorting sort single and multiple Grouping custom groups records within data in by the first letter of a company data Summarizing grouped summarize grouped groups by summarized top or bottom N groups or top or bottom groups or percentages prices and subtotaling the Crystal Reports 2020 User a Group group group on group Running Understanding running running totals Creating running running totals in a running totals for a conditional running running totals in a one-to-many linking Creating running totals using a create running totals using a Multiple Section About Working with a a a two related Splitting and resizing a a Using multiple sections in Reports .

4 186 Keeping variable length objects from overwriting each blank lines when fields are blank lines Form with text a form letter using a text conditional messages in form Formatting Using a a an applied Crystal Reports 2020 User GuideContentReapplying the last template Template Field Using the Report Design an object underlay a following report report text-based multi-line, text-based text-based objects from a between text-based a field ..220 Balancing field allow for overflow field multiple character and line fractional font page size and page page a report for web Formatting Working with absolute borders, color, and shading to a a report, section, area, or object an object's size and your default field and editing and editing behavior of line and box shapes to a , cropping, and sizing conventional accounting report objects on horizontal white space between Working with conditional Crystal Reports 2020 User GuideContentPUBLIC7 Conditional on or off attribute margins X position footers after the first the Highlighting Using the Format copy and apply Working with a the appearance of a a Charting to place a chart.

5 263 Drill-down with with Creating on details or formula fields (Advanced layout)..264 Charting on summary or subtotal fields (Group layout)..265 Charting on Cross-Tab summaries (Cross-Tab layout)..266 Charting on an OLAP cube (OLAP layout).. Working with charts using the Chart charts using the Chart Options menu charts using other menu the zooming features with bar and line the underlay feature with Mapping to place a Crystal Reports 2020 User GuideContentDrill-down with Creating on group fields (Group layout)..279 Mapping on Cross-Tab summaries (Cross-Tab layout)..279 Mapping on an OLAP cube (OLAP layout).. Working with maps using the Map the map the map map data the geographic in and out on a a a OLE of OLE OLE Inserting OLE objects into copy and paste OLE objects .. How OLE objects are represented in a Editing OLE objects in OLE menu and the Insert Picture Working with static OLE a static OLE a static OLE object a static OLE object to a bitmap image Working with embedded vs.

6 Linked Cross-Tab What is a Cross-Tab object?.. Cross-Tab of order data - no of order data - grouped by of order data - grouped by Crystal Reports 2020 User GuideContentPUBLIC9 Report of order data - grouped by region and data in a Cross-Tab Creating a Cross-Tab create a new cross-tab add a Cross-Tab to an existing the data the a the structure of the a predefined style and finishing the a Cross-Tab to an existing report using the Cross-Tab Working with values as large summarized fields ..311 Customizing row/column running totals in Cross-Tabs that span multiple pages .. Formatting width, height, and alignment of Cross-Tab background color of entire fields several fields at one Cross-Tab summarized fields Advanced Cross-Tab Building Connecting to a connect to a Defining the data selection for a build a simple create a combined reference to Editing an existing edit an existing Viewing the SQL behind a view the SQL when you create a view the SQL after you have created a Query filters and Crystal Reports 2020 User GuideContentCreating query query filters and And or Or to combine query reference to query filter and removing query Filtering data using subqueries and database is a subquery?

7 333 Building a is a database ranking?..335 Creating a database Creating and Updating OLAP OLAP reporting with Crystal grid Creating an OLAP create an OLAP the data the structure of the sliced dimensions and specifying the number of a predefined a Updating an OLAP update a cube location in an OLAP grid Formatting data in an OLAP the background color of a an alias for a grid Changing the view of OLAP show or hide dimension members ..349To create asymmetry in an OLAP add totals to an OLAP change the display format for member alter the data displayed in the OLAP define the order of fields in the OLAP grid .. Sorting and filtering OLAP grid data in an OLAP data in an OLAP Adding calculations to OLAP Printing, Exporting, and Viewing Crystal Reports 2020 User Distributing a a a with Enterprise Viewing Parts and other Report an Enterprise Smart View to view a report in the Using smart use smart tags with a Crystal Reports Report About Report Working with Report Report Report Report Report to Report Alerts in Using Formulas uses for Formula components and User Function Libraries in Specifying with the Formula with the Formula Creating and modifying create a formula and insert it into a a formula in the Formula for formula Deleting the working formula from your the formula Debugging evaluation time Crystal Reports 2020 User GuideContentDebugging Error Messages and Formula Compiler Parameter Fields and Parameter and prompt field and non-data Understanding dynamic Understanding lists of which list-of-values type to of values and prompt

8 Groups Creating a parameter with a static create a parameter with a static prompt ..440To incorporate the parameter into the record selection incorporate the parameter into a saved data selection Creating a parameter with a dynamic create a parameter with a dynamic Creating a parameter with a cascading list of create a parameter with a cascading list of The Parameter Working with lists of common lists of values within a separate value and description command objects as list-of-values data lists of Best practices for unmanaged Reports to managed managed Reports with dynamic Deleting parameter delete a parameter that is not used in a delete a parameter used with the Select delete a parameter that is used in a Responding to parameter field a report for the first report Advanced parameter Crystal Reports 2020 User GuideContentPUBLIC13 Creating a parameter with multiple prompting conditional formatting using parameter a report title using parameter

9 Single or ranges of a parameter into a sort order using parameter entry type and format using the Edit a saved-data record filter using parameter create a parameter appearing on the Parameter incorporate the parameter into a saved data selection dynamic grouping using parameter What are subreports?..468 Unlinked vs. linked subreport linking Inserting a subreport as a primary Linking a subreport to the data in the primary link a subreport to the data in the primary Linking a subreport to the main report without modifying the selection link a subreport to a main report without modifying the selection Combining unrelated Reports by using combine two unrelated combine three or more unrelated Using subreports with unlinkable to/from a formula unindexed Creating an on-demand create an on-demand Adding captions to on-demand add a Showing different views of the same data in a Understanding Databases database Using SQL and SQL is SQL?

10 48514 PUBLICSAP Crystal Reports 2020 User GuideContentSQL does Crystal Reports use SQL?..489 The SQL an SQL Changing data change the data Working with Linking from and link considerations in one-to-many file database considerations for all Database Expert Links indexed processing Server-side server-side grouping affects the SQL Mapping database the Map Fields dialog altered database Saved Data Report Indexing for using Saved Data the right field(s).. Unicode support in Crystal Working with Access ODBC data Advanced database links ..530 Reporting on an NT Event For additional Integrating Business Applications with Crystal Integrating with with Integrating with Oracle E-Business Crystal Reports 2020 User access data in SAP Crystal Integrating with to the business Reports with Siebel Reports created in earlier versions of Crystal Siebel tables in Integrating with access data in SAP Crystal Integrating with JD access data in SAP Crystal Accessing Data types of Direct access database database ODBC data database ODBC database JDBC data sources.