I want to place a condition in an RDL design that I am doing, from a query
this is the query
SELECT
Nombre,
Cuenta,
Monto,
TipoOperacion
FROM Transacciones
This is the result it gives me
In the RDL design I want it to only show me, for example, the records that have C in the OperationType field, I want to do it from the RDL not from the query, since later I will add another RDL box where it only shows me those that have D in the field Operation type
The issue is that I don't know what function to use for it in the RDL, I was using this
=IIF(Fields!TipoOperacion.Value="C",Fields!Monto.Value,"")
But it still shows me all of them including those that are D
Please help
Go to your report layout and right click on the tablix details row and select the Row Visibility... option.
In the next window that appears, check the 3rd option, Show or hide based on an expression , and click on the button next to it ( Fx ).
In this new window that opens, you put the visibility condition of your row:
In this way we hide all the rows where the TipoOperacion field is equal to "C" .