+612 9045 4394
Crystal Reports 10 The Complete Reference : The Complete Reference - George Peck

Crystal Reports 10 The Complete Reference

The Complete Reference

Paperback Published: 9th July 2004
ISBN: 9780072231663
Number Of Pages: 960

Share This Book:


or 4 easy payments of $21.06 with Learn more
Ships in 7 to 10 business days

Produce winning presentations and reports with expert advice from this definitive guide. Discover vital tips on how to best utilize Crystal Reports' features to analyze data, and build professional, complex, and effective reports. Find the entire spectrum of user knowledge--from advice for new users on how to develop, design, and build a simple report, to in-depth information on complex features such as Crystal Server Pages and integrating Crystal Reports into Visual Basic.NET programs.

Acknowledgmentsp. xxiii
Introductionp. xxv
Designing Reports
Getting the Feel of Crystal Reports 10p. 3
Introducing Crystal Reports 10p. 4
Using the Report Wizardsp. 8
Using the Blank Report Optionp. 12
The Report Explorerp. 26
Enhancing Appearance with Text Objectsp. 29
The Field Heading Text Objectp. 30
Combining Database Fieldsp. 30
Combining Special Fieldsp. 32
Formatting Individual Parts of Text Objectsp. 35
Importing Text from a Filep. 36
Sorting and Groupingp. 37
Sorting Your Reportp. 37
Grouping Recordsp. 38
Creating Geographic Mapsp. 65
Different Map Typesp. 65
Adding a Mapp. 67
Drilling Down on Mapsp. 72
Changing the Map Viewp. 73
Using Formulasp. 79
The Formula Workshopp. 79
The Formula Expertp. 83
The Formula Editorp. 85
Number Formulasp. 98
String Formulasp. 101
Date/Time Formulasp. 108
If-Then-Else Formulasp. 111
Other Crystal Reports Logic Constructsp. 118
Boolean Formulasp. 122
Variables in Formulas and Evaluation Timesp. 124
User Function Librariesp. 135
Running Total Fieldsp. 136
Creating Custom Functionsp. 141
Custom Functions Definedp. 141
Creating Your Own Custom Functionsp. 143
Sharing Custom Functions with Other Usersp. 153
Using Custom Functions in Your Formulasp. 154
The Repositoryp. 157
The Repository Definedp. 157
Adding To/Updating the Repositoryp. 160
Adding Repository Items to Reportsp. 165
Changing Repository Items on Your Reportp. 167
Controlling Repository Rightsp. 169
Migrating a Version 9 Repository to Version 10p. 174
Analyzing with Advanced Selection Criteriap. 177
The Select Expertp. 177
Manipulating the Record Selection Formula Directlyp. 184
Limiting Data with a Group Selection Formulap. 186
Performance Considerations with Record Selectionp. 188
Making Your Reports Visually Appealingp. 191
General Formattingp. 191
The Highlighting Expertp. 194
Conditional Formatting Formulasp. 196
Special Fonts, Graphics, and Line Drawingp. 201
Text and Paragraph Formattingp. 206
The Crystal Reports 10 Format Painterp. 209
Report Alertsp. 210
Crystal Reports Templatesp. 213
Using Sections and Areasp. 219
Formatting Sections with the Section Expertp. 219
Creating Summary and Drill-Down Reportsp. 229
Multiple-Column Reports for Labels and Listingsp. 235
Using Multiple Sectionsp. 238
Conditionally Suppressing Sectionsp. 241
Underlaying Sectionsp. 243
Analyzing with Cross-Tabsp. 245
Creating a Cross-Tab Objectp. 247
Multiple Rows, Columns, and Summarized Fieldsp. 254
Customizing Cross-Tab Appearancep. 257
Creating Chartsp. 269
Types and Layouts of Chartsp. 269
Creating Charts with the Chart Expertp. 272
Drilling Down on Chartsp. 291
Finer Points of Chart Formattingp. 292
Using Subreportsp. 301
Unlinked Subreportsp. 302
Linked Subreportsp. 308
Subreport Formatting with the Format Editorp. 312
On-Demand Versus In-Place Subreportsp. 314
Passing Data Between Main Reports and Subreportsp. 316
Performance Considerationsp. 320
Viewer Interaction with Parameter Fieldsp. 321
Creating a Parameter Fieldp. 323
Using Parameter Fields in Record Selectionp. 333
Displaying Parameter Fields on the Reportp. 334
Special Parameter Field Featuresp. 334
Conditional Formatting with Parameter Fieldsp. 341
Using Parameter Fields with Formulasp. 343
Exporting Reportsp. 349
Exporting Reports to Office Applicationsp. 350
Sending Reports Electronicallyp. 361
Reporting from SQL Databasesp. 363
Logging On to SQL Databasesp. 364
Linking Tablesp. 375
Viewing the SQL Queryp. 388
Crystal Reports SQL Commandsp. 391
Using SQL Stored Proceduresp. 397
Using SQL Expression Fieldsp. 400
Grouping on the Database Serverp. 404
Performance Considerationsp. 408
Creating and Using Business Viewsp. 411
Business Views Overviewp. 411
Creating Business Viewsp. 413
Using Business Views with Crystal Reportsp. 481
Accommodating Database Changes and Field Mappingp. 489
Recognizing Database Changesp. 489
Mapping Old Fields to New Namesp. 495
Reporting from OLAP Cubesp. 499
What Is OLAP?p. 499
Crystal Reports OLAP Capabilitiesp. 501
Using the OLAP Report Creation Wizardp. 502
Adding an OLAP Grid to an Existing Reportp. 511
Changing the OLAP Database Locationp. 514
Controlling OLAP Grid Appearancep. 515
Interacting with the OLAP Gridp. 517
Reporting from Proprietary Data Typesp. 523
Reporting from Microsoft Outlookp. 526
Reporting from the File System Datap. 528
Reporting from the Windows 2000/XP Event Logp. 531
Reporting from Web Server Logsp. 534
Crystal Reporting with XMLp. 537
Crystal Reports Custom Data Sourcesp. 541
Crystal Reports 10 on the Web
Crystal Reports Web Alternativesp. 547
Crystal Reports Web Alternatives Comparedp. 549
Exporting to Static HTMLp. 551
Navigating and Viewing Report Partsp. 558
Crystal Reports with ASP and ASP.NETp. 567
The Report Designer Component and Active Server Pagesp. 568
RDC Report Viewersp. 573
Web Integration with CE Embedded Editionp. 577
Web Integration with Visual Studio .NET and ASP.NETp. 599
Crystal Reports with Javap. 635
The Java Viewerp. 635
Pieces to the Puzzlep. 636
Things You Can Do with the Java Viewerp. 636
Let's Get Startedp. 637
The Java Viewer JSP Applicationp. 638
Exporting Reportsp. 640
Report Part Viewerp. 643
Interactive Viewerp. 648
Grid Viewerp. 650
Common Viewer Propertiesp. 652
Crystal Enterprise Report Sourcep. 655
Report Application Server (RAS) Report Sourcep. 657
Best Practicesp. 659
Introduction to Crystal Enterprisep. 661
Crystal Enterprise Definedp. 661
Crystal Enterprise Architecturep. 670
Using the Crystal Launchpad and Web Desktopp. 677
Navigating the Crystal Enterprise Launchpadp. 677
Connecting to the Web Desktopp. 679
Folders, Objects, and Instancesp. 683
Controlling, Printing, and Exporting Reportsp. 693
Scheduling Objectsp. 701
Organizing the Web Desktopp. 713
Administering Crystal Enterprisep. 719
Crystal Enterprise Architecturep. 719
Managing Users and Groupsp. 727
Integrating CE with Existing Security Environmentsp. 740
Controlling Access Using Rightsp. 745
Creating Folders and Adding Objectsp. 750
Defining Output Destinationsp. 765
Creating Calendarsp. 769
Using Eventsp. 770
Enabling Auditingp. 776
Configuring Success/Failure/Alert Notificationp. 780
Other General Administrative Tasksp. 785
Managing Serversp. 791
Developing Custom Window Applications
Integrating Crystal Reports with Visual Basicp. 807
Development-Language Optionsp. 808
Different VB Reporting Optionsp. 809
The Report Designer Componentp. 810
RDC Object Model Architecturep. 811
Adding the RDC to Your Projectp. 817
The RDC Object Modelp. 825
An Introduction to the RDC Object Modelp. 828
Providing Database Login Credentialsp. 831
Controlling Record Selectionp. 832
Setting Formulasp. 834
Changing Text Objects at Run Timep. 836
Passing Parameter-Field Valuesp. 837
Manipulating Report Groupsp. 838
Conditional Formatting and Formatting Sectionsp. 840
Choosing Output Destinationsp. 845
Changing the Data Source at Run Timep. 846
Customizing the Report Viewerp. 850
Error Handlingp. 856
Other RDC Properties and Methodsp. 856
Creating New Reports at Run Timep. 861
Distributing RDC Applicationsp. 871
Crystal Reports with Visual Studio .NETp. 877
Crystal/VS.NET Bundle Optionsp. 877
Windows Forms Viewerp. 880
Integrated Report Designerp. 884
VS.NET Report Customization Object Modelsp. 892
Using Crystal Reports Web Servicesp. 904
Indexp. 911
Table of Contents provided by Ingram. All Rights Reserved.

ISBN: 9780072231663
ISBN-10: 0072231661
Series: Complete Reference Series
Audience: Professional
Format: Paperback
Language: English
Number Of Pages: 960
Published: 9th July 2004
Publisher: McGraw-Hill Education - Europe
Country of Publication: US
Dimensions (cm): 24.1 x 19.7  x 5.7
Weight (kg): 1.58
Edition Number: 1