Last post Feb 06, 2020 09:12 AM by Yongqing Yu
Feb 04, 2020 09:36 PM|szejli|LINK
I have a report with a filter parameter "Activity" with two possible values to choose: Command Or Delivery.
We have two kinds of CA: purchase orders CA and delivered orders CA
I have a matrix where I calculate the CA of purchase orders which is taken from a dataset named "COMMANDS_DS".
I have another dataset where I have the CA of delivered orders which is named "DELIVERY_DS".
If I choose the Activity "Command" in the filter then I want that "purchase orders CA" to be displayed. So, my matrix must be based on the "COMMANDS_DS" dataset .
If I choose the Activity "Delivery" in the filter then I want that "delivered orders CA" to be displayed. So, my matrix must be based on the "COMMANDS_DS" dataset .
Is there a way that my matrix be able to choose one of the two datasets depending the "Activity" chosen ?
Thanks in advance.
Feb 05, 2020 08:51 AM|Yongqing Yu|LINK
According to your needs, you can add all fields of both datasets to the same matrix, and use these two parameter values to determine which fields are displayed and which are hidden.
Show or Hide SSRS column based on specific parameter value
If allowed, you can create two matrices to bind each dataset, and use parameters to decide which matrix to show or hide.
Feb 05, 2020 09:35 AM|szejli|LINK
Thank you for this response.
For the first suggestion, all the fields should be in the same dataset as the matrix can not be based on two different datasets but I have two different datasets.
How can I do this ?
Feb 06, 2020 09:12 AM|Yongqing Yu|LINK
If this is the case, then according to my point of view, the second is a simpler and more convenient method.
You can create two matrices and bind two datasets respectively, and control which one is displayed or hidden by the parameter value.