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.
Any help will be greatly appreciated.
ASKER
If anyone could let me know if this can be done and if so how.
Thanks
Thanks
How are you generating the values?
One way is to use a group and sort the group in specified order
mlmcc
One way is to use a group and sort the group in specified order
mlmcc
ASKER
How do I group and sort by specified order? The values are coming from a View.
Thanks for your help
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
Click CROSS TAB EXPERT
Select the ROW field
Click the CHANGE GROUP
You should be able to set the order
mlmcc
ASKER
Thanks I did that.
Just one question will this hold true if more columns are added to the database?
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 you are adding more values for the row then you will need to change the specified order to include the new values.
mlmcc
ASKER
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?
Is there then another way to do this so that the report doen't need to updated all of the time?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks that worked!
ASKER
Thanks in advance.