Change name of a column in report

jkhanddh
Tera Contributor

Hi Everyone,

Kindly suggest me a solution to a scenario problem:

  • I have created a record producer that contains fields that are not on table (on which the record producer is created).
  • I can't create new fields on table as it is not advisable to do this just for a single record producer.
  • So What I do is populate all the field's data to description along with the field labels
  • But now the requester want a report on those fields, How can I create that when I don't have actual fields on table.
  • So what I did saved the data from the form to some custom fields already present, but in report the name of column is what was by default, how to change the column name in  a report.

Thanks in Advance

5 REPLIES 5

Hello @jkhanddh 

To change the labels in list view follow this steps:

Step1: Create a new record in sys_db_view table

JuhiPoddar_0-1732873914886.png

Step2: Make the note of Variable prefix, in my case I have mentioned it as inc

Step3: Create new record in sys_documentation table

  • Table: Database view name
  • Label: New name of column
  • Element: <variable prefix>_technical name of column eg: inc_number

JuhiPoddar_1-1732874098536.png

Step4: Create multiple records in  sys_documentation table for all the fields you want to show in report.

Step5: Create report and select table name as Database view name

JuhiPoddar_2-1732874465271.png

Step6: Select type as List 

Step7: In configure section choose the column where you can see the column new name to choose

JuhiPoddar_3-1732874745720.png

Step8: Once saved the result can be seen with new Column labels

JuhiPoddar_4-1732874873033.png

Hope this helps! Feel free to reach out for any further queries.

 

"If you found my answer helpful, please like and mark it as an "accepted solution". It helps others find the solution more easily and supports the community!"

 

Thank You
Juhi Poddar