I wrote this book from the perspective of a programmer wanting to learn how to integrate reports within a .NET application. I've been working with Crystal Reports since Visual Basic 3 and it's always been difficult to find technical information on report writing. I spent a year and a half researching what .NET programmers need to successfully create, implement and deploy a Crystal Reports application. I even put the book on the internet for everyone to read for free all of last year. This generated an incredible number of emails from programmers telling me what they liked, disliked, and what was missing from the book. I learned that there are two distinct types of .NET programmers using Crystal Reports. The first type of programmer doesn't have much experience with Crystal Reports and wants a series of tutorials to help them build reports from scratch. For this programmer I wrote 13 chapters which teach you everything about adding reports to ASP.NET and Windows applications. It starts with the basics of building reports to adding charts, crosstab reports, sorting and grouping, subreports and using the formula editor with Basic syntax and Crystal syntax. The second type of programmer has been using Crystal Reports for years and is mostly concerned with how to do technical runtime customization of reports. For this programmer I researched and diagrammed the undocumented report object models. I included dozens of examples in both VB.NET and C# to show you how to modify reports, manipulate different data sources (XML, ADO.NET, ODBC, OLE DB, stored procedures with parameters), modify formulas and report parameters, and integrate .NET with the RAS and RDC. The dozens of emails I received when the book was online were instrumental for doing a major revision of many chapters before publishing the book in hardcopy format. Since releasing the book I continue to receive more emails from people. They regret that the free book isn't online anymore, but understand that it couldn't last forever and that the hardcopy version is even better. I hope you like it and that it helps you achieve your reporting goals. September 2004 Update: Due to high demand, I did a second printing of the book. I took advantage of this opportunity to go through the book and remove all grammatical errors. The content is the same, but the typos have been corrected.

Written with experienced .NET programmers in mind, this volume provides in-depth information for integrating Crystal Reports into various applications, fully maps out the Crystal Reports object model, and enables developers to create windows, Web, and enterprise-level reporting solutions. Featuring code samples that can be copied and pasted into the reader's own applications, this manual explores all platforms and programming languages. Completely examining the latest VS.NET 2005 version of the software, this edition is updated with detailed tutorials on every aspect of the program to speed users through the process of creating reports.

What is this book about? The addition of Crystal Reports 9.0 to Visual Studio .NET 2003 offers developers a reporting tool that allows you to turn almost any data into interactive, dynamic content through portals, wireless devices, and Microsoft Office documents. This code-intensive guide takes you step by step through developing reports and incorporating them into applications. First, you gain a thorough understanding of how this version of Crystal Reports differs from previous versions and how it fits into the .NET platform. Then you begin creating reports and learn how to integrate them into both Windows and Web-based applications. You explore XML Web services, find out how to work with ADO.NET, and learn to use formulas and logic in your reports. Finally, you develop distributed reporting applications and discover how to deploy the applications you have created. Packed with real-world examples of working applications, this comprehensive second edition provides a complete understanding of commonly used features, examples of integration with a variety of databases and platforms, and much more. What does this book cover? Here are some details on what you'll discover in this book: Advanced report design Methods for creating reports using the Expert How to integrate reports into Windows and Web-based applications Development and deployment of distributed reporting applications How to create XML Report Web Services and work with ADO.NET Tips for using parameters with Crystal Reports and customizing the report content at run-time Options for working with different data sources How to use the features contained in the properties, methods, and events associated with the Crystal Reports engine Who is this book for? This book is for programmers seeking a comprehensive guide to the functionality of Crystal Reports for Visual Studio .NET. You should have some experience with .NET and Visual Studio .NET. Some familiarity with Crystal Reports is helpful, although this update includes a large section on report design.

Written for experienced Visual Basic programmers, this guide introduces database programming using the classes, properties, methods, and events of the ADO.NET data access method. The authors explain how to use typed and untyped datasets with bound and unbound controls, work with data commands direct

This book is a complete reference for using and developing with Crystal Reports, and teaches all of the basics, as well as teach how to integrate Crystal Reports with key development languages and the use of web reporting. It gives readers a complete reference book that has been unavailable in the marketplace to date.

