--- title: "Group Name Field in Crystal Report" description: "Group Name Field in Crystal ReportThe group is a set of records that are related to each other in some way. For instance, you might group together a" author: "Chris Anderson" published: 2011-08-24 updated: 2020-03-04 canonical: https://www.mindstick.com/articles/613/group-name-field-in-crystal-report category: "crystal report" tags: ["crystal report"] reading_time: 2 minutes --- # Group Name Field in Crystal Report ## Group Name Field in Crystal Report The group is a set of records that are related to each other in some way. For instance, you might group together all of your [employees](https://yourviews.mindstick.com/view/81150/corona-lockdown-let-s-worry-for-employees) in the same Zone. The Group Name field is created when you insert a group into your report. Today, I [am trying](https://answers.mindstick.com/qa/36834/which-two-programming-languages-should-i-master-in-if-i-am-trying-to-get-into-google-or-facebook) to explain how to group the data in [crystal report](https://www.mindstick.com/articles/930/crystal-report-in-visual-studio-2010) by using Group Name Field in [Visual studio](https://www.mindstick.com/articles/12378/visual-studio-for-mac-is-out-of-beta-preview-now-officially-available) 2010. \ \ ![Group Name Field in Crystal Report](https://www.mindstick.com/mindstickarticle/a2007ba0-3c74-49b7-9152-3373c18f9e1f/images/36acc0e0-662c-41c0-b8a7-b20ee3b86c8d.png) After creating a report, right-click on the **Group Name** Fields option in the Field Explorer and select Group Expert option. ![Group Name Field in Crystal Report](https://www.mindstick.com/mindstickarticle/a2007ba0-3c74-49b7-9152-3373c18f9e1f/images/4427eb31-0a02-4c0f-ab67-8dbab1cdd39d.png) As you select Group Expert option from Group Name Field, Group Expert [Dialog Box](https://www.mindstick.com/blog/157/dialog-box-in-dot-net) will open. After that select the field name from the object of the database and add it into Group By list and click Ok button to close the current window. ![Group Name Field in Crystal Report](https://www.mindstick.com/mindstickarticle/a2007ba0-3c74-49b7-9152-3373c18f9e1f/images/b43fa421-4ec4-4a01-b5f4-5fef2f39f185.png) After selecting a field, the group name is automatically added into the group section of the Crystal Report and a field also added in the Group Name Fields. \ You can format the report by yourself as I here change the back color of the group name and also change the text and font of Page Header fields from the **[Properties](https://yourviews.mindstick.com/view/81845/now-it-s-possible-to-predict-properties-of-any-molecule)** window. ![Group Name Field in Crystal Report](https://www.mindstick.com/mindstickarticle/a2007ba0-3c74-49b7-9152-3373c18f9e1f/images/63b7c410-4451-40b5-a51a-4b251ac64aa5.png) You can see the output or preview of a report from **Main Report Preview** or run an application.\ After that, I also use a [formula field](https://answers.mindstick.com/qa/34177/what-is-a-formula-field-in-salesforce) to display the age of the employee, for that, I had used a date_different function because I have columns employee_DOB(date-of-birth), employee_joining (joining date) and on the basis of that columns I can find the [difference](https://www.mindstick.com/articles/157114/good-news-or-bad-news-and-the-difference-is) of a year or employee age. ![Group Name Field in Crystal Report](https://www.mindstick.com/mindstickarticle/a2007ba0-3c74-49b7-9152-3373c18f9e1f/images/dfaabbd3-c8b3-41ef-b53a-2f5f962c1e83.png) After that, you have to drag the formula (age) from the Formula Fields into the crystal report. ![Group Name Field in Crystal Report](https://www.mindstick.com/mindstickarticle/a2007ba0-3c74-49b7-9152-3373c18f9e1f/images/4bbb9abe-243b-4c14-b980-5e75e15de9f3.png) If you see the preview of the report it displays the age in decimal floating-point so in order to change the format right-click on the formula field in the crystal report and change the format according to you. ![Group Name Field in Crystal Report](https://www.mindstick.com/mindstickarticle/a2007ba0-3c74-49b7-9152-3373c18f9e1f/images/fbe6c979-186c-4dfe-8dff-5535b8c155a3.png) ![Group Name Field in Crystal Report](https://www.mindstick.com/mindstickarticle/a2007ba0-3c74-49b7-9152-3373c18f9e1f/images/b2d60345-4a14-4379-ab31-ef73e74618e8.png) Now if you see the report it will display the age in the [correct format](https://www.mindstick.com/forum/72/input-string-was-not-in-a-correct-format). \ you should read also this Article - **[Non-Blocking Synchronization in C#](https://www.mindstick.com/Articles/11984/non-blocking-synchronization-in-c-sharp)** --- Original Source: https://www.mindstick.com/articles/613/group-name-field-in-crystal-report Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.