Forum Discussion

Otey86's avatar
Otey86
Regular Visitor
8 years ago

SSRS to PowerBI

  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 Pow...
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Have you tried using 1 and 0 ? instead of True and False? alternatively is the case of true and false important?

Otey86's avatar
Otey86
Regular Visitor
8 years ago

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 15.0.2.389). 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)

=Sum(Fields!NumOfReports.Value, "Met")

=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 15.0.2.389)).

 

Once again thank you for you reply.