How to pass the login user as parameter to Stored Procedure
=User.UserID expression to pass the login user as parameter for a stored procedure. Find the following steps to pass the login user value to stored procedure parameter for getting the data from database based on user.
Create a dataset using the stored procedure, which having a UserID as parameter from
Select the dataset from
Datapanel and click the highlighted icon to open context menu with list of options. Select
Parameters...option in the menu to open
Parametersdialog box as shown in the following image.
Now, click the highlighted square icon of
UserIdparameter to open context menu with two options and select
Expressiondialog box as shown in the following image.
Built-in-Fieldsfrom the highlighted
Optionscombo box as shown in the following image.
UserIDand double click it to set
UserIDvalue as shown in the following image.