Custom Log Report Parameters - Get Current User ID

SUGGESTED

My goal is to build a user-specific report for summarizing expenses by month.  Is there a built-in parameter or other way to reference / filter based on the currently logged-in user?  The Idea is to have the userID (or similar filter) available as a parameter for use in the SQL query.

SELECT ... FROM ...

WHERE dbo.vw_PrimeInvoiceCostPlusPreBillingDetails.CostTransContactId LIKE $USER.ID

Parents Reply Children
No Data