Filter Pivot Table data in a data report

[DingoBlue]

I have a view containing transaction data for several clients. Each row contains a unique client code such as ABC, DEF, GHI etc.
I want to show a detailed transaction report for a client (the client code I select in the parameter when running the report). Additionally, I would like to include a Pivot Table that only analyses the data for the selected client (as specified by the parameter).
I have built the report using the report designer and added the client code as a parameter. I have a filter string in the report which provides exactly the data I want to see. However, I cannot find a way for the Pivot Table to respect the parameter value and show a table containing values for that client. The Pivot Table filter string in the designer does not let me use the parameter.
dbForge Studio 2020 for MySQL, version 9.0.34
Can anyone please assist?
Regards

[alexa]

We will review this and will answer you as soon as possible.

[DingoBlue]

Thank you for looking at this.
I have resolved it by using a "linked" query.

Regards

[alexa]

Thank you for updating us on this issue.

Please let us know if any questions arise.