RDLC Report Definition Language Client Site Snippet

1. FormatDateTime to required Format

1. =FormatDateTime(Fields!OrderDate.Value, DateFormat.ShortDate)
2. =Format(now( ),"dd-MMM-yyyy HH:mm:ss tt")
3. =Format( Fields!CreateDate.Value, "dd-MMM-yyyy")
4. =FormatNumber(Sum(Fields!FinishQty.Value),0)
5. =FormatDateTime(Fields!DeliveryDate.Value, DateFormat.ShortDate) 

        For Printing Serial In RDLC

1. =RowNumber(Nothing)

     If Condition in RDLC

     =IIf(Parameters!UnitListId.Value = "6", "Color City Ltd.",                       
            IIf(Parameters!UnitListId.Value = "1", "Mymun Textile Ltd.", 
                 IIf(Parameters!UnitListId.Value = "2", "Hamza  Textile Ltd",
                       "Mymun Complex")))
    Switch case in RDLC
        = Switch( Fields!FlagGroup.Value =  0, "00-60 days",
          Fields!FlagGroup.Value =  1, "61-120 Days",
          Fields!FlagGroup.Value =  2, "121-180 Days",
          Fields!FlagGroup.Value =  3, "181-270 Days",
          Fields!FlagGroup.Value =  4, "271-365 Days",
          Fields!FlagGroup.Value = 5,  "More than 365 Days" ,

  1 = 1,                          "default value" )
   Formatting number to Desired Decimal Points:

    =FormatNumber(Sum(Fields!FinishQty.Value), 0)

  Iff condition in Function: 

   =FormatNumber( Sum(IIf(Fields!FlagColumn = 0, Fields!FinishQty.Value ,0 )    ),0)
   =IIf(Fields!FlagColumn = 0, FormatNumber( Sum(Fields!FinishQty), 0),0 )