User Criteria Report with Drilldown

[Sathwik1]

I need to create a report based on a table that includes two fields:

Name and User Criteria. When a user clicks on the User Criteria field, the report should drill down to the next level, displaying all the users and groups mapped to that criteria.

Could someone please assist with this requirement..

@Ankur Bawiskar  

[Sathwik1]

Yeah @Dr Atul G- LNG  I've seen.. so I want to use 2 reports seperately and want to handle it through  interactive filters.. is it possible?

[Dr Atul G- LNG]

Hi @Sathwik1 

Understanding further:

• Report 1: Includes two fields — User Criteria and Name.

• Report 2: I'm not sure which one you're referring to.

I was thinking — why not create a Database View between your custom table and the User Criteria (OOTB) table?
You can join them where custom_table.user_criteria == ootb_table.user_criteria, fetch the results from this view, and then create a report on top of that.

[Ankur Bawiskar]

@Sathwik1 

when someone clicks on User criteria field in that report it will take them to User Criteria record.

There if they have read access then they will see the User, Groups, etc

That's OOTB behavior.

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Sathwik1]

@Ankur Bawiskar  Here User criteria field is not a main field... so it is taking to my custom table (which table I used for creating the report)..  

[Ankur Bawiskar]

@Sathwik1 

I created report on incident table and I clicked assigned to field then it took me to user record.

I am using old Reporting feature and not platform analytics

share screenshots.

If my response helped please mark it correct and close the thread so that it benefits future readers.