Crystal report

所需积分/C币:9 2013-12-18 15:18:19 5.46MB PDF
14
收藏 收藏
举报

Crystal report user manual
Contents Chapter 1 ntroduction to SAP Crystal Reports2011.…… About Crystal Reports 1.2 About the Crystal Reports documentation 1.2.1 Locate information quickly 22 1.2.2 Sample re Chapter 2 Quick Start 2.1 Learning how to use Crystal Reports 23 2.1.1 Sample data.Xtreme. mdb 2.2 Report Creation Wizards 24 2.2.1 Standard ..24 2.2.2 ross-a 24 2.2.3 Mailing Label 25 2.2.4 OLAP 25 2.3 Quick start for new users 25 2.3.1 Before you begin 26 2.3.2 reating th 2.3.3 Record Selection 37 2.34 Grouping and sorting 2.3.5 Completing the report 45 2.4 Quick start for advanced users 2.4.1 Choosing a report type and data source 2.4.2 Working with report elements on the Design tab 47 2.4.3 Using other reporting features 48 Chapter 3 Report Design Concepts.…,… 3.1 Basic repo t design 3.2 Deciding on the content of the repo 3.2.1 Stating the 3.2.2 Determining the layout of the report 52 3.2.3 Finding the data 3.2.4 Manipulating the data 54 2012-03-14 32.5 Determining printing area characteristics Developing a prototype on paper 57 3.3.1 To design a paper prototype 57 Chapter 4 Introduction to Reporting 4.1 Report creation options 59 4.2 Choosing data sources and database fields 4.2.1 The Database Expert 4.2.2 The Field Explorer.… 62 4.3 About the report design environment 64 4.3.1 esign tab 64 4.3.2 Preview tab 4.3 HTML Preview tab Creating a new report 73 4.4.1 Selecting the data source 73 4.4.2 Adding tables 74 4.4.3 Linking multiple tabl 75 4.4.4 Placing data on the report 76 4.4.5 BLOB (Binary Large Object) fields 83 4.4.6 Formatting data , 83 4.4.7 Record selection 94 4.4.8 Grouping, sorting, and summarizing data 84 4.4.9 Using the drill-down option on summarized data 84 4.4.10 Using the zoom feature 85 4.4.11 Inserting page headers and footers 85 4.4.12 Adding a title page to the report 4.4.13 Adding summary information to the report 4.5 Exploring reports and working with multiple reports 88 4.5.1 The Report Explorer 88 4.5.2 The Workbench 90 4.5.3 The Dependency Checker 4.5.4 Opening and docking explorers 4.6 Beyond ba 94 Chapter 5 SAP BusinessObjects Enterprise Repository 95 5.1 What is the SAP Business Objects Enterprise Repository/? .95 5.1.1 Work floy 5.2 Accessing the SAP Business Objects Enterprise Repository 5.2.1 To open the SAP BusinessObjects Enterprise Repository 97 Repository Explorer toolbar 97 2012-03-14 Adding subfolders and subcategories to the repository 5.4.1 To add a new subfold Adding items to the repository 5.5.1 Adding a text object or bitmap image 9 552 Adding a text object or bitmap image- another method 100 55.3 Adding a custom function 5.5 Adding a command 101 5.6 Using repository objects in reports 101 5.6.1 Adding a text object or a bitmap image to a report 102 5.6.2 Adding a custom function to a report 102 56.3 Adding a command to a report 56.4 Adding a list of values to a parameter 103 5.7 Modifying objects in the repository 103 5.7.1 lo modify a repository object .104 Updating connected repository objects in reports ..104 5.8.1 To set the update option 105 Deleting items from the repositor 105 5.9.1 To delete an object from the repository 105 5.10 Using Undo in the repository 106 Chapter 6 Designing Optimized Web Reports 107 6.1 Overview 107 6.1.1 Key strategies for optimizing web reports 108 6.2 Scale with SAP Business Objects Business Intelligence platform 108 6.2.1 Evaluation times for date functions in SAP Business Objects Business Intelligence platform. 109 6.3 Making the right design choices 110 6.3.1 Using faster report formats 6.3.2 Choosing between live and saved data 111 6.3.3 Designing summary reports 112 6.34 Using subreports carefully 113 6.35 Using other design elements effectively 6.36 Designing reports to maximize data sharing 5 64 Streamlining your reporting environment 116 6.4.1 Selecting the fastest database and connection 116 6.4.2 Using table indexes 116 mproving table-linking choices 6.44 Using thread-sate database drivers 117 64.5 Using stored procedures for faster processing 118 6.5 Using enhanced record selection formulas 119 6.5.1 ushing down record selection-an example 119 6.5.2 Record selection performance tips 2012-03-14 6.5.3 Strategies for writing efficient record selection formulas 6.5.4 Incorporating parameter fields into record selection formulas 124 6.5.5 Using SQL expressions where appropriate 125 6.6 Improving grouping, sorting, and totaling 125 6.6.1 Performing grouping on server 126 66.2 Benefits of grouping on server-an example 66.3 Using SQL Expressions for groups, sorts, and totals 127 6.6.4 Using SQL Expressions for Case Logic 128 6.65 Inserting summary and running total fields where possible 128 Record selection 129 7.1 electing reco 7.1.1 Options for selecting records 129 7.1.2 Determining which field(s)to use 7.1.3 Using the Select Expert 7.14 Using formulas 132 7.15 Interaction of the Select Expert and the Formula Editor 132 7.1.6 Saved data selection formulas 134 7.2 Using formula templates 134 7.2.1 Record selection formula templates , 134 7.3 Pushing down record selection to the database server. 137 7.4 Troubleshooting record selection formulas 137 7.4.1 To troubleshoot record selection formulas 137 7.4.2 Correcting selections that do not generate data 139 Chapter 8 Sorting, Grouping, and Totaling 141 8.1 14 8.1.1 Understanding sort options 8.12 Sorting single and multiple fields 8.1.3 Sort controls 145 8.2 Grouping data 147 8.2.1 Grouping data 147 8.2.2 Creating custom groups 8.2.3 Sorting groups conditionally 8.2.4 orting records within groups 151 8.2.5 Group selection 152 8.26 Grouping data in intervals 156 8.2.7 Grouping by the first letter of a company name 158 8.28 Grouping data hierarchically 8.29 Editing groups 165 2012-03-14 8.3 Summarizing grouped data To summarize grouped data 166 8.32 Ordering groups by summarized values 167 8.3.3 Selecting top or bottom n groups or percentages 168 8.3.4 Selecting top or bottom groups or percentages conditionally 170 8.4 Subtotaling 8.4.1 Subtotaling data 8.4.2 Extending prices and subtotaling the extensions 172 8.5 Percentages 1. 173 8.5.1 Calculating a percentage 174 8.6 troup headers 175 8.6.1 Creating group headers 175 8.6.2 Suppressing group headers 179 8.6.3 Drilling-down on group headers 179 Chapter 9 Running Totals,… 18 Understanding running totals 9.1.1 How running totals work 181 9.2 Creating running totals 182 9.2.1 Creating running totals in a list , 182 9.2.2 Creating running totals for a group 184 9.2.3 Creating conditional running totals 185 9.24 Creating running totals in a one-to-many linking relationship 187 9.3 Creating running totals using a formula 188 9.3.1 To create running totals using a formula 188 Chapter 10 Multiple Section Reports 191 10.1 About sections 10.2 Working with sections 10.2.1 Inserting a section 192 10.2.2 Deleting a section .192 10.2.3 Moving a section 193 10.2.4 Merging two related sections 193 10.3 pitting and resizing sections……… 194 10.3.1 Splitting a section 194 10.3.2 Resizing a section 195 104 Using multiple sections in reports 10.4.1 Keeping variable length objects from overwriting each other 196 10.4.2 Eliminating blank lines when fields are empty 197 10.4.3 Adding blank lines conditionally 198 2012-03-14 10.5 Form letters 198 10.5.1 Working with text objects 10.5.2 Creating a form letter using a text object 200 10.5.3 Printing conditional messages in form letters 205 Chapter 11 Formatting,… 207 11.1 Formatting concepts 207 11.2 Using a template 207 11.2.1 Applying a template 208 11.2.2 Removing an applied template 2 11.2.3 Reapplying the last template selected 209 11.24 Using Template Field Objects 210 11.2.5 Template considerations 211 11.3 Using the report Design Environment 213 11.3.1 Section characteristics 214 11.3.2 Making an object underlay a following section ..214 11.3.3 Pre-printed forr 216 11.3.4 Multiple columns 216 11.3.5 Hiding report sections 217 11.3.6 Hiding report objects , 218 11.3.7 Placing text-based objects 220 11.3.8 Placing multi-line, text-based objects 223 11.3.9 Importing text-based objects from a file 224 11.3.10 Spacing between text-based objects 225 11.3.11 To allow for overflow field representation 231 11.3.12 Selecting multiple objects 232 11.3.13 Vertical placement 233 11.3.14 nserting character and line spacing 233 11.3.15 Setting fractional font sizes 234 11.3.16 Setting page size and page orientation 235 11.3.17 Setting page margins 236 11.3.18 rue lyp 236 11.3.19 Printer drivers 237 11.3.20 Formatting a report for web viewing 238 11.4 Formatti operties 11.5 Working with absolute formatting 11.5.1 Adding borders, color, and shading to a field 239 11.5.2 Making a report section, area, or object read-only 240 11.53 Locking an object's size and position 241 11.5.4 nging y ur default field format 24 11.55 Adding and editing lines 243 2012-03-14 11.5.6 Adding and editing boxes 244 11.5.7 Expected behavior of line and box formatting 245 11.58 Adding shapes to a report 247 11.59 Scaling, cropping, and sizing objects 248 11.5.10 Using conventional accounting formats 249 11.5.11 Repeating report objects on horizontal pages 11.5.12 Using white space between rows 252 11.6 Working with conditional formatting 254 11.6.1 Conditional on or off properties 11.6.2 Conditional attribute properties 255 11.6.3 Changing margins conditionally 257 11.6.4 Changing X position conditionally 258 11.6.5 Creating footers after the first page 258 11.6.6 Using the Highlighting Expert 260 11.6.7 Undo/ Redo activities 263 11.7 Using the Format Painter 263 11.7.1 To copy and apply formatting .264 Working with barcod 265 11.8.1 Adding a barcode 265 11.8.2 Changing the appearance of a barcode 266 11.83 Removing a barcode 267 Chapter 12 Ing 269 12.1 Charting concepts 269 12.1.1 Charting overview 269 12.1.2 Chart layouts 270 12.1.3 rt type 271 12.14 Where to place a chart 273 12.1.5 Drill-down with charts 273 12.1.6 Drill-down with legends 273 12.2 Creating charts 274 12.2.1 Charting on details or formula fields(Advanced layout) 274 12.2.2 Charting on summary or subtotal fields(group layout) 275 12.23 Charting on Cross-Tab summaries(Cross-Tab layout) 276 12.2.4 Charting on an OLAP cube(OLAP layout 277 12.3 Working with charts 278 12.3.1 Editing charts using the Chart Expert 12.3.2 Editing charts using the Chart Options menu items. 278 12.3.3 Editing charts using other menu items 279 12.3.4 Using the zooming features with bar and line charts 12.3.5 Auto-arranging charts 281 2012-03-14 12.3.6 Formatting charts 282 12.3.7 Using the underlay feature with charts 283 Chapter 13 Mapping .285 13.1 Mapping concepts 285 13.1.1 Mapping overview 285 13.1.2 Map layouts 285 13.13 Map types 286 13.14 Where to place a map 288 13.1.5 Drill-down with maps 289 13.2 Creating maps 289 13.2.1 Mapping on group fields( Group layout 289 13.2.2 Mapping on Cross-Tab summaries( Cross-Tab layout) 290 13.23 Mapping on an olaP cube(olap layout 292 13.3 Working with map 293 13.3.1 Editing maps using the Map Expert 293 13.3.2 Changing the map tit 13.3.3 Changing the map type 294 13.34 g map layer 294 13.3.5 Resolving data mismatches , 296 13.36 Changing the geographic map 296 13.3.7 Zooming in and out on a map .297 13.3.8 ng a map 13.3.9 Centering a map ..298 13.3.10 Hiding and showing the map Navigator 298 13.3.11 Formatting Maps 13.3.12 To underlay a map Chapter 14 OLE 301 14.1 OLE 14.1.1 OlE terminglo 301 14.12 Types of Ole objects 302 14.13 General OlE considerati 302 14.2 nse OLE objec 14.2.1 To copy and paste Ole objects 14.3 How OLe objects are represented in a report 304 14.4 Editing OLE objects in reports 304 14.4.1 -place e 304 14.4.2 ynamic OLE menu comma 14.4.3 OLE and the Insert Picture command 305 2012-03-14

...展开详情
试读 127P Crystal report
立即下载
限时抽奖 低至0.43元/次
身份认证后 购VIP低至7折
一个资源只可评论一次,评论内容不能少于5个字
您会向同学/朋友/同事推荐我们的CSDN下载吗?
谢谢参与!您的真实评价是我们改进的动力~
关注 私信
上传资源赚钱or赚积分
最新推荐
Crystal report 9积分/C币 立即下载
1/127
Crystal report第1页
Crystal report第2页
Crystal report第3页
Crystal report第4页
Crystal report第5页
Crystal report第6页
Crystal report第7页
Crystal report第8页
Crystal report第9页
Crystal report第10页
Crystal report第11页
Crystal report第12页
Crystal report第13页
Crystal report第14页
Crystal report第15页
Crystal report第16页
Crystal report第17页
Crystal report第18页
Crystal report第19页
Crystal report第20页

试读结束, 可继续阅读

9积分/C币 立即下载