Use the =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.
Dataset
dialog box.Data
panel and click the highlighted icon to open context menu with list of options. Select Parameters...
option in the menu to open Parameters
dialog box as shown in the following image.
UserId
parameter to open context menu with two options and select Expression...
to open Expression
dialog box as shown in the following image.
User
option under Built-in-Fields
from the highlighted Options
combo box as shown in the following image.
UserID
and double click it to set UserID
value as shown in the following image.