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
