How can I pass id as parameter while showing descriptions in filter control of paginated report?

I have scenario where I have dataset for filter control with id and name column I want to show name in filter control and pass id to main dataset query as parameter value. How can I achieve this in paginated reports?

1 Like

Hello @NBBI, welcome to the QuickSight community!

Is the desired outcome to filter to a specific id depending on the user that is viewing the report? If so, you will want to implement RLS on the datasets that are linked to the paginated report rather than utilizing parameters. That will ensure each user/group is linked to the proper id and it will only allow them to see the ids they have access to. Let me know if this helps!

No that’s not the case. It is like I am viewing sales performance across different regions. Parameters drop down should show region names and pass region id to main dataset to get the results.

1 Like

Hello @NBBI, I understand. So the issue is that the paginated report is being sent as a PDF to the user and they don’t have any kind of dynamic, filter-based functionality. That means, in order to filter the parameter it will need to managed by connecting it to the user or group that is receiving the report.

Since RLS isn’t the solution, then it will need to be managed through dynamic default values or static default values. Dynamic defaults for parameters function pretty much the same way as RLS. A dataset is created that will link specific field values with a specific user or group. Then, whenever that user views the dashboard or paginated report, it will filter to that value.

Alternatively, you may have to set up specific reports to be sent out that will be filtered to certain regions if a single user needs to be able to retrieve reports for multiple regions, but only one can be filtered to at a time.

Unfortunately, these are the only options available to set up parameter based filtering for the emailed reports. I’ll mark this response as the solution, but please let me know if you have any further questions on the topic.

It is not useable for a reader account

Hi @NBBI,
As Dylan mentioned above, paginated reports do not currently have this type of function currently available so I’ll mark this as a feature request.

If you have any additional questions, let us know. Otherwise, if we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

Hi @NBBI,
Since I’ve already marked this as a feature request and we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community.

Thank you!