Report in HRSD

[AnchalSanchar]

In a report in Service Now I am trying to link the fields from the case table to the Task SLA table that the report is built on.  The fields within the form appear under "questions" in Service Now and I understand they are not defined as proper fields within the system.

Anyway in Service Now I can go to choose columns in the report and I can find the associated fields under questions that I want to pull through. In the choose columns box it appears to allow the columns to be selected, however when I come out of the choose columns box the chosen columns do not appear and it disappears out when I go back into the choose columns area

[Ankur Bawiskar]

@AnchalSanchar 

what's your business requirement and what did you configure so far? share screenshots.

[Ankur Bawiskar]

@AnchalSanchar 

task_sla is a database view and that could be the reason for this

many users in past reported same behavior

see these posts

Adding variable in Catalog Task SLA [sc_task_sla] table 

Reporting on RITM Variables and Task SLA fields 

Workaround: Create hidden field on that HR table and use that in reporting and use business rule to store the variable value in it

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[Ankur Bawiskar · Accepted solution]

@AnchalSanchar 

Hope you are doing good.

Did my reply answer your question?

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[AnchalSanchar]

How i can delete this post or replies ?

I'm not getting any option even to edit it, I want to delete the screenshots which i have posted.