generate report with more than one table

[crocha]

Hello, I am new to Service now and I have learned how to make reports with a table. I would like to know if anyone knows how to make a report with more than one associated table.

[bammar]

If they are both part of the task table heirarchy you should be able to, however you would want to specific which tables you want to show data from in the query ( there is a field that shows table name/ or use number starts with ) AND consider that the common fields would be reported on, the unique ones that exist on only 1 table would be either difficult or not possible to report on in this type of report

[James Chun]

Hi @crocha,

Are you referring to something like the below?

The report shows 3 trends from 3 different tables (Incident, user, change request)

Cheers

[crocha]

Estaba tratando de hacer un reporte con las Tablas task, sys_user_has_role_list.do. Para cruzar resolutores, cantidad de atenciones y si tienen rol itil activo.

[Priyanka Reddy1]

@crocha 

you can create database view of the tables you want to build reports with.