+ Start a Discussion
Ravindar AdminRavindar Admin 

How to use user custom field value in custom object field in filter in Reports?

I am Trying to create a report on Object__c, I have custom field(projectName__c) value on the current user. So while creating the reports, I am planning to filter like below:.

How to achieve this?  

If you provide the solution, That will be Very glad.
Best Answer chosen by Ravindar Admin
Hi Ravinder,

This is a trick which can be used to get some kind of dynamic ability in Salesforce, you should be able to use this trick to achieve what you want:

Here it goes.
Create a check box formula field:  with value as  Object__c.projectName__c=currentUser.projectName__c;
So that it returns true when the condition satisfies.

In the report, use the formula field equals true.

And you would see the records with the condition is true.

Hope it helps