how to add coloums to reports from variables in RITM.

[brahmandlapally]

how to add coloums to reports from variables in RITM. i have variables in catalog form so i need them in report.

[Sai Krishna6147]

Hi @brahmandlapally 

When you create a report in the there would be 4 stages Data > Type > Configure > Style.

In the 'Configure' you can find 'choose column' you can modify the data according to your needed data and click on next.

Refer: https://www.servicenow.com/community/itsm-forum/variables-added-at-a-column-in-a-report-are-not-visi... 

Please mark this response as correct or helpful if it assisted you with your question.

Thank you

[thullurishalini]

Hi @brahmandlapally 

To add columns to reports from variables, follow these steps

1. Create a Database View: - Go to System Definition > Database Views.
- Create a new database view that includes the'sc_item_option_mtom' table, which contains the variable values.
- Join this table with the'sc_req_item' table (RITM) using the'request_item' field.

2. **Define the Join Conditions**: - Specify the join conditions to connect the RITM table to the variable values table.

3. **Create the Report**: - Navigate to Reports > Create New.
- Choose the database view you established as your data source.
- Add the relevant columns, including the RITM's variables.

4. **Configure and Save the Report**: - Set the desired filters, grouping, and visualisation settings.
- Save the report.

If my response proves useful, please mark it "Accept as Solution" and "Helpful".

Thanks,

Shalini.