Reporting - Include fields from Requested Item and Catalog Task

[Bel Ngiam]

I need to create some reports which include variables on Requested Item and assignment group in Catalog Task. However, can't seem to find a way  to combine these fields togeter. Any idea? I don't have Assignment Group on Requested Item form, only on the Catalog Task.

[sushant007]

I dont know how much following can help but giving a try:

if you need this report to show the relationship between requested item and catalog task:

you may want to create a database view considering these 2 tables and join the table based on your need.

once everything is in place; you can create report on database view.

[abhijithrajeev]

Hi Belerin,

Just like Sushant mentioned creating a Database View would help you to add columns from multiple tables for reporting. Please find the attachments that could help you out with the same.

Creating a Report from Two Tables

Database views

Please do mark the answer as helpful/correct based on impact.

Thanks

Abhijith