User Logged IN data filtration in Paginated Report without relationship

[navin_Learning]

Dear All,

I have a report published in Workspace, and am using the dataset to create a paginated report, the report has to many columns (thats a totally different challenge though).

What i want is, when this paginated report is published in a workspace and when a user logged in to see/print the report, he should only see data relevant to him. For this i need help with 2 question.

1. How do i filter data with logged in user

2. The main data doesn't contain user information, the link between main data and user data is two column having code information, residing in 2 different column (Code 1 & code 2), so how does i link this, and satisfy the condition with both parameters.

Dataset 1 - Main data (includes code 1 & code 2 column)

Dataset 2 - User data (contains UserID and code 1/ code2 column)

Dataset 1

Policy	Code 1	Code 2	Sum
1234	100	10	2000
5678	100	10	2000
91011	100	20	3000
121314	101	30	4000
151617	101	30	5000
151618	133	75	600
151617	133	75	800
151615	144	52	9000
151617	144	52	1222

Dataset 2

User	Code 1	Code 2
abc@xyz.com	100	10
def@xyz.com	100	10
pqr@xyz.com	100	20
mno@xyz.com	101	30
mnt@xyz.com	101	30

Thank you for any help!

Best Regards,

Navin