64) How to create report and initialed the contract value

-

Requirement :-  i am going to create a query based report and in that want to pass the range using the contract and controller class.


In this i will tell you how to hold the parameter value and pass in the class.


step 1 :- Create a query based report without any range mention in that and create simple report with the manually add the 3 parameter ( from date, To Date and AssetID)

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

Step 2 :- Create a contract Class :- 

[

SrsReportNameAttribute(ssrsReportStr(AvaEntAssetChecklistDetailReportCopy, Report))

]

public class TestSubReportContract extends SrsReportRdlDataContract

{

    public const str ParameterNameFromDate = 'FromDate';

    public const str ParameterNameToDate = 'ToDate';

    public const str ParameterNameAssetID = 'AssetID';


    FromDate            fromDate;

    ToDate              todate;

    EntAssetObjectID    assetID;


    [DataMemberAttribute('FromDate')]

    public FromDate parmFromDate(FromDate _fromDate =  DateTimeUtil::date(this.getValue(ParameterNameFromDate)))

    {

       // fromDate = _fromDate;

       this.setValue(ParameterNameFromDate, DateTimeUtil::newDateTime(_fromDate, 0));

        return _fromDate;

    }


    [DataMemberAttribute('Todate')]

    public todate parmToDate(ToDate _todate = DateTimeUtil::date(this.getValue(ParameterNameToDate)))

    {

       // todate = _todate;

       this.setValue(ParameterNameToDate, DateTimeUtil::newDateTime(_toDate,86399));

        return _toDate;

    }


    [DataMemberAttribute('AssetID')]

    public EntAssetObjectID parmAssetID(EntAssetObjectID _assetID =this.getValue(ParameterNameAssetID))

    {

       // assetID = _assetID;

       this.setValue(ParameterNameAssetID, _assetID);

        return _assetID;

    }


}


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


Step 3 :- Create a controller class and pass the range :-


class TestSubReportController extends SrsReportRunController

{

    #define.ReportName ('AvaEntAssetChecklistDetailReportCopy.Report')



    protected void preRunModifyContract()

    {

     //   TestSubReportContract  contract;


        var contract = this.parmReportContract().parmRdlContract() as TestSubReportContract;

        Query       query = this.parmReportContract().parmQueryContracts().lookup(this.getFirstQueryContractKey());


        FromDate    fromDate       = contract.parmFromDate();

        ToDate      toDate         = contract.parmToDate();

        EntAssetObjectID   AssetId = contract.parmAssetID();


        // Modify the query contract based on fromDate & toDate.

        SrsReportHelper::addFromAndToDateRangeToQuery(query,

                                                      fromDate,

                                                      toDate,

                                                      tableNum(AvaEntAssetChecklistDetailView),

                                                      fieldNum(AvaEntAssetChecklistDetailView, RegisteredDateTime));


        // Modify the query contract based on DepreciationBookId.

        //SrsReportHelper::addParameterValueRangeToQuery(query,

        //                                               tableNum(AvaEntAssetChecklistDetailView),

        //                                               fieldNum(AvaEntAssetChecklistDetailView, ObjectID),

        //                                               AssetId);





        super();

    }


    public static TestSubReportController construct(Args _args)

    {

        TestSubReportController controller = new TestSubReportController();

        controller.parmReportName(#ReportName);

        controller.parmArgs(_args);

        return controller;

    }


    public static void main(Args args)

    {

        TestSubReportController::construct(args).startOperation();

    }


}


+=====================================================================


Step 4 :- Create a action menu Itme and calls this  controller class there and run the report


Happy Daxing

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