In Visual Studio I am using "=Iif((CountRows("Metallugy") < 1), True, False)" to hide a textbox. When testing the script in Visual Studio it works just fine but when I send it to the server of PowerBI I get the following error(see below). I'm using Version 1.2.6660.39920 (Build 18.104.22.1689), Released: March 28, 2018. Does anyone know if the update (Version 1.2.6690.34729 (Build 22.214.171.1242), Released: April 27, 2018) fixes this issue?
The Hidden expression for the text box ‘NumOfReports’ contains an error: Request failed. (rsProcessingError)
Thank you for the reply. The true and false statement isn't needed as of yet but for future maybe. I've also tried
Sum(Fields!NumOfReports.Value, "Met") < 1 with no luck of getting PowerBi to work. I was told that the method worked before the update to Version 1.2.6660.39920 (Build 126.96.36.1999). Just wondering if the latest update would fix this issue I'm having.
As of now I have tried the following scripts with no luck:
=Iif((CountRows("Met") < 1), True, False)
=True=isnothing(First(Fields!NumOfReports.Value, "Met") < 1)
This is leading me to think it's a bug with the updated version we are currently using (Version 1.2.6660.39920 (Build 188.8.131.529)).
Once again thank you for you reply.