Skip to main content

Basic SSRS Expressions

Basic SSRS Expressions 







1.To add current date and time in report use the follwing code


now =Format(Now(), "MM/dd/yyyy hh:mm tt")


2.To add total number of pages after the page number use the following code


now ="Page "&Globals!PageNumber &" of "&Globals!TotalPages


3.To print date:


Format(Now, "dd/MM/yyyy")


4.To print time:


Format(Now, "hh:mm tt")


5.To print datetime use the following code:


=Format(Now, "dd/MM/yyyy") & vbCrLf & Format(Now, "hh:mm tt")


6.To print time depends on different time zones use the following code:


=Microsoft.Dynamics.Framework.Reports.DataMethodUtility.ConvertUtcToAxUserTimeZoneForUser(Parameters!AX_CompanyName.Value, Parameters!AX_UserContext.Value, System.DateTime.UtcNow, "d", Parameters!AX_RenderingCulture.Value) & vbCrLf & Microsoft.Dynamics.Framework.Reports.DataMethodUtility.ConvertUtcToAxUserTimeZoneForUser(Parameters!AX_CompanyName.Value, Parameters!AX_UserContext.Value, System.DateTime.UtcNow, "t", Parameters!AX_RenderingCulture.Value)


Labels:

Comments

Post a Comment

Popular posts from this blog

Total Amount of Purchase Order in X++

Method 1:  public AmountCur totalAmount()        // PurchLine       purchLine;         AmountCur       amountCur = 0;         while select crosscompany purchLine             index hint PurchLineIdx             where purchLine.PurchId         == purchtables.PurchId               && !purchLine.IsDeleted         {            // amountCur += purchLine.calcLineAmountExclTax(purchLine.PurchQty );                             amountCur += purchLine.calcLineAmount(purchLine.PurchQty + purchLine.ConfirmedTaxAmount );                          }         return amo...
Post a Comment
Read more

Change Company

change company helps to chnage the value of our field on the mark of the entity value  suppose you are overding a value in 3005 when you change to 1005 and click button the value changes in 1005 too   class LegalEntityRestriction_FYCDeleteExistingEntries     {         /// <summary>         ///         /// </summary>         /// <returns></returns>         public boolean modified()         {             boolean ret;                      //ret = super();             LedgerParameters ledgerparameter;                  ret = super();             if(LegalEntityRestriction_FYCDeleteExistingEntries.valueStr( ) == enum2Str(NoYes::Yes))   ...
Post a Comment
Read more

Chain of Command

Chain of command is used to write extension of code for a standard Table or Form which we need to be overwrite and make changes according to ours   Chain of command can be used in the following objects 1.Classes 2.Tables 3.Forms 4.Data source on a form. 5.Data field on a form. 6.Control of a form. 7.Data entities Steps to Follow in COC Step1: Name of the chain of command class we create must end with the _Extension. Step2: The keyword ‘final’ must be used in the class definition line. Step3: The class needs to have the attribute        [ExtensionOf(classStr(<NameOfBaseObject>))]    The “ classStr ” text above will change depending on the type of base objecting you are extending. -> Below are the extensions used based on where we are using chain of commands.  -> When extending a class, use classStr(<NameofBaseClass>) -> When extending a table, use tableStr(<NameOfBaseTable>) -> In the case of a form, use formStr(...
Post a Comment
Read more