Field Labels in Scheduled Reports

WESAdmin
Kilo Contributor

When viewing a "List" of results you can export the list into Excel, CSV etc and the export displays the columns as field labels but when using a scheduled report it displays the columns as the actual column_name. I have a feeling this is a system default but has anyone scheduled a report with the results producing the field "Label" rather than the column_name. I have reviewed the setting on a scheduled report and tried "editting" reports via Admin but I cannot see anything that identifies how i get the field name into a scheduled report rather than the column name.

4 REPLIES 4

Jim Coyne
Kilo Patron

Actually, my experience is that the CSV export (manually or via a scheduled report) will always have the field name as the column header and Excel will always have the the nice label.


Sometimes the plainly obvious is staring you in the face yet you still fail to see it.... Thanks heaps, I should have known this but as usual it takes another person's experience to turn the light on. Much appreciated.


Jim Coyne
Kilo Patron

Tell me about it - I was chasing down a problem a user was reporting earlier today. All of a sudden they could no longer see fields on a couple of tabs on a form. After a while looking through ACLs and running Debug Security, I realized they had simply collapsed the section. DOH!!!!


Been there done that? I had a manager reporting they could no longer get into the Incident record, they could see the list but when selecting the incident nothing happened...... Was scratching my head for a while until I found out they were using the "new ui" and had the bottom half of the page split as low as it could go so you couldnt see it... Double DOH!