Is there a way to pull in the Epicor Userid that is logged into Epicor onto an SSRS report? I only see where I can pull in the builtin userid field but that is the windows id assigned when it goes to the printer I believe. I have seen other post on this topic but they are older. We are currently on the cloud but using the classic version of the UI.
Does the report have callcontextBpmClient table?
If so, you may use callContextClient.CurrentUserId. This should show Epcior user id.
If it is a BAQ report, then BAQReportParameter should have DcdUserID field which works the same.
1 Like
Not currently. I’m not sure how to add it as I don’t see that table as an option. This isn’t a BAQ report.
Which report are you trying to modify?
The Sales Order Pick List. I have created a copy of the base SSRS report and have it all set up except they want to be able to show the userid of either the windows user or the epicor user logged in on that computer on the report when it is printed.
Add a dataset to the RDL for CallContextClientData. There is a table in the underlying RDD - it’s just not been exposed on the report.
Do you know how to do that? If not, someone here will paste you the query you need to put in there and then the rest is pretty easy to explain.
I did that but it wants a schema table and when I search for the callcontextclientdata schema table it can’t find it. Am I missing a step?
You don’t need to add it in the RDD. It is already being passed into your report behind the scenes. You just need to create the dataset in your RDL report file. Add a new dataset, name it callContextClientData, select Use a dataset embedded in my report. Select the one that’s in the drop-down under Data Source.
Click on the fx button under the Query section.
You will paste this into your Query function.
="SELECT T1.CurrentUserId FROM CallContextClientData_" & Parameters!TableGuid.Value & " T1"
Then create a field called CurrentUserId.
Then you can pick that to show on your report wherever.
3 Likes
Thank you so much! That worked!
1 Like