Forum Discussion
Order in fields pane
The OP asked about the order of field names in the Fields pane, not in a visualization.
Yes, the [Sort by Column] option also controls that.
It can
- control the order items are displayed on an axis
- the order items are displayed in a legend
- the order of wedges/blocks in clustered column and pie visuals (etc)
- and, it also controls the order that fieldnames are displayed in the Fields pane
See the images below to see what I mean.
Thanks for the clarification Phil.
So if I understand it correctly, the solution is to:
1. create a new table with the 3 values as shown,
2. create a relationship for every query to that table,
3. set the desired order for every column
I appreciate the option, but for me this is too ham fisted and I would not likely bother. In one file alone I have 8 queries with well over 100 columns in total.
It would be a pain if you have lots and lots as you say.
I had models where I've perhaps wanted to override the default sorting on just a small number of columns at the most. Sorry about that.
Phil
This thread is getting a bit dated, but here's my 2 cents,
You can rename the fields. Give them alphabetically ordered names. Yeah, well, probably not practical. But they could be prefixed with numbers.
They would then appear in the FIELDS list in order. But that just pushes the problem off to the end users who would probably not want extraneous numbers on the column headings in their reports.
It's worth noting JasperReports had the ability to customize the order in the Field list more than a decade ago. Wake up MS! When I have a location dimension I'd really like to have the address fields in standard order: Name, Address1, Address2, City, State, Zip. Not alphabetic: Address1, Address2, City, Name, State, Zip.