About Me

My photo
a Dynamic and Energetic guy.....

Thursday, August 12, 2010

SQL Server Reporting Services Expressions

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:

Nancy Garero said...

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.

My Masters