Sorting one column using another column
3 October, 2013
I have the following problem:
We have 2 columns A and B, A its a sequence of numbers that show how to sort column B. We want to sort B using A, but without showing A.
The first aproximation to create something like that is:
create report, put fields A and B. We sort by A and hidden.
Now the report is sorted by A, but the problem is if the user clicks in B this field will be sorted by B and not by A.
I will put an example to explain better
Column A Column B
1 T
2 Z
3 A
We are sorting the report using criteria from column A, now we have hidden A. Now the user if sort by column B, the result will be
Column B
A
T
Z
One solution it can be using Org Ref Code, but exists a manner to do that?
Thanks
We have 2 columns A and B, A its a sequence of numbers that show how to sort column B. We want to sort B using A, but without showing A.
The first aproximation to create something like that is:
create report, put fields A and B. We sort by A and hidden.
Now the report is sorted by A, but the problem is if the user clicks in B this field will be sorted by B and not by A.
I will put an example to explain better
Column A Column B
1 T
2 Z
3 A
We are sorting the report using criteria from column A, now we have hidden A. Now the user if sort by column B, the result will be
Column B
A
T
Z
One solution it can be using Org Ref Code, but exists a manner to do that?
Thanks
Hi Jordi,
There is only one way to get what you were after, which is what you're currently doing.
Having Column A apply the sorting, then hiding the column.
The issue with this is that in your setup, it's still allowing users to modify the sort order of Column B. But there is an easy way around this.
At the view level, disable sorting for Column B:
Then in the report they will see this:
This should give you what you are after.
Also note, we have raised an enhancement request to be able to use an org ref code based on another column, however this will not help you in your case, as the client will still be able to change from Ascending to Descending etc.. You really need to disable sorting on this column at the view level.
Hope his helps, and please let me know if you have any issues with this.
Regards,
David
There is only one way to get what you were after, which is what you're currently doing.
Having Column A apply the sorting, then hiding the column.
The issue with this is that in your setup, it's still allowing users to modify the sort order of Column B. But there is an easy way around this.
At the view level, disable sorting for Column B:
Then in the report they will see this:
This should give you what you are after.
Also note, we have raised an enhancement request to be able to use an org ref code based on another column, however this will not help you in your case, as the client will still be able to change from Ascending to Descending etc.. You really need to disable sorting on this column at the view level.
Hope his helps, and please let me know if you have any issues with this.
Regards,
David
Thanks Dave, it can help to solve the problem.