dwalby Posted August 15, 2018 Share Posted August 15, 2018 Hi all, Is it possible to show the column display names, rather than the column database names in reports? Further to this, is it possible to show the Custom Field names? Rather than Custom A, Custom B, Custom C, etc.? Our users log GDPR data breaches via the Hornbill self-service portal, the questions answered in the progress capture are then mapped to Custom Fields within the request form. We then need to produce a report for GDPR purposes that shows the information set against those Custom Fields, however when producing this through Hornbill it appears as below: Because of this we're having to copy/paste the data from the report into an Excel sheet with the correct headings. Any help on this would be appreciated Link to comment Share on other sites More sharing options...
James Ainsworth Posted August 16, 2018 Share Posted August 16, 2018 Hi @dwalby The heading on the reports can be set here... Let us know if this helps. Regards, James Link to comment Share on other sites More sharing options...
dwalby Posted August 16, 2018 Author Share Posted August 16, 2018 Hi @James Ainsworth, thanks for this. It seems the capability to rename column headings is not available in the SQL Schema Designer report type. I've re-created the report using Entity however and can now rename columns. Link to comment Share on other sites More sharing options...
Victor Posted August 18, 2018 Share Posted August 18, 2018 @dwalby you can rename columns using schema designer as well... you need to set an alias for the tables though to have this available... Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now