How to create a report in servicenow using two different tables

[GaneshUrs]

I have a table named "problem" and another table named "problem sla" where we get different details from the problem records. I believe it is possible to create a report using dataset with graphical view. However, my requirement is to create a List report using or merging both these tables which can provide all relevant details. 

[J Siva]

Hi @GaneshUrs 

Problem_sla table contains fields from both problem and task_sla table.

So, you can use only problem_sla table to fulfill your requirements.

[Saloni Suthar]

Hi @GaneshUrs,

You should be able to build a database view to create a list view. If you can provide more details on what you are trying to achieve, we can help better.

[21121A3359]

Using Database View 

1. Go to System Definition → Database Views.
2. Click New and name it (e.g., problem_sla_view).
3. Set Primary Table as problem.
4. Click New Table, add problem_sla, and set the join condition:
   • problem.sys_id = problem_sla.problem
5. Save the Database View.

Create Report

1. Go to Reports → Create New.
2. Select Type: List.
3. Choose the newly created Database View as the Data Source.
4. Add required columns, filters, and sorting.
5. Save and run the report.
   
   
   Please accept and like my solution if it used for you...

[Chaitanya ILCR]

Hi @GaneshUrs ,

the Problem SLA is a database view created form(problem and task_sla). It will contain the all the information you need.

you can create the report by just using problem_sla.

Please mark my answer as helpful/correct if it resolves your query.

Regards,
Chaitanya