Some Expressions

***In Lakhs*****

=iif(Parameters!Dataset1_InLakhs.Value="Yes","Amount (In Lakhs)","Amount (In Rs.)")

*****************

userinfo userinfo1

 select userInfo1

            where userInfo1.id == _RepModiMemoHeader.createdBy;

*******************

header condition for null

=IIF(Parameters!ListRescheduling_Customer_Account.Value = "","All",First(Fields!CustName.Value, "ListRescheduling"))

=IIF(Parameters!IntRateWiseOut_CustAccount.Value  = "","For All Customers","For " + First(Fields!CustName.Value, "IntRateWiseOut"))

**************************

Page number

=Labels!@SYS7426 & space(1) & Globals!PageNumber & space(1) & Labels!@SYS92595 & space(1) & Globals!TotalPages

***************************

****************************

=Right(Cstr(format((abs(Fields!CostofAcq.Value)),

"##\,##\,##\,##\,##\,##\,##0.00")),

 Len(CStr(Format((abs(Fields!CostofAcq.Value)),"N2"))))

*****************************

CLASS NAME : INFO

(for all form exception errors)

*************

info syntax :

info(strFmt("value: %1", yourTable.TheColumn));

********************

limited Records

  static void limitedRecords(Args _args)

  {

  FiscalCalendarYear FCY;

  FiscalYearName     FYN;

  int myCounter;

  ;

  while select FCY

    {

      myCounter++;

                      if (myCounter == 6)

                      {

                  

                         break;

                      }

   info(strFmt("value: %1", fcy.Name));  

      

    }

  }

*******************************************

      update_recordSet proposal1

    setting borrowertype = BorrowerType::DC

    where proposal1.CustAccount == "S10002"

*****************

"display Zero instead of null"

=iif(isnothing(Sum(Fields!IBL.Value)),0,Sum(Fields!IBL.Value))

**************************************

Active Method

  if(ITLLNDMtable.CumalativeDmActive == NoYes::Yes)

        {//&& ITLLNDMtable.PropsalType  == ITLLNParameters::find().PropsalTypeWC)

       ITLLNDMtable_ds.object(fieldNum(ITLLNDMtable,ReleaseAmount)).visible(false);

       ITLLNDMtable_ds.object(fieldNum(ITLLNDMtable,ReleaseAmountText)).visible(true);