Report - Suggestions needed

[Sruthi17]

Hi experts,

I need to create a report and I'm not sure how exactly to achieve it. I have explained the scenario in detail below. TIA.

I have a report created from the "Payroll case" table. This is a list type records and I added few columns from the payroll case table and it looks like below

Now the payroll case table has a related list "Payment matters"

Now I wanted to show each row of payment matters as a new column in the report like below

Employee ID

Employee Name

Hire Date

Resignation Date

LOS

Salary Recovery

Training Bond

Misc Deduction

Pilot Payment

Total Due

1st Installment Amount

2nd Installment Amount

3rd Installment Amount

4th Installment Amount

Can you please provide any suggesstion to create a report like this?

OR
Any suggesstion what could be the best way to view the payroll cases along with its corresponding  payment matters?

[Jitendra Diwak1]

Hi @Sruthi17,

Hope this accepted solution can work for you.

https://www.servicenow.com/community/platform-analytics-forum/how-to-create-a-report-for-change-requ...

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Thanks

Jitendra

[harshav]

Hi Sruthi,

In this case you need to create a database view and do a report on that.

Thanks