Passing current user for the report


Passing current user for the report in custom links for home page
      /reportID?pv1={!User.Name}

for checking if the lookup field Id is current user Id  in report
1. create a Formula type of number type field 
                 with if condition checking for the lookup Id == current user Id returning 1 on true and o on false 
          Ex: IF( lookupFieldName__c = $User.Id , 1 , 0)
2. In report check if this formula field is equal to 1 

Comments

Popular Posts