Crystal Reports CrossTab Sorting Columns

I have a crosstab that I need to sort the columns so that the "Other" column is a always last.  Does anyone know if or how I can do this?

Any help will be greatly appreciated.
nobile00Asked:
Who is Participating?
 
mlmccConnect With a Mentor Commented:
Not that I am aware of.

How are you getting the OTHERS column?

Is OTHERS a valid data entry?
If so you could use a formula like

IF {GroupField} = 'Others' then
    'ZZZZZZZZOthers'
else
    {GroupField}

Use that field in the grouping of the crosstab
Modify the group
On the second tab use the field itself for the column header.

mlmcc
0
 
nobile00Author Commented:
Any help will be very appreciated.

Thanks in advance.
0
 
nobile00Author Commented:
If anyone could let me know if this can be done and if so how.

Thanks
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
mlmccCommented:
How are you generating the values?

One way is to use a group and sort the group in specified order

mlmcc
0
 
nobile00Author Commented:
How do I group and sort by specified order?  The values are coming from a View.

Thanks for your help
0
 
mlmccCommented:
Right click the cross tab in the left corner
Click CROSS TAB EXPERT
Select the ROW field
Click the CHANGE GROUP
You should be able to set the order

mlmcc
0
 
nobile00Author Commented:
Thanks I did that.

Just one question will this hold true if more columns are added to the database?  
0
 
mlmccCommented:
What do you mean more columns?

If you are adding more values for the row then you will need to change the specified order to include the new values.

mlmcc
0
 
nobile00Author Commented:
If more data is added to the database.

Is there then another way to do this so that the report doen't need to updated all of the time?
0
 
nobile00Author Commented:
Thanks that worked!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.