Forum Discussion
Order in fields pane
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.
Hi,
Within tables, I would hate renaming my fields since they are straightforward for Q&A, formulae, etc.
To find them effectively, the first thing I do after I import new tables is to jump to relationship view, hide all columns I will not use (not only ID/key columns but also very often numbers since I always work with measures, and dates since I work with one global related date table).
I then group fields into folders and subfolders
but I would love to group tables in folders within the report view...as well as move my date table to top
This is the best solution, thanks: kudos!
