Link to home
Start Free TrialLog in
Avatar of nobile00
nobile00

asked on

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.
Avatar of nobile00
nobile00

ASKER

Any help will be very appreciated.

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

Thanks
Avatar of Mike McCracken
How are you generating the values?

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

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

Thanks for your help
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
Thanks I did that.

Just one question will this hold true if more columns are added to the database?  
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
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?
ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks that worked!