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. 

[JanS2000]

Morning @Steve Giller, apologies for the delay, I've only just had chance to come back to this and download the definition file. Attached as requested. Thanks for your help, much appreciated

assets-by-location.report.txt

[Estie]

Hi @Steve Giller

I am also experiencing this issue when reporting on all assets.

Also the CSV produced is only giving me 10,000 records, when we have 50K+.

Is it possible to produce a report of all assets?

Thanks