Group Descriptions 2

[YANKRAY]

Crystal Reports 10.0

When Crystal Reports Groups, the Group Title is shown on the left hand side for easier drill down.

Can the description of these titles be changed?

Example:

I have work flow grouped using a sort sequence number so I have control within may database on how the work flow is shown.

Seq Title
100 = Recieve
110 = Teardown
115 = Inspect
120 = Repair
130 = Reassemble

When the grouping takes place The correct sequence is visible but the grouping on the left shows the seq number (which is the proper grouping).

This does not have much meaning for the user. Is there a way to show the Title instead of the sequence number on the left hand side so the user will know what they are drilling down to?

Thanks,
Ray

 

[Madawc]

You could create a formula field that converts them, e.g.

if {seq} = 100 then "a) Recieve"
else if {seq} = 110 then "b) Teardown"
....

Use this field for grouping. I make them (a), (b) etc. because I assume you want to keep the sequence.

It might also be wise to end with a catch-all, else "z) Unknown " & {seq}


Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP

 

[YANKRAY]

The sequence number could have a different title over a different program. The idea is sound if I concantenate the seq# and the title then sort by that.

Thanks,
Ray

 

[TeyBrady]

You can group on the ID and then change the group to display the title.

To change what is displayed you can:
Right click on the group and select change group.
Go to the options tab
Click customize group
Select title for the field

You can also do a custom description using "Use a formula for group name."

 

[YANKRAY]

TeyBrady,

That is perfect. I will use this often now that I know.

Thanks!
Ray