Forum Discussion
Visual Studio SSDT System.Security.Permissions.SecurityPermission
Today, I encountered one more error
Works: COUNTROWS("DataSet1_WithTextOrNumber")
Works: COUNTROWS("DataSet1_WithOnlyOneDateColumn")
Works: COUNTROWS("DataSet1")
Works: Parameters!FirstDate.Count
Works: JOIN(Parameters!FirstDate.Value," & ")
NOT Works:
a. Select SQL_Col_Date from table1 (Only one date column)
b. Add one more calculated field in report dataset as =Format(Fields!SQL_Col_Date.Value,"Short date")
c. using COUNTROWS("DataSet1_WithOnlyOneDateColumn_CalcColumn") inside an expression ... gives error!
= IIF(COUNTROWS("DataSet1").Equals(Parameters!FirstDate.Count)
,"All",JOIN(Parameters!FirstDate.Value," & "))
[SQL Server as datasource]. Hope microsoft will look into it!
Thanks