87) Create a Query based SSRS Report and pass the current buffer using controller class

-

  I had a scenario where I need to create a query based report and pass the current record to filter the report.


Step 1:- Create a query and create a design of it 


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


Step 2 :- Create a controller class to identify the current form name and pass the range in it 


// <summary>

/// The <c>AvaFieldWorkOrderController</c> class is the controller class for the <c>AvaFieldWorkOrderQueryReport</c> SSRS report.

/// </summary>

public class AvaFieldWorkOrderController extends SrsReportRunController

{

    EntAssetWorkOrderTable  workOrderTable;

    


    /// <summary>

    /// Gets the report controller query.

    /// </summary>

    /// <returns>

    /// The report controller query.

    /// </returns>

    public Query getQuery()

    {

        return this.parmReportContract().parmQueryContracts().lookup(this.getFirstQueryContractKey());

    }


    protected void prePromptModifyContract()

    {

        //EntAssetWorkOrderTable  workOrderTable;

        CompanyImage            companyImage;

        Query                   query;

        QueryBuildDataSource    ds;

        QueryBuildRange         range;


        super();

    

        if (this.parmArgs().record())

        {

            workOrderTable = this.parmArgs().record() as EntAssetWorkOrderTable;

            

            if (workOrderTable)

            {

                query = this.getQuery();

    

                ds = query.dataSourceTable(tableNum(AvaFieldWorkOrderReportView));

                ds.clearRanges();

    

                range = SysQuery::findOrCreateRange(ds, fieldNum(AvaFieldWorkOrderReportView, WorkOrderId));

                range.value(SysQuery::value(workOrderTable.WorkOrderId));

            }


        }

        

    }


    public static AvaFieldWorkOrderController construct()

    {

        return new AvaFieldWorkOrderController();

    }


    public static void main(Args _args)

    {

        SRSPrintDestinationSettings     settings;

        AvaFieldWorkOrderController  controller = AvaFieldWorkOrderController::construct();

    

        controller.parmArgs(_args);

        controller.parmReportName(ssrsReportStr(AvaFieldWorkOrderQueryReport, Report));

       

     //  controller.parmReportRun().parmReportContract().parmReportCaption("VINAY");

        if (_args.record())

        {

            controller.parmShowDialog(false);

            controller.prePromptModifyContract();

            controller.run();

        }

        else

        {

            controller.startOperation();

        }

    }


    public LabelType parmDialogCaption(LabelType _dialogCaption = reportDialogCaption)

    {

        LabelType   reportDialogCaptionLoc =  super();

       // str         fileName = this.parmReportContract().parmReportCaption();


        this.parmReportContract().parmReportCaption("@AvaTransMountain:AvaFieldWorkOrderReport_Label" + " : "  + workOrderTable.WorkOrderId);


        return reportDialogCaptionLoc;

    }


}


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


Step 3 :- create a action menu item and define the controller class and place in the form menu item 


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