How to pull variable page fields in incident report

[babbi]

Hi Team,

We have created a report on incident table.

Is there any way to pull the variable page fields in report columns.

Please find below screenshot - we want to pull those fields in report column.How to achieve it.

Thanks,

Sai

[shyamkumar VK]

hi @babbi ,

you need to create an database view to joint two tables in order to achieve your requirement , please go through following support article for reference 

https://www.servicenowelite.com/blog/2014/3/5/reporting-on-incident-variables

[shyamkumar VK]

@babbi  

any update on this?

If this solution worked for you, please mark this as helpful & accept the solution as correct!
Regards,
Shyamkumar

[Ankur Bawiskar]

@babbi 

that's OOB behavior. if you have report on incident table you cannot see the variables information

you need to use database view.

What did you start with and where are you stuck?