Hello. I'm building some reports (RDL) that are using SQL to retrieve the data because the queries are too complex for FetchXML, but I'm unable to find a way for the SQL report to know which CRM user is calling the report. The report is always
called by the CRM Service account so SQL functions like CURRENT_USER will not work. Also I read one article that suggested using dbo.fn_FindUserGuid(), but this also just queries the current SQL user which is the service account.
I hoped I could add a hidden parameter and pass the User's GUID to the report from CRM to the report, but I haven't found any way to do this. Now is this possible?
Thanks. Also this is in CRM 2013 SP1 (rollup 2) on Premises.