At times it may be wanted to limit the amount of information an end user can see in specific prompts and reports. Unlike a security filter which applies to all reports/prompts in a project, this method allows a developer to dynamically control the information seen by relating the User Login to relevant data.
Step 1: Create a filter that sets a user attribute equal to the System Prompt "User Login".
Step 2: Create a new report that includes the User attribute, the other attribute that you wish to filter. and the new filter created in Step 1.
Step 3: Create a new filter that is a shortcut to report pointing to the report created in Step 2.
Step 4: Attach the newly created filter (Step 3) to either a report or prompt.
Upon execution the User Login id will be pulled automatically and filter the correct values in the prompt or report from the table in the database.
