Group Tree Question

[CrystalUser1]

Hi,

I am using crystal reports 9.0. I have a report which has is based on the following table:

Table Name Purchase:

Fields are as follows:


ID Name Order Total Amount

1 LC1 Direct 1000
2 LC2 Direct 2000
3 LC Direct 3000
4 LC3 Channel 6000

The report is grouped on Name field. The group tree is showing like this:

LC
LC1
LC2
Lc3

I want to display the group tree (not group name) as follows:

LC
LC
LC
LC
instead of

LC
Lc1
LC2
Lc3

But I would like the 4 sets of data based on the above group. Is it possible?

thanks in advance.

 

[Turkbear]

Hi,
The Group Tree uses the Group Name so they must be the same..You can change the Name of the Group without changing the data field it is based on so you can still group by the original data fields but show LC .( this will defeat the purpose of the tree, however, which is to allow quick navigation to a particular group..with all named the same, how can you tell which you want?)







To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[Madawc]

You can put your own names on the report, but the group tree shows the name of the group, whatever it is.

You might convert it using a formula field and having a different number of trailing spaces. E.g.

if {your.Name} = "LC" then "LC"
else if {your.Name} = "LC1" then "LC "
else if {your.Name} = "LC2" then "LC  "
else if {your.Name} = "LC3" then "LC   "
else "Out of range"

Group using this formula field rather than the group itself.

Madawc Williams (East Anglia, UK)