This book provides a step-by-step guide for developing an ASP.NET 3.5 application using the latest features in Visual Studio 2008. The Problem Design Solution series by Wrox is unique because it describes a large case study and builds an entire solution chapter by chapter for each incremental step. This book uses a wide variety of new features in Visual Studio 2008, explains each in detail, and produces a solution that you can use as a starting point for your own applications. If you are responsible for designing or developing enterprise-wide applications, departmental applications, portals, or any line of business application, then this book is for you. Many applications have a similar set of features, and this book builds an application with some of the most common features of enterprise applications. Let’s face it: Every application has the same general set of features, but implemented in a different way. A database sits in the back end and you, as the developer, are responsible for enabling users to add, update, select, and delete records. If only it were that simple, no? The real development work starts when you sit with users and try to understand the business process and why they need a new or improved system in the first place. A lot of companies have departments that use Excel and Access wizards to create small systems that eventually become a lifeline for some part of the business. Usually something bad happens because of the nature of the tool they are using. Senior-level management is called in, project managers are hired, programmers are contracted, and the Project Management Office (PMO) is called to save the world. Suddenly this loosely defined process is high priority and people want documented standard operating procedures, audit reports, more productivity, less people, and of course a system that can do it all, which is where you come in. When you think about it, it’s a pretty daunting task. You’re expected to become an expert in someone else’s business process, flaws and all, and create a system that the company will rely on as the backbone for their existence. OK, maybe I’m exaggerating just a little bit, but when you go looking for that raise you might want to phrase it that way. This book will give you the tools necessary to build a framework that can be extended to create a solution to solve your company’s problems. The design pattern uses the normal three layers, the user interface (UI), the business logic layer (BLL), and the data access layer (DAL), but also builds the classes in each layer that encapsulate common business rules such as role-based security, workflow, reporting, dynamic menus, data entry, dynamic querying, notifications, exception handling, and auditing. As the book guides you through the complete solution, each business requirement is thoroughly examined and some of the latest enhancements in ASP.NET 3.5 and Visual Studio 2008 are used to implement them in a reusable framework. Enterprise applications are typically complex, and the teams that build enterprise applications come in all shapes and sizes. Some of the roles include a project sponsor, a project manager, business analysts, an architect, UI developers, middle-tier developers, database developers, and, if you’re really lucky, testers. Just a side note: Users are not testers. If you ever have the pleasure of working with professional testers, you’ll realize how important they are in the process, and how they truly are “quality” assurance engineers. Unfortunately, a lot of companies aren’t willing to invest in professional testers, so the users and/or developers end up assuming that role. This book is mainly focused on the architect and developers, but testers may find it valuable as well to help them understand the plumbing that goes into developing and architecting an enterprise application. This book is for the intermediate to senior level developer or system architect. It would be helpful if you have experience with Visual Studio, the .NET Framework, ASP.NET, and C# because that is what the samples are written in, but the design pattern could be used in any language. The book is focused on enterprise applications, but the pattern could be used for any type of application that has a web front end and connects to a database. The application framework built in this book provides a foundation that can be extended to meet the specific business needs of your organization. The sample application in this book is built using Visual Studio 2008, ASP.NET 3.5, C#, and SQL Server 2005. Each chapter goes into great detail, with plenty of code samples, and uses some of the new features in Visual Studio 2008 and the language enhancements in the .NET Framework 3.5. The solution includes examples for technologies such as LINQ to SQL, master pages, custom controls, GridViews, business objects, data objects, and Crystal Reports. Some of the language enhancements discussed include LINQ, extension methods, partial methods, automatic properties, anonymous types, lambda expressions, and object initializers. Of course, I realize that the code is what most developers are interested in, and each chapter provides numerous examples. The Problem Design Solution series is just that. Each chapter has three sections with a description of the problem to be addressed, the design considerations for choosing a solution for the problem, and the solution that ultimately addresses the problem. The solution includes the bulk of the code. Each chapter builds upon the previous chapter, and it is recommended that you read them in order. The base classes that are described in the first few chapters are critical to an understanding of the rest of the book. Later chapters build upon the base classes and extend their functionality in all three layers of the application.

Crystal Reports is a powerful reporting tool that can seamlessly integrate into your application. In Crystal Reports Application Development, Craig Berntson shows you how to take advantage of the RDC so you can provide your users with printing, previewing, and report design capabilities. You'll also learn how to determine which components to distribute and how to troubleshoot problems when they occur on the user's computer. If you're developing reporting tools with Crystal Reports, this is a must have book.