How to restrict a user with itil role to create a report only few records

[Kiran Maruthi]

I want to restrict a user with itil role to create a report on label entry table only when table is knowledge. This user should not be able to create report on any other records, But there should be no read restrictions on the user when the user opens the table directly.

Pls suggest how to do this.

Thanks in Advance. 

[Dr Atul G- LNG]

Hi @Kiran Maruthi 

Can i request you please change your display name 🙂

and 2nd, what is meaning of only few records? We can restrict the report on columns via ACL - Report View 

[Kiran Maruthi]

Hi @Dr Atul G- LNG 

Thanks for the response.

Only few records means: for example on label entry table i have records related where table is incident and also knowledge.

but now I want to allow itil user to create report on only when table value is knowledge.

[Dr Atul G- LNG]

Hi @Kiran Maruthi 

You can check the ACL Report View and then put the conditions. Give a try in PDI mate.

[Anwesha3 · Accepted solution]

Not sure if I understood the requirement correctly , but you can try creating an ACL on report table for Create access ; where condition should be : if label entry table isoneof INC/Knowledge. 
use script on the acl to check if userhas role ITIL then return false. 

Kindly mark the reply as a correct answer / helpful if it helped to solve your question.

Thanks,
Anwesha