Table Row Visibility by value
=iif(Fields!PctQuota.Value>.9, False, True)
Field Visibility when data is null
=iif(Fields!vendorSolicitor.Value Is Nothing, True, False)
Set Data Field Values
=iif(Fields!ExchangeDate.Value Is Nothing,"",FormatDateTime(Fields!ExchangeDate.Value ,2))
SWITCH
=Switch
(
Fields!PropertyCategory.Value="N" and sum(Fields!newHouseCount.Value) > 0, sum(Fields!newHouseCount.Value),
Fields!PropertyCategory.Value="E" and sum(Fields!estHouseCount.Value) > 0, sum(Fields!estHouseCount.Value)
)
Format date
=iif(Fields!ExchangeDate.Value Is Nothing,"",FormatDateTime(Fields!ExchangeDate.Value ,2))
Format Decimal values(Drop decimal places than rounding)
=FormatCurrency(Floor(Sum(Fields!ExpectedAgencyCommission.Value)),0)
1 comment:
On some stages this impossible for you, that you cannot be able to visualize your data into graphical from because it has many points and you not be able t o mange these pints in proper form for visualization, but when you check this https://activewizards.com/, you will get the data scientist which are specially trained for the purpose data visualization and they can easily solve your every kind of data problem.
Post a Comment