Building Reports using ASP.NET and Crystal Reports - Part 7 Using Subreports to Create Advanced Reports
page 4 of 7
by Vince Varallo
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 34334/ 69

Step 3: Create a Group in the Report

This report will display each SalesOrderHeader record and list the SalesOrderDetail records associated with the SalesOrderID.  The report will be grouped by the SalesOrderID field and the subreport will retrieve the corresponding records from the AdventureWorks.SalesOrderDetail table.  This step will add a group to the report by SalesOrderID.

1.    From the main menu select Crystal Reports -> Insert -> Group.

2.    Choose SalesOrderID from the drop down list.

3.    Click the OK button.

The report will now have two sections added, GroupHeaderSection1 and GroupFooterSection1.  Crystal Reports will automatically add the "Group #1 Name" field to the header.  For this report, the SalesOrderID will print in the group header section.

You can click the Main Report Preview button at the bottom of the screen to view the SalesOrderID records that are in this database.  As you can see, there is much less data in the AdventureWorksLT database than there is in the AdventureWorks database.

View Entire Article

User Comments

Title: Crystal Report   
Name: B.Shah
Date: 2010-09-21 6:43:53 AM
Nice Article..Thanks
Title: Donor Database Administrator   
Name: Abdillahi Jibril
Date: 2010-01-27 11:00:37 AM
I have medium to advanced level experience in Crystal Report, and your article helps me improve my skills to be better Crystal Report Developer.
Title: crystal reports   
Name: joohitha
Date: 2010-01-05 11:47:19 PM
nice article

Tks vincey
Title: crystal reports tutor   
Name: lokesh
Date: 2009-12-28 5:02:03 AM
Thanks vincey
very nice and very help full for crystal report beginners.
i will be at

Product Spotlight
Product Spotlight 

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

©Copyright 1998-2024  |  Page Processed at 2024-05-25 10:52:27 PM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search