Building Reports Using ASP.NET and Crystal Reports - Part 4: Dynamic Grouping
page 7 of 9
by Vince Varallo
Average Rating: 
Views (Total / Last 10 Days): 87754/ 211

Step 6: Create the Group

The groups must be defined in the Crystal Report at design time for you to manipulate them at run time. You can use any field to group by at design time because it will be overwritten at run time.

1.    Right click on any white space in the report. Click InsertàGroup from the pop-up menu.

2.    Select Address.City from the list and click the OK button.

Figure 5

3.    Right click on the LastName field in the Details section and select InsertàSummary from the pop-up menu.

4.    Change the "Calculate This Summary" drop down list to Count.

5.    Change the "Summary Location" drop down list to Group #1: Address.City - A.

Figure 6

6.    Click the OK button.

7.    This adds a count of the records based on Group 1. When you run the report you will see this number change as you change the group.

8.    Add a label to the left of the count field so the user will know what it refers to.

9.    To add the label you need to move the Count Field in the footer to the right by clicking and dragging it.

10. Right click to the left of the Count Field and select InsertàText Object from the pop-up menu.

11. Place the field to the left of the Count Field.

12. Enter "Count:" for the text and change the format to Bold.

Figure 7

13. Hide Section1, Section4, and Section5 by right clicking on the section header and selecting Suppress from the pop-up menu.

View Entire Article

User Comments

Title: CRystal REports Dynamically   
Name: Naresh
Date: 2012-12-07 11:48:18 PM
Title: t   
Name: n
Date: 2012-12-07 11:47:21 PM
Title: Another nice article   
Name: Rick
Date: 2009-12-01 4:02:34 PM
Easy to follow and godd explainations. Thanks for taking the time to put this article together. I have gone through the other 3 parts and really getting a better feel fot the reports
Title: ASP.NET Crystal Reports Hosting   
Name: Helen
Date: 2009-10-13 8:46:44 PM
I real like this article and I could learn more things about Crystal Reports

Title: Can anybody help me please?   
Name: Beto
Date: 2009-10-02 12:40:03 PM
What's up? I hope you help me... I want to have a report that has 3 pages per sheet... How can I do that? Thanks beforehand =)
Title: Very Nice Artical   
Name: Gaurav Gupta
Date: 2009-09-24 5:13:31 AM
Dear Vince Varallo

The article is really great.It is very useful to understand crystal report. And the way of communicating is also very simple.

Gaurav Gupta
Title: Problem   
Name: Pankaj Rai
Date: 2009-09-18 2:16:54 AM
Dear Vince Varallo,

I have to made a crystal report which show the sum of amount datewise. And also to display all the transaction on particular date when I click on date feild in crystal report.Is there any technique to pass date as parameter for subreport.Please reply ASAP.

Thanks in Advance.
Title: Really Nice Artical   
Name: Pankaj Rai
Date: 2009-09-18 2:13:10 AM
I have read this and learn something good regarding crystal report.

Title: Very Good   
Name: Edwin
Date: 2009-09-10 10:56:39 AM
I have been reading all the 4 parts and its very very usefull. Thanks a million. Just on more wish !!

VB code along with C# would have been amazing. Does your book has VB code as well as C#?

Product Spotlight
Product Spotlight 

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

©Copyright 1998-2018  |  Page Processed at 2018-04-25 8:33:04 AM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search