71) How to create a SSRS Report using the contract and Dp class

-

  I had a scenario where I need to create a SSRS report using the Dp Class :- 


Step 1 :- Create a contract class to define the parameter for the user input :- 

class AvaEntAssetChecklistReportContract

{

    TransDate          fromDate;

    TransDate          toDate;

    EntAssetObjectID   assetID;

     

    

    /// <summary>

    /// Gets or sets the value of the datacontract parameter RecordId.

    /// </summary>

    /// <param name="_recordId">

    /// The new value of the datacontract parameter fromDate; optional.

    /// </param>

    /// <returns>

    ///  The current value of datacontract parameter fromDate

    /// </returns>

    [DataMemberAttribute('From date')]

    public TransDate parmFromDate(TransDate _fromDate = fromDate)

    {

        fromDate = _fromDate;

        return fromDate;

    }


    /// <summary>

    /// Gets or sets the value of the datacontract parameter RecordId.

    /// </summary>

    /// <param name="_toDate">

    /// The new value of the datacontract parameter toDate; optional.

    /// </param>

    /// <returns>

    ///  The current value of datacontract parameter toDate

    /// </returns>

    [DataMemberAttribute('To date')]

    public TransDate parmToDate(TransDate _toDate = toDate)

    {

        toDate = _toDate;

        return toDate;

    }


    /// <summary>

    /// Gets or sets the value of the datacontract parameter In-house bank.

    /// </summary>

    /// <param name="_vendAccount">

    /// The new value of the datacontract parameter assetID; optional.

    /// </param>

    /// <returns>

    ///  The current value of datacontract parameter assetID

    /// </returns>

    [DataMemberAttribute('AssetID')]

    public EntAssetObjectID parmAssetID(EntAssetObjectID _assetID = assetID)

    {

        assetID = _assetID;

        return assetID;

    }


}

=====================================================================


Step 2 :- Create a Dp class and fill the data in temp Table :- 


[

    SRSReportParameterAttribute(classStr(AvaEntAssetChecklistReportContract))

]

class AvaEntAssetChecklistReportDP extends SRSReportDataProviderBase

{

    AvaEntAssetChecklistTmp             assetChecklistTmp;

    AvaEntAssetChecklistReportContract  assetChecklistDetailContract;

    AvaEntAssetChecklistDetailView      entAssetChecklistView;


           

    [SRSReportDataSetAttribute(tableStr(AvaEntAssetChecklistTmp))]

    public AvaEntAssetChecklistTmp getAvaEntAssetChecklistTmp()

    {

        select assetChecklistTmp;

        return assetChecklistTmp;

    }


    public void processReport()

    {

        

        TransDate                       fromDate;

        TransDate                       toDate;

        EntAssetObjectID                assetID;

        RecordInsertList                checkListDetailToBeInserted = new RecordInsertList(tableNum(AvaEntAssetChecklistTmp),

                                                                                           true, // skip insert

                                                                                           true, // skip database log

                                                                                           true, // skip events

                                                                                           true, // skip aos validation

                                                                                           false, // skip RLS validation

                                                                                           assetChecklistTmp);


        assetChecklistDetailContract = this.parmDataContract() as AvaEntAssetChecklistReportContract;


        fromDate = assetChecklistDetailContract.parmFromDate();

        toDate   = assetChecklistDetailContract.parmToDate();

        assetID  = assetChecklistDetailContract.parmAssetID();


        while select entAssetChecklistView

            where entAssetChecklistView.ObjectID == assetID

            && entAssetChecklistView.RegisteredDateTime >= DateTimeUtil::newDateTime(fromDate, 0)

            && entAssetChecklistView.RegisteredDateTime <= DateTimeUtil::newDateTime(toDate, 86399)


        if(entAssetChecklistView)

        {

            assetChecklistTmp.ObjectID           = assetID;

            assetChecklistTmp.ChecklistName      = entAssetChecklistView.ChecklistName;

            assetChecklistTmp.ChecklistValue     = entAssetChecklistView.ChecklistValue;

            assetChecklistTmp.RegisteredDateTime = entAssetChecklistView.RegisteredDateTime;

            assetChecklistTmp.CreatedWorkerName  = entAssetChecklistView.CreatedWorkerName;

            assetChecklistTmp.WorkOrderId        = entAssetChecklistView.WorkOrderId;


            checkListDetailToBeInserted.add(assetChecklistTmp);

        }


        ttsbegin;

        checkListDetailToBeInserted.insertDatabase();

        ttscommit;

        

    }


}


Step 3 :- Create a report and create a output menu item and define the report name and design build and syc and run the report


=======================================================================


Comments

Post a Comment

Popular posts from this blog

Customization on Sales invoice Report in D365 F&O

-
 We have a requirement to create a new design and show some new fields in the sales invoice report.  So for that we need to consider the below steps :-  1) Controller class than extends standard class and create alogic. 2) Create a print management class to call the new design. 3) Extension of DP class to write a logic. 4) Report design. ==================================================================== 1) Controller class : -  /// <summary> /// Extension of the controller class to call the custom design of report "MMSSalesInvoice.report" for MMS legal entity. /// </summary> class MMSSalesInvoiceController extends SalesInvoiceController {        public static MMSSalesInvoiceController construct()         {             return new MMSSalesInvoiceController();         }         public static void main(Args _args)         { ...
Read more

75) COC - Create a coc of the table modified method

-
 /// <summary> /// The <c>AvaEntAssetChecklistVariableOptionsDbt_Extension</c> contains the TransMountain extending logic for the <c>EntAssetChecklistVariableOptions</c> table. /// </summary> [ExtensionOf(tableStr(EntAssetChecklistVariableOptions))] final class AvaEntAssetChecklistVariableOptionsDbt_Extension {     /// <summary>     /// Processes the modified field event for TransMountain fields.     /// </summary>     /// <param name = "_fieldId">reference to field id</param>     public void modifiedField(FieldId _fieldId)     {         EntAssetChecklistVariableOptions entAssetChecklistVariableOptions;         next modifiedField(_fieldId);         // Default must be marked for only one check list line for the varaible.         if (_fieldId == fieldNum(EntAssetChecklistVariableOptions,...
Read more

46) D365 FO: SHAREPOINT FILE UPLOAD USING X++

-
Image
Requirement : Uploading a file in Sharepoint online using X++ and inside from Microsoft Dynamics 365 finance and operations. Prerequisites: The current user id of Microsoft Dynamics 365 Finance and operations should have proper rights and privileged in Sharepoint Online. Sample Code: In this scenario i am creating a text file in Microsoft Dynamics 365 finance and operations and then uploading its memory Stream in Sharepoint online using X++ . You can modify the X++ code in D365 finance and operations as per your need. class RunnableClassRun { /// /// Runs the class with the specified arguments. /// /// The specified arguments. public static void main(Args _args) { System.UriBuilder builder = new System.UriBuilder(“ https://XXXXXX.sharepoint.com&#8221 ;); str extId = xUserInfo::getExternalId(); Microsoft.Dynamics.AX.Framework.FileManagement.SharePointDocumentStorageProvider provider; Microsoft.Dynamics.AX.Framework.FileManagement.DocumentLocation documentLocation ...
Read more