Is there a way to print sys_id on a report

nico2
Giga Expert

Hello, 

Is there a way to print the sys_id on a report?

any ideas are welcome. 

 

1 ACCEPTED SOLUTION

sachin_namjoshi
Kilo Patron
Kilo Patron

you can include sys_id with list view report

 

1. Go to module System UI -> Lists

 

2. Select the record for the Table and view you want to modify (e.g. incident table, default view).

 

3. In the List Elements related list, add sys_id in the position you want

 

4. In your application navigator, type cache.do

 

Regards,

Sachin

View solution in original post

5 REPLIES 5

sachin_namjoshi
Kilo Patron
Kilo Patron

you can include sys_id with list view report

 

1. Go to module System UI -> Lists

 

2. Select the record for the Table and view you want to modify (e.g. incident table, default view).

 

3. In the List Elements related list, add sys_id in the position you want

 

4. In your application navigator, type cache.do

 

Regards,

Sachin

Julie Leung2
Mega Expert

@Nico, you could also try to create a Database View that includes the table you are reporting on, and without any other tables nor a "where" clause.

 

Since you and end users (if you create the appropriate ACLs) can report on database views, this would allow you to call in the SysID as a regular field inside the standard report front end.

Good luck,

Julie

 

If you found this help, please click "Helpful"!  Thanks!


nico2
Giga Expert

Thank you Julie for the idea, I will try it out.

 

Feel free to let me know if you need help.  I've gotten it working like a charm!