Actually, the secret is to define the Display Name in addition to the Name. The export will then use the Display Name.
------------------------------
===============================
Craig Kokay,
Lead Senior Maximo/IoT Consultant
ISW
Sydney, NSW, Australia
Ph: 0411-682-040
=================================
#IBMChampion2022
------------------------------
Original Message:
Sent: Wed December 08, 2021 08:54 AM
From: Steven Shull
Subject: Exporting CSV data from report: How to export report labels instead of DB column names?
I don't think there's a way to control this on a QBR as it builds the underlying report for you. You could export the report, modify, and import it but then as a user makes a change it will be overwritten so I wouldn't do this for a QBR.
When you do a custom report (or clone an out of the box report), you can define the output columns in the data set. For example, in the woprint.rptdesign the work order description is set as wodesc. I could change this to something more descriptive and this is what gets used on the export data.
------------------------------
Steven Shull
Original Message:
Sent: Tue December 07, 2021 11:20 PM
From: User1971
Subject: Exporting CSV data from report: How to export report labels instead of DB column names?
Hi Steven,
Regarding this blurb: "It's not the database column (it's the column as defined in the data set of the report) so you could modify that in the report to match the label but that's more work than it's worth in my opinion."
To clarify, are you referring to the Value column in the Selected Fields table control in the Ad Hoc Report dialog?
If so, it looks like the Value column is read-only in that table control. When you say I "could modify that in the report", how would I modify it if it's read-only?
Thanks.
Original Message:
Sent: Mon November 29, 2021 08:48 AM
From: Steven Shull
Subject: Exporting CSV data from report: How to export report labels instead of DB column names?
I don't believe this is possible (at least today, not sure if something will change with the upcoming BIRT update). It's not the database column (it's the column as defined in the data set of the report) so you could modify that in the report to match the label but that's more work than it's worth in my opinion.
I find this works well with a single set of data (list reports basically) so I typically try to move these into a result set instead and have them download it that way from Maximo.
------------------------------
Steven Shull
Original Message:
Sent: Sun November 28, 2021 10:13 PM
From: User1971
Subject: Exporting CSV data from report: How to export report labels instead of DB column names?
MAM 7.6.1.2:
I have a report that users export data from.
When Maximo exports the data to CSV, the DB column names are used as the CSV column headers, instead of the report labels.
Is there a way to export the report labels instead?
Thanks.
#Maximo
#AssetandFacilitiesManagement