Report creation related issues.

[1_DipikaD]

Hi Team,

I have a doubt regrading report creation. I want generate a report  which will show Requested item no. , approval group, action date, comments on that RITM, action date .

Thank you

[JerryJ071847183]

if your query is with respect to comments or worknotes related fields not appearing properly in report then

you can try the database view workaround for this .

Please see below article which can assist you in right direction.

Create reporting with Work Notes and Additional Comments that links to a Task - Support and Troubles...

And If you want to add other fields like ritm and other stuff , i would insist you look at the oob

reports and get an idea how to do it .

Link:

https://instancename.service-now.com/now/nav/ui/classic/params/target/sys_report_list.do%3Fsysparm_q...

Mark my ANSWER as CORRECT and HELPFul if it works

[Ankur Bawiskar]

@1_DipikaD 

to see RITM, approval group etc you need to have database view between sc_req_item and sysapproval_approver table

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ankur Bawiskar]

@1_DipikaD 

Thank you for marking my response as helpful.

If my response helped please mark it correct and close the thread so that it benefits future readers.

[1_DipikaD]

I got the answer thanks for your responses.