How to add multiple option in report

[Asha Pathak]

Hello Community!

I have one requirement 

The elements should have the ability to filter assignment groups by one, multiple, or all.

How to create report.

Please help!

[Ankur Bawiskar]

@Asha Pathak 

sorry your requirement is not clear.

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

[Asha Pathak]

@Ankur Bawiskar ,

In requiremnt there are 4 groups are given and these groups should have the ability to filter assignment groups by one, multiple, or all 

means when we select specific group then data will be visible only for that group and when we select one of group name then data will be visible for that groups and when we select all then all data will be visible for that all groups.

Thank you!

[Ankur Bawiskar]

@Asha Pathak 

why not give that group report_admin role so that they can apply the filter conditions in your report?

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

[Pooja58]

Hi @Asha Pathak ,

If this is for report on dashboard then Create a interactive filter of type reference on sys_user_group table and UI control type as select multiple input and add that interactive filter along with report to the dashboard. 

Make sure your reports follows interactive filter.

Even you can add filter condition in interactive filter to show only few assignment groups.

Please mark as correct/helpful, if this helps your query.

Best Regards,

Pooja