Accessing page numbers in SSRS report body

This post demonstrate how to access page numbers in SSRS report body AX 2012/AX 7/ Dynamics 365. 

1. Goto Report à Report Properties à Code in Visual studio

2. Write the below logic in code

Public Function PageNumber() as String

     Dim str as String

     str = Me.Report.Globals!PageNumber.ToString()

     Return str

End Function

Public Function TotalPages() as String

     Dim str as String

     str = Me.Report.Globals!TotalPages.ToString()

     Return str

End Function

3.  Create a text box and the below expression

=Cstr(Code.PageNumber()) & Space(2) & Labels!@SYS26401 & space(2) & Cstr(Code.TotalPages())

4. Example output 1 of 4

Display or edit methods in Dynamics 365 or AX7

New Display or Edit method need to write in extension class.

In the below code is the example for display method in CustTable extension.

[ExtensionOf(tablestr(CustTable))]

final class CustTableEventHandlers_Extension

{

    [SysClientCacheDataMethodAttribute(true)]

    display RetailLoyaltyCardNumber primaryLoyaltyNumber()

    {

        RetailLoyaltyCard   retailLoyaltyCard;

        select firstonly CardNumber from retailLoyaltyCard

            where retailLoyaltyCard.Party == this.party

                && retailLoyaltyCard.Primary == NoYes::Yes;

        return retailLoyaltyCard.CardNumber;

    }

}

After writing logic we need to assign this method to the control in Form.

Set control properties "data method" in the below format

“ExtensionClassName::MethodName”

Lookups in Dynamics 365 or AX7

Lookups are almost same as AX 2012 but need to write in extension class. Need to copy the event handler and paste in Class and write the same logic as AX 2012.

https://ranjithdax.blogspot.in/2015/01/creation-of-sys-look-in-microsoft.html (AX 2012)

Will get different lookup scenarios one of the scenario is
Scenario: How to filter lookup based on one field value in Dynamics 365.

So 1st  need to get the value of the field value to pass as a range, for that need to get the control value from FORM.

The below code is used to get the filtered lookup based on the other field value.

  [FormControlEventHandler(formControlStr(RetailLoyaltyCards, RetailLoyaltyCard_AuthorizedUser), FormControlEventType::Lookup)]

    public static void RetailLoyaltyCard_AuthorizedUser_OnLookup(FormControl sender, FormControlEventArgs e)

    {

        SysTableLookup sysTableLookup = SysTableLookup::newParameters(tableNum(DirPartyPostalAddressView), sender);

        QueryBuildDataSource            queryBuildDataSource;

        Query                           query;

        FormRun                         formRun;

        FormControl                     formCtrl;

       

        formRun = sender.formRun();

        formCtrl = formRun.design().controlName(formControlStr(RetailLoyaltyCards, RetailLoyaltyCard_Party2));

        sysTableLookup.addLookupfield(fieldNum(DirPartyPostalAddressView, LocationName), true);

        query = new Query();

        queryBuildDataSource = query.addDataSource(tableNum(DirPartyPostalAddressView));

        queryBuildDataSource.addRange(fieldNum(DirPartyPostalAddressView, Party)).value(SysQuery::value(str2Int64(formCtrl.valueStr())));

          

        sysTableLookup.parmQuery(query);

        sysTableLookup.performFormLookup();

    }

Create extensions or over layering in Dynamics 365 for operations or AX7

Go through the below link for better understanding about extensions and over layering in Dynamics 365 for Operations.

https://docs.microsoft.com/en-us/dynamics365/operations/dev-itpro/extensibility/customization-overlayering-extensions

Request for the permission of type 'FileIOPermission' failed.

Problem: Generally while working with files we might get the below errors

Request for the permission of type 'FileIOPermission' failed.

(S)\Classes\FileIOPermission\demand
(S)\Classes\WinAPIServer\fileExists- line 11 

or 

Request for the permission of type 'FileIOPermission' failed.

(S)\Classes\FileIOPermission\demand

(S)\Classes\WinAPIServer\deleteFile- line 11 

Solution: 

Set permissionSet;

FileName fileName = ''Test.Xml"; 

permissionSet = new Set(Types::Class);

permissionSet.add(new InteropPermission(InteropKind::ClrInterop));
permissionSet.add(new FileIOPermission(fileName , 'rw'));
CodeAccessPermission::assertMultiple(permissionSet);

 if (WINAPIServer::fileExists(fileName))

    {

        if (Box::yesNo(strfmt("Do you want to re-write the file", filename), DialogButton::No))

        {

            WINAPIServer::deleteFile(filename);

         }

        else

        {

            return;

        }

    }

CodeAccessPermission::revertAssert();

A copy will also require FileIOPermission of 'r' on the source file.  A Move will require a permission of 'w' on the source.

Microsoft.Dynamics.Ax.Xpp.InvalidRemoteCallException’ was thrown

Problem: While working on Files using WinAPI got the below error.

Microsoft.Dynamics.Ax.Xpp.InvalidRemoteCallException’ was thrown

Solution:

Change WinAPI to WinAPIServer

Example:

WINAPI::fileExists(fileName) to WINAPIServer::fileExists(fileName)

WINAPI::deleteFile(filename) to WINAPIServer::deleteFile(filename)

Phone number validation in Microsoft dynamics AX 2012

The below code is used to validate the Phone number.

public boolean validateField(FieldId _fieldIdToCheck)
{
    boolean ret;
    Str         phonePattern = @"[0-9]";
 
    System.Text.RegularExpressions.Match  myMatch;

    ret = super(_fieldIdToCheck);

    if (_fieldIdToCheck == fieldNum(PracticeDemo, PhoneMobile))
    {
        myMatch = System.Text.RegularExpressions.Regex::Match(this.PhoneMobile, phonePattern);
         
        if (strLen(this.PhoneMobile)<10 || strLen(this.PhoneMobile)>10)
        {
            ret = checkFailed(strFmt("%1 please enter 10 digit mobile number", this.PhoneMobile));
        }
         
        if (!myMatch.get_Success())
        {
            ret = checkFailed(strFmt("%1 is not an valid phone number", this.PhoneMobile));
}
    }

    return ret;
}