Get Current User in Reporting

If you want to use the current user id in custom reports for MS CRM 4.0 (for example to set a filter) , you can use the SQL function "organization name"_MSCRM.dbo.fn_finduserguid.
This function will give you the guid of the current user which you can compare for example with the ownerid of a record.

Kevin Dosseray

Comments

Post a Comment

Popular posts from this blog

Scribe and Excel Data Ranges

Another Scribe tip: If you need to import Excel files with Scribe don't forget to give a name to your data range. Otherwise Scribe won't recognize your file. In excel 2003 you can do this as follow: Insert > Name > Define; in excel 2007: Formulas > Define name. Also when you notice that not all of your lines are imported, make sure that your data range is big enough (make sure it includes all of your data lines). Happy Scribing!
Read more

Scribe MVP!

Image
I've been invited to join the Scribe MVP program! And guess what... I've accepted the invitation :-) See here for the complete Scribe MVP list. Scribe MVP... sounds nice, doesn't it? ;-)
Read more