Using the Group Expert and Hierarchical Grouping in SAP Crystal Reports for Visual Studio 2010
page 1 of 4
Published: 26 Oct 2010
This article demonstrates the Group Expert and Hierarchical Grouping options using Crystal reports with the help of an ASP.NET web site that displays data from the AdventureWorks sample database. After a short introduction, Vince examines the creation of a new solution and report using simple grouping with relevant source code examples and screenshots.
by Vince Varallo
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 28556/ 56


One of the powerful features of Crystal Reports is the great amount of flexibility you have as a report developer in grouping your data.  Once you can group your data you can sum, count, average, perform standard deviation, variance, and a host of other operations on your data.  Grouping data in a SQL statement can be problematic because you can only include the fields you're grouping on in your select statement.  Crystal Reports does not have this limitation. 

Crystal also has a feature for hierarchy grouping for situations where you have nested groups and you don't know how many levels of grouping there are.  This article will show you how to create a report with simple grouping and summation fields and will also create a report using the hierarchy grouping feature. 

Before you begin you will need to have installed Visual Studio 2010. Crystal Reports is no longer distributed with Visual Studio and is available as a separate download. You can download Crystal Reports here. You also will need to download the AdventureWorks sample database from here.  Once you've installed the database you need to create a SQL Login that the application can use to connect to the database. My sample code expects a SQL Login to be called "aspalliance" and the password should be set to "aspalliance". The sample code for this application can be downloaded here.

View Entire Article

User Comments

No comments posted yet.

Product Spotlight
Product Spotlight 

Community Advice: ASP | SQL | XML | Regular Expressions | Windows

©Copyright 1998-2024  |  Page Processed at 2024-05-24 9:50:41 AM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search