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.

2 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?

3 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.

4 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 ..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)

5 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

6 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 ..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.

7 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.

8 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).

9 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. linked Cross-Tab What is a Cross-Tab object?

10 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.