Not able to find the particular field to use it for reporting purposes in ServiceNow

[Anu7]

Hi,

I have a field called Service Expiration on Case form. But I am not able to find/locate the same field when I am trying to create the report. Any inputs on how to make this field available for reporting in ServiceNow.

Let me know.

Thanks

Anusha.

[Bharath40]

Hello Anu,

Is it a variable from catalog form or field from table. If it's from a table you should be able to see it if it's for iRITM

follow these steps

Goto Reports-> Create new
In the Data section give Name to report select source as Table and select table sc_item_option_mtom.
In the type section select type if required.
In the configure section select choose colomn.
From the slush bucket select below field :
1.Parent item
2.Depended Item-> Question
3.Depended ITem->Question->Value

[Anu7]

Hi Bharath,

It' s a variable from Catalog form. I have attached the picture for your reference. When I tried to follow the steps - I don't see a table sc_item_option_mtom.

Thank you.

Anu

[Bharath40]

Hello Anu,

It doesn't look like a catalog form to me, is it a record from any custom table ? 

You should be able to get variables in reports Click on columns, scroll down to Variables select the item and variables will be displayed for the item. Try this

Thanks

[kevinclark-7EL]

That looks like a field being displayed on the form and not a Service Catalog Variable. 

I wonder if it's a field that is a reference to a related record... does it get populated automatically when you fill out the field above?  If so, then it's possibly being pulled from the related record instead of the current record... 

Check the "Configure Form Layout" window for the Case record and see if the field looks like "<otherfield>.Service Expiration" (see the "Caller.Building" example below:

If it's got a dot, then it's a reference to a field on the related record - try to dot-walk to the same field in your report.  A "dotted" field on the form won't be present in the report module because the field doesn't technically belong to the current record - it belongs to the related record.