Paginated Report Filters

Rob_Somm — Wed, 16 Aug 2023 11:52:37 GMT

Hi,

Hoping someone may be able to guide me in resolving this issue and if not then to clarify that this cannot be done

We have a customer portal we wish to publish a report to which they can view and also download. As PDF Export isn't available within the Customer Portal (Premium Workspace) we have been advised to draft a Paginated report which offers up the functionality to download this report. Therefore we have created a Paginated Report from a Power BI dataset off a report which is also Published to this workspace. The Paginated Report needs to contain 3 filters, 2 of them are for a From Date and a To Date fed from a column on the dataset called Date and a 3rd filter for the Account Code which again sits on the source dataset. So the issue we have is that this Paginated report works perfectly fine when run from within Reports Builder and also within the Power BI report if added as a tile, however, we cannot get the Paginated report to filter the account so that a filter can be applied to the Power BI report which then interns filters the Paginated report. The Account Code is something we filter on each dataset for customer access to ensure that only they can see their data and not data belonging to anyone else

Hope this make sense but what we wish to know is how we can filter the data for Account on this paginated report so that it only shows a list of accounts that the particular customer has access to. Gone round the houses on this issue and seem to come back to the same failed outcome.. Any guidance or help in this area would be massively appreciated

topic Paginated Report Filters in Report Server

Paginated Report Filters