Data manipulation via before business query

[BillieDobbie]

Hi,

Good day!

Please help, I need to properly capitalize the names of the users for the reports and exported reports via scheduled report.

Thank you!

[Ankur Bawiskar]

@BillieDobbie 

before query BR helps in filtering records and cannot manipulate the data.

did you try to explore the function fields in reports?

Function Fields in ServiceNow Reports: Calculate and Display Data on the Fly 

If my response helped please mark it correct and close the thread so that it benefits future readers.

[BillieDobbie]

Yes, I did try the function fields but cannot change the capitalization of the name. Thank you!

[Ankur Bawiskar · Accepted solution]

@BillieDobbie 

then the only option is to have custom field and store the capitalize value and then include this new field in report

If my response helped please mark it correct and close the thread so that it benefits future readers.