Can you change the column headers in CSV?

I have a report i built that shows password expiration dates for a list of users. When i export to CSV, i include the column headers, BUT i want to change the column headers to something more intuitive. Is that possible? So instead of a column saying "Domain Name (Domain)", i would just have it say "Domain". And instead of "Canonical Name (Domain OU)", it would say "Organizational Unit".

Parents

0 Tracey.Reath over 3 years ago

What version of Enterprise Reporter do you have?
Cancel
Up 0 Down

Reply

Verify Answer

Cancel
0 Tracey.Reath over 3 years ago in reply to Tracey.Reath

If you have a newer version of the product- you are able to edit the report and will see a Tab for CSV Options- you can edit CSV column display names there
Cancel
Up 0 Down

Reply

Verify Answer

Cancel
0 jrauman over 3 years ago in reply to Tracey.Reath

I do have 3.2.1 and you are my new best friend. I have been wanting to change those headers for years. I end up changing them each time i export to CSV. So much time saved.
Cancel
Up 0 Down

Reply

Verify Answer

Cancel

Reply

0 jrauman over 3 years ago in reply to Tracey.Reath

I do have 3.2.1 and you are my new best friend. I have been wanting to change those headers for years. I end up changing them each time i export to CSV. So much time saved.
Cancel
Up 0 Down

Reply

Verify Answer

Cancel

Children

0 jrauman over 3 years ago in reply to jrauman

BTW, can i massage the data in the report as well? For example, in the installed software report, i dont need the installed time (just the date), nor do i need the discovery time (just the date as well). so i format the fields as date-only AFTER opening them in excel. Anything i can do like that?
Cancel
Up 0 Down

Reply

Verify Answer

Cancel