Jump to content

Feature Request - The ability to customise the order of the “Columns” exported from Request List


Recommended Posts

Just to follow up on Nicks comments we also build back end reports where we have specific data requirements / column order / column name etc. This avoids having to output data just from a request list, then having to manually order it in Excel. I find the request list data is useful for situations where you need to check data there and then, but more often than not, I will then build the report in the back end to allow for customisation of the columns names and ordering. (1st image)

However if you still want to output from the request list you can order the columns in the configuration before output to Excel (2nd image) by just dragging the columns into the correct order. This may aid in lessening the data manipulation in Excel for you.

1st image:


2nd image:


Link to comment
Share on other sites

Sorry just realised above was incorrect on sorting the request columns when exporting - the above is just to order how you see it in the request list view in Service Manager (I always forget there is a different option for exporting the request list as below). 

So yes if you want to have to avoid ordering the data manually in excel I would advise to build the report in the backend reporting function.

Image you see when exporting to excel - no option to order here:


Link to comment
Share on other sites

If you're exporting regularly from the Request List View you need a report.

The Request List View export is designed to be an occasional, ad-hoc export of small amounts of data. It is not a reporting tool and I am not aware of any plans to increase the functionality here.

  • Like 1
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...