alakhan
asked on
Is it possible to change group name in drill-down tree of crystal report:
There is a crystal report of 8.0 ver.
There are three catogries on it:
The third category is catogories like contractor, sub contractor, internal shop etc.
Each catagory is associated with letter like A, B, C etc:
A: sub-contractor
B: internal shop
C: contractor
both values are in same table and are comming in crystal report:
I want to sort the catogry by letter that is sub-contractor should comes first then internal shop and then contractor and so on:
But I dont want to display letter A, b, c etc.
is it possible that I make a farmula field and join both fields and sort them but when they are going display, I just display catagory ? On right hand side in main window it is possible but I want on left hand side in the tree: or any other solution to sort them like this:
Thanks for reading .
There are three catogries on it:
The third category is catogories like contractor, sub contractor, internal shop etc.
Each catagory is associated with letter like A, B, C etc:
A: sub-contractor
B: internal shop
C: contractor
both values are in same table and are comming in crystal report:
I want to sort the catogry by letter that is sub-contractor should comes first then internal shop and then contractor and so on:
But I dont want to display letter A, b, c etc.
is it possible that I make a farmula field and join both fields and sort them but when they are going display, I just display catagory ? On right hand side in main window it is possible but I want on left hand side in the tree: or any other solution to sort them like this:
Thanks for reading .
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The easiest solution is the one that ebolek eluded to first.
In the Group Expert, there is a check box called "Customize Group Name".
Once you select that, 2 other options are enabled.
Select the radio button for "Choose from existing field" and select your category description.
This will show the category desciption in the Group Tree and in the Group Name field on teh actual report.
In the Group Expert, there is a check box called "Customize Group Name".
Once you select that, 2 other options are enabled.
Select the radio button for "Choose from existing field" and select your category description.
This will show the category desciption in the Group Tree and in the Group Name field on teh actual report.
2. go to the specified order tab and in the Named Group dropdown select A
3. click the edit button and in Group Name enter sub-contractor and click ok
repeat steps 2 and 3 for each of your groups.
Gary