Pro VS 2005 Reporting using SQL Server and Crystal Reports
- 5h 54m
- Kevin S. Goff, Rod Paddock
- Apress
- 2006
Pro VS 2005 Reporting Using SQL Server and Crystal Reports offers a proven methodology for building reporting solutions. The authors focus on SQL Server 2005 and Crystal Reports, but also cover other popular technologies like Oracle and ActiveReports, to give you a thorough grounding in the reporting field. The book presents the requirements for a real-world reporting application in a distributed environment, and covers all the phases of development. You’ll learn to
- Define report content, format, definitions, and rules.
- Establish data requirements.
- Build and test stored procedures.
- Construct a data access layer in .NET.
- Account for different architectures using XML web services and .NET Remoting.
- Design the reports using Crystal Reports.
- Develop a Windows Forms client application to allow users to launch reports and set report options.
- Export report output to other sources such as PowerPoint.
In many business applications, reports play a critical role. The stakeholders of a software system expect reports to summarize data and efficiently present it to business users and decision markers. They expect reports to present data in ways they can easily interpret, and in ways that help them evaluate and analyze business performance. Visual Studio 2005, SQL Server 2005, and Crystal Reports contain powerful capabilities to help you build and deliver sophisticated presentation output. This is the only book available that shows you how to use all these disparate technologies together to create a cohesive solution.
About the Authors
Kevin S. Goff is the author of CoDe magazine’s The Baker’s Dozen series. He selects a development topic each month and writes 13 productivity tips. Most topics cover .NET in some manner. In late 2004, he wrote an article on productivity tips for Crystal Reports in .NET, a subject close to his heart. The article discussed reporting for line-of-business applications, and focused on producing efficient, effective results. The article caught the attention of many people and organizations, and he’s been talking to people and building up the ideas for this book ever since.
Rod Paddock is the editor of CoDe magazine. CoDe is well known in the development community, and is on an aggressive path to grow into being the number one Microsoft development community magazine resource.
In this Book
-
Defining the Requirements
-
Generating Result Sets with T-SQL 2005 Stored Procedures and UDFs
-
More T-SQL 2005 Stored Procedures
-
Building Remoting/Web Service Solutions with Interfaces
-
Building a Data Access Layer
-
Using Strongly-Typed DataSets
-
Middleware Data Summarization Using Typed DataSets
-
Basic/Intermediate Report Design with Crystal Reports
-
Advanced Report Design with Crystal Reports
-
Using ActiveReports for .NET
-
Using Microsoft SQL Server Reporting Services
-
Integrating the Reporting Tool with the Application
-
Constructing the User Interface
-
Building Report Output Using Microsoft PowerPoint
