Download the PDF below for the full article on How to Work with SAP Crystal Reports in SAP Business One

To open file, right click and choose to open link in new tab or window

HowTo_Work_with_CR_91.pdf


Contents

1 Introduction .......................................................................................................................... 6
1.1 Installing SAP Crystal Reports for SAP Business One ............................................................. 6
1.2 Integration Features ............................................................................................................ 7
1.3 Terms and Definitions .......................................................................................................... 8
1.4 Related Documentation ........................................................................................................ 9
2 Basic Operations .................................................................................................................. 10
2.1 Overview .......................................................................................................................... 10
2.2 Creating Reports and Layouts with SAP Crystal Reports for SAP Business One ........................ 10
2.2.1 Connecting to Data Sources ............................................................................................. 11
2.2.2 Creating Selection Criteria Windows .................................................................................. 15
2.2.3 Working with Selection Criteria Tokens ............................................................................... 19
2.2.4 Adding Drilldown Functionality with Link Arrows.................................................................... 29
2.2.5 Saving SAP Crystal Reports .rpt Files as Reports or Layouts .............................................. 32
2.2.6 Logging Off from a Data Source ....................................................................................... 35
2.3 Working with SAP Crystal Reports Layouts and Reports in SAP Business One .......................... 35
2.3.1 Running Layouts ............................................................................................................ 35
2.3.2 Editing Layouts .............................................................................................................. 36
2.3.3 Deleting Layouts ............................................................................................................ 38
2.3.4 Running Reports ............................................................................................................ 39
2.3.5 Editing Reports .............................................................................................................. 40
2.3.6 Deleting Reports ............................................................................................................ 41
3 Working with Multilanguage Reports ........................................................................................ 42
3.1 Translating Reports ........................................................................................................... 42
3.2 Generating Multilanguage Reports ....................................................................................... 45
3.3 Viewing Translated Reports in SAP Business One .................................................................. 46
3.4 Deleting Translations ......................................................................................................... 46
3.5 Creating New Reports from a Generated Multilanguage Report ................................................ 47
3.6 Exporting Translations ....................................................................................................... 47
3.7 Importing Translations ....................................................................................................... 48
4 Setting Authorizations for Reports Created with the SAP Crystal Reports Software ...................... 50
5 Setting Data Sources for User-Defined Crystal Reports and Crystal Reports Layouts ................. 51
6 Developing Add-Ons to Import .rpt Files ................................................................................. 52
7 Master Layouts ................................................................................................................... 53
8 Exporting Reports and Layouts Created with the SAP Crystal Reports Software .......................... 55
9 Importing Reports and Layouts Created with the SAP Crystal Reports Software .......................... 58
9.1 Importing SAP Crystal Reports .rpt Files ............................................................................. 58
9.2 Importing SAP Business One .b1p and .b1px Package Files .................................................... 63
10 Searching for Layouts and Reports ...................................................................................... 69
10.1 Searching for Layouts ...................................................................................................... 69
10.2 Searching for Reports ...................................................................................................... 70
11 Previewing and Printing Reports and Layouts in SAP Business One ........................................... 71
11.1 Previewing and Printing Reports and Layouts Saved in SAP Business One .............................. 71
11.2 Previewing SAP Crystal Reports .rpt Files Saved on Your Computer ....................................... 72
12 Working with Printing Sequences ........................................................................................... 74
12.1 Creating Printing Sequences ...............................................................................................74
12.2 Modifying Printing Sequences .............................................................................................76
12.3 Deleting Printing Sequences ............................................................................................... 77
12.4 Previewing and Running Printing Sequences ......................................................................... 77
12.5 Defining Printing Sequence As Default Printing Option ............................................................78
13 Report and Layout Manager Window ...................................................................................... 79
Appendix: Document Types and Source Tables ............................................................................ 80