Query report output - Assets

[JanS2000]

Hi, I've created a new report, to report on assets at a particular location. I know in the data preview it usually shows the integer instead of the text for certain fields, but usually when I export to .xlsx or .csv, it shows the text as it should, but this report isn't showing the text, just the number. I don't know if this happens for all columns that use integers or if it's just those I've selected, Type and Operational state.

Everything else looks okay. I've compared settings to another report which shows the Operational state and there's nothing standing out in the new one, to say why it's not showing the text. Any advice would be much appreciated as always.

Thanks.

 

[Steve Giller]

Without having access to both reports to compare them this would be impossible to diagnose.

If you're happy to export the definition files and attach them here we can take a look.

[JanS2000]

Thanks @Steve Giller, I'll have a go at exporting the definition files and upload them as requested.