Friday, February 24, 2012

Crystal Reports : Using a Custom Group Name

Did you know that you can specify a "Custom" Group name? A typical situation is that you'll be grouping on a "system" field, like GoldMine's RECID, which looks like this;

G1YSRY0)\Z.BM-/

This is usually done when you need to Group by unique values, and grouping on (for example) Company Name won't work as there could be several "ACME"'s in your database. But you'll want something that readable on your report, instead of the RECID.

You can customize what's displayed as the Group Name by;

1. Select Report | Change Group Expert from the top level menu

2. Select the Group you wish to modify, click Options

3. Check the box labeled "Customize Group Name Field"

4. You can either "Choose from existing field" or "Use a formula as Group Name"

Note that after this is done; your Group Name field is now how you want it, yet the Group itself is still broken on the original unique value.

9 comments:

Anonymous said...

Very nice article!!! you made it very simple and understandable, thanks for sharing with us. Check out this articles too its also explained very well about Group name field in crystal report.....
http://www.mindstick.com/Articles/a2007ba0-3c74-49b7-9152-3373c18f9e1f/?Group%20Name%20Field%20in%20Crystal%20Report

http://www.codeproject.com/Questions/155732/I-need-to-use-Group-name-Field-In-my-Crystal-repor

Patricia Pabustan said...

This is very fine. Thanks.........

Crystal Custom

Dhiman Sarkar said...

This is very nice..

Sanjida Akhter said...

This blog is very nice. I am very happy to read this

Crystal Custom

jannati jahan said...

Take introductory programming classes at a college or extension college offering C#.

http://www.dotnetobject.com/

amar jan said...

If the database you are using supports a query language such as SQL, you can write your own command which will be represented in Crystal Reports as a Table object

Crystal Custom

Nomita Biswas said...

An alternating voltage applied to these electrodes causes the quartz to vibrate, or oscillate, at a particular frequency.

Crystal Custom

Dharmendro Bhuyan said...

Meanwhile, Feng SHui experts recommend turquoise to people who are experiencing trouble in their relationship because it is said that the promotes good communication.

Crystal Custom

productsb softsolutions limited said...

All facets and tables are machine cut and polished to give to the crystal rhinestone a sharp and shiny finish incrementing its index of refraction which is the way light reflects trough the faces of the crystal for more beauty.

Promotional Sunglasses