| |
| |
| Acknowledgments | |
| |
| |
| Introduction | |
| |
| |
| |
| Designing Reports | |
| |
| |
| |
| Getting the Feel of Crystal Reports 10 | |
| |
| |
| Introducing Crystal Reports 10 | |
| |
| |
| Using the Report Wizards | |
| |
| |
| Using the Blank Report Option | |
| |
| |
| The Report Explorer | |
| |
| |
| |
| Enhancing Appearance with Text Objects | |
| |
| |
| The Field Heading Text Object | |
| |
| |
| Combining Database Fields | |
| |
| |
| Combining Special Fields | |
| |
| |
| Formatting Individual Parts of Text Objects | |
| |
| |
| Importing Text from a File | |
| |
| |
| |
| Sorting and Grouping | |
| |
| |
| Sorting Your Report | |
| |
| |
| Grouping Records | |
| |
| |
| |
| Creating Geographic Maps | |
| |
| |
| Different Map Types | |
| |
| |
| Adding a Map | |
| |
| |
| Drilling Down on Maps | |
| |
| |
| Changing the Map View | |
| |
| |
| |
| Using Formulas | |
| |
| |
| The Formula Workshop | |
| |
| |
| The Formula Expert | |
| |
| |
| The Formula Editor | |
| |
| |
| Number Formulas | |
| |
| |
| String Formulas | |
| |
| |
| Date/Time Formulas | |
| |
| |
| If-Then-Else Formulas | |
| |
| |
| Other Crystal Reports Logic Constructs | |
| |
| |
| Boolean Formulas | |
| |
| |
| Variables in Formulas and Evaluation Times | |
| |
| |
| User Function Libraries | |
| |
| |
| Running Total Fields | |
| |
| |
| |
| Creating Custom Functions | |
| |
| |
| Custom Functions Defined | |
| |
| |
| Creating Your Own Custom Functions | |
| |
| |
| Sharing Custom Functions with Other Users | |
| |
| |
| Using Custom Functions in Your Formulas | |
| |
| |
| |
| The Repository | |
| |
| |
| The Repository Defined | |
| |
| |
| Adding To/Updating the Repository | |
| |
| |
| Adding Repository Items to Reports | |
| |
| |
| Changing Repository Items on Your Report | |
| |
| |
| Controlling Repository Rights | |
| |
| |
| Migrating a Version 9 Repository to Version 10 | |
| |
| |
| |
| Analyzing with Advanced Selection Criteria | |
| |
| |
| The Select Expert | |
| |
| |
| Manipulating the Record Selection Formula Directly | |
| |
| |
| Limiting Data with a Group Selection Formula | |
| |
| |
| Performance Considerations with Record Selection | |
| |
| |
| |
| Making Your Reports Visually Appealing | |
| |
| |
| General Formatting | |
| |
| |
| The Highlighting Expert | |
| |
| |
| Conditional Formatting Formulas | |
| |
| |
| Special Fonts, Graphics, and Line Drawing | |
| |
| |
| Text and Paragraph Formatting | |
| |
| |
| The Crystal Reports 10 Format Painter | |
| |
| |
| Report Alerts | |
| |
| |
| Crystal Reports Templates | |
| |
| |
| |
| Using Sections and Areas | |
| |
| |
| Formatting Sections with the Section Expert | |
| |
| |
| Creating Summary and Drill-Down Reports | |
| |
| |
| Multiple-Column Reports for Labels and Listings | |
| |
| |
| Using Multiple Sections | |
| |
| |
| Conditionally Suppressing Sections | |
| |
| |
| Underlaying Sections | |
| |
| |
| |
| Analyzing with Cross-Tabs | |
| |
| |
| Creating a Cross-Tab Object | |
| |
| |
| Multiple Rows, Columns, and Summarized Fields | |
| |
| |
| Customizing Cross-Tab Appearance | |
| |
| |
| |
| Creating Charts | |
| |
| |
| Types and Layouts of Charts | |
| |
| |
| Creating Charts with the Chart Expert | |
| |
| |
| Drilling Down on Charts | |
| |
| |
| Finer Points of Chart Formatting | |
| |
| |
| |
| Using Subreports | |
| |
| |
| Unlinked Subreports | |
| |
| |
| Linked Subreports | |
| |
| |
| Subreport Formatting with the Format Editor | |
| |
| |
| On-Demand Versus In-Place Subreports | |
| |
| |
| Passing Data Between Main Reports and Subreports | |
| |
| |
| Performance Considerations | |
| |
| |
| |
| Viewer Interaction with Parameter Fields | |
| |
| |
| Creating a Parameter Field | |
| |
| |
| Using Parameter Fields in Record Selection | |
| |
| |
| Displaying Parameter Fields on the Report | |
| |
| |
| Special Parameter Field Features | |
| |
| |
| Conditional Formatting with Parameter Fields | |
| |
| |
| Using Parameter Fields with Formulas | |
| |
| |
| |
| Exporting Reports | |
| |
| |
| Exporting Reports to Office Applications | |
| |
| |
| Sending Reports Electronically | |
| |
| |
| |
| Reporting from SQL Databases | |
| |
| |
| Logging On to SQL Databases | |
| |
| |
| Linking Tables | |
| |
| |
| Viewing the SQL Query | |
| |
| |
| Crystal Reports SQL Commands | |
| |
| |
| Using SQL Stored Procedures | |
| |
| |
| Using SQL Expression Fields | |
| |
| |
| Grouping on the Database Server | |
| |
| |
| Performance Considerations | |
| |
| |
| |
| Creating and Using Business Views | |
| |
| |
| Business Views Overview | |
| |
| |
| Creating Business Views | |
| |
| |
| Using Business Views with Crystal Reports | |
| |
| |
| |
| Accommodating Database Changes and Field Mapping | |
| |
| |
| Recognizing Database Changes | |
| |
| |
| Mapping Old Fields to New Names | |
| |
| |
| |
| Reporting from OLAP Cubes | |
| |
| |
| What Is OLAP? | |
| |
| |
| Crystal Reports OLAP Capabilities | |
| |
| |
| Using the OLAP Report Creation Wizard | |
| |
| |
| Adding an OLAP Grid to an Existing Report | |
| |
| |
| Changing the OLAP Database Location | |
| |
| |
| Controlling OLAP Grid Appearance | |
| |
| |
| Interacting with the OLAP Grid | |
| |
| |
| |
| Reporting from Proprietary Data Types | |
| |
| |
| Reporting from Microsoft Outlook | |
| |
| |
| Reporting from the File System Data | |
| |
| |
| Reporting from the Windows 2000/XP Event Log | |
| |
| |
| Reporting from Web Server Logs | |
| |
| |
| Crystal Reporting with XML | |
| |
| |
| Crystal Reports Custom Data Sources | |
| |
| |
| |
| Crystal Reports 10 on the Web | |
| |
| |
| |
| Crystal Reports Web Alternatives | |
| |
| |
| Crystal Reports Web Alternatives Compared | |
| |
| |
| Exporting to Static HTML | |
| |
| |
| Navigating and Viewing Report Parts | |
| |
| |
| |
| Crystal Reports with ASP and ASP.NET | |
| |
| |
| The Report Designer Component and Active Server Pages | |
| |
| |
| RDC Report Viewers | |
| |
| |
| Web Integration with CE Embedded Edition | |
| |
| |
| Web Integration with Visual Studio .NET and ASP.NET | |
| |
| |
| |
| Crystal Reports with Java | |
| |
| |
| The Java Viewer | |
| |
| |
| Pieces to the Puzzle | |
| |
| |
| Things You Can Do with the Java Viewer | |
| |
| |
| Let's Get Started | |
| |
| |
| The Java Viewer JSP Application | |
| |
| |
| Exporting Reports | |
| |
| |
| Report Part Viewer | |
| |
| |
| Interactive Viewer | |
| |
| |
| Grid Viewer | |
| |
| |
| Common Viewer Properties | |
| |
| |
| Crystal Enterprise Report Source | |
| |
| |
| Report Application Server (RAS) Report Source | |
| |
| |
| Best Practices | |
| |
| |
| |
| Introduction to Crystal Enterprise | |
| |
| |
| Crystal Enterprise Defined | |
| |
| |
| Crystal Enterprise Architecture | |
| |
| |
| |
| Using the Crystal Launchpad and Web Desktop | |
| |
| |
| Navigating the Crystal Enterprise Launchpad | |
| |
| |
| Connecting to the Web Desktop | |
| |
| |
| Folders, Objects, and Instances | |
| |
| |
| Controlling, Printing, and Exporting Reports | |
| |
| |
| Scheduling Objects | |
| |
| |
| Organizing the Web Desktop | |
| |
| |
| |
| Administering Crystal Enterprise | |
| |
| |
| Crystal Enterprise Architecture | |
| |
| |
| Managing Users and Groups | |
| |
| |
| Integrating CE with Existing Security Environments | |
| |
| |
| Controlling Access Using Rights | |
| |
| |
| Creating Folders and Adding Objects | |
| |
| |
| Defining Output Destinations | |
| |
| |
| Creating Calendars | |
| |
| |
| Using Events | |
| |
| |
| Enabling Auditing | |
| |
| |
| Configuring Success/Failure/Alert Notification | |
| |
| |
| Other General Administrative Tasks | |
| |
| |
| Managing Servers | |
| |
| |
| |
| Developing Custom Window Applications | |
| |
| |
| |
| Integrating Crystal Reports with Visual Basic | |
| |
| |
| Development-Language Options | |
| |
| |
| Different VB Reporting Options | |
| |
| |
| The Report Designer Component | |
| |
| |
| RDC Object Model Architecture | |
| |
| |
| Adding the RDC to Your Project | |
| |
| |
| The RDC Object Model | |
| |
| |
| An Introduction to the RDC Object Model | |
| |
| |
| Providing Database Login Credentials | |
| |
| |
| Controlling Record Selection | |
| |
| |
| Setting Formulas | |
| |
| |
| Changing Text Objects at Run Time | |
| |
| |
| Passing Parameter-Field Values | |
| |
| |
| Manipulating Report Groups | |
| |
| |
| Conditional Formatting and Formatting Sections | |
| |
| |
| Choosing Output Destinations | |
| |
| |
| Changing the Data Source at Run Time | |
| |
| |
| Customizing the Report Viewer | |
| |
| |
| Error Handling | |
| |
| |
| Other RDC Properties and Methods | |
| |
| |
| Creating New Reports at Run Time | |
| |
| |
| Distributing RDC Applications | |
| |
| |
| |
| Crystal Reports with Visual Studio .NET | |
| |
| |
| Crystal/VS.NET Bundle Options | |
| |
| |
| Windows Forms Viewer | |
| |
| |
| Integrated Report Designer | |
| |
| |
| VS.NET Report Customization Object Models | |
| |
| |
| Using Crystal Reports Web Services | |
| |
| |
| Index | |