Filter Pivot Table data in a data report
Posted: Sun 24 May 2020 05:05
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
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