Announcements
No record found.
Hi All,
I'm working in a SSRS report where want to print the current UserId who have generated the report, for this I have used "UserID" function in "Build-in fields" in SSRS report but this function is giving window user id instead of Ax user id.
How can I implement this as without creating any additional field of userId in Temptable and can call with curUserId. Is there is any other function or other way to call UserId??
Please help me to resolve tis issue.
Thanks in advance!!
You'll find user's details in UserInfo table.
Hi Martin,
Can I call it through any function in SSRS report?
The primary source of data is tables, not functions. You can't expect to have a function for each field in F&O database. Instead, fetch the data from database table. For example, if the report is based on an RDP class, you can add an extra field for the ID and populate it in amn extensiin of the RDP class. Then you'll use this new field in the same way as all other fields.
Hi,
I think as Martin suggested, you might not be able to get the current userid using SSRS report function as the AX user id is saved in UserInfo table, hence you need to have your custom X++ code to populate the current user id into the datasource as a field and then display that field.
Regards,
Anh Ong
Hi Martin and Ong Tuan,
Can I add a hidden parameter which passes curUserId wile the report is generating?
Is it possible?
Yes, it is. Just note that curUserId() returns AX user ID, which you don't want.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Giorgio Bonacorsi 622
André Arnaud de Cal... 553 Super User 2026 Season 1
CP04-islander 430
