SSRS Report using Controller , Contract and RDP classes in D365

By -

STEP 1 : Create new TEMP table
STEP 2 : Create query.
STEP 3 : Create a Contract class

 [DataContractAttribute]
class SMJ_PerdiemContract
{
    PerdiemStatus    perdiemstatus;

     [DataMemberAttribute(identifierStr(PerdiemStatus)),
        SysOperationLabelAttribute ("Perdiem status"),
        SysOperationHelpTextAttribute("Perdiem status"),
        SysOperationDisplayOrderAttribute("1")]
        public PerdiemStatus parmPerdiemStatus(PerdiemStatus _PerdiemStatus = perdiemstatus)
    {
        perdiemstatus = _PerdiemStatus;
        return perdiemstatus;
    }

 }

 STEP 4 : Create a DP class:

 [SRSReportQueryAttribute(queryStr(SMJ_PerdiemReport)), // query 
SRSReportParameterAttribute(classStr(SMJ_PerdiemContract))]// contract class
    public class SMJ_PerdiemDP extends SRSReportDataProviderBase
{

     SMJ_PerdiemTableTempDB  perdiemTableTempDB;
    PerdiemStatus           perdiemStatus;   
    PerdiemRequestID        PerdiemRequestID;
    
    public Query buildQuery(Query _query ,PerdiemRequestID _perdiemRequestID , PerdiemStatus _perdiemStatus)
        {
            if(_perdiemRequestID)
            _query.dataSourceTable(tableNum(PerdiemHeader),1).addRange(fieldNum(PerdiemHeader, PerdiemRequestID)).value(_perdiemRequestID);

             if(_perdiemStatus)
            _query.dataSourceTable(tableNum(PerdiemHeader),1).addRange(fieldNum(PerdiemHeader, PerdiemStatus)).value(queryValue(_perdiemStatus));
            return _query;
        }

         private void getReportParameters()
        {
            SMJ_PerdiemContract PerdiemContract = this.parmDataContract();
            perdiemStatus = PerdiemContract.parmPerdiemStatus();
            
           
        }
          [ SRSReportDataSetAttribute(tableStr(SMJ_PerdiemTableTempDB)) ]
        public SMJ_PerdiemTableTempDB getTempData()
        {
            select perdiemTableTempDB;
            return perdiemTableTempDB;
        }

         private void insertTempData(PerdiemHeader  perdimeHeader, PerdiemLine    perdiemLine)
        {

             perdiemTableTempDB.PerdiemRequestID                   = perdimeHeader.PerdiemRequestID;
            perdiemTableTempDB.EmplNum                                 = perdimeHeader.EmplNum;
            perdiemTableTempDB.EmplName                                = perdimeHeader.EmplName;
            perdiemTableTempDB.ApplicationDate                        =perdimeHeader.ApplicationDate;
            perdiemTableTempDB.PerdiemStatus                           = perdimeHeader.PerdiemStatus;
            perdiemTableTempDB.PurposeOfTravelForPerdiem    = perdimeHeader.PurposeOfTravelForPerdiem;
            perdiemTableTempDB.CountryRegionId                      = perdiemLine.CountryRegionId;
            perdiemTableTempDB.CurrencyCode                           = perdiemLine.CurrencyCode;
            perdiemTableTempDB.StartDate                                   = perdiemLine.StartDate;
            perdiemTableTempDB.EndDate                                    = perdiemLine.EndDate;
            perdiemTableTempDB.TotalNoOfDay                          = perdiemLine.TotalNoOfDay;
            perdiemTableTempDB.TotalAmount                             = perdiemLine.TotalAmount;
            perdiemTableTempDB.UserID                                      = curUserId();
            CompanyInfo = CompanyInfo::find();// Get company information.
            perdiemTableTempDB.ComLogo= CopanyImage::findByRecord(companyInfo).Image;//get current company logo.
            perdiemTableTempDB.insert();
        }

         public void processReport()
        {
            PerdiemHeader  perdimeHeader;
            PerdiemLine    perdiemLine;
            QueryRun queryRun;
            this.getReportParameters();
            queryRun = new QueryRun(this.buildQuery(this.parmQuery(),PerdiemRequestID,perdiemStatus));
            while (queryRun.next())
            {
                perdimeHeader = queryRun.get(tableNum(PerdiemHeader));
                perdiemLine   = queryRun.get(tableNum(PerdiemLine));
                this.insertTempData(perdimeHeader,perdiemLine);
            }
        }
}

 STEP 5 : Create a controller class:

 class SMJ_PerdiemReportController extends SrsReportRunController
{
    #define.ReportName('SMJ_PerdiemReport.PerdiemRequest')// Report name
    SMJones_PerdiemContractClass SMJ_PerdiemContract;
    //SMJ_PurchaseOrder SMJ_PurchaseOrder ;
    PerdiemHeader     perdiemheader;
            //protected void prePromptModifyContract() //Pass parameter to contract
            //{
            //    if (this.parmArgs() &&  this.parmArgs().record() && this.parmArgs().dataset() == tableNum(PerdiemHeader))
            //    {
            //        perdiemheader = this.parmArgs().record();
            //    }
            //    if (!SMJ_PerdiemContract)
            //    {
            //        SMJ_PerdiemContract = this.parmReportContract().parmRdpContract();
            //    }
            //    SMJ_PerdiemContract.parmPerdiemRequestID(perdiemheader.PerdiemRequestID);
            //    super();
            //}

     public void setRange(Args _args, Query _query) //set range to query
    {
        QueryBuildDataSource qbds;
        QueryBuildRange qbr;
        if (_args && _args.dataset())
        {
            switch(_args.dataset())
            {
                case tableNum(PerdiemHeader) :
                    perdiemheader = _args.record();
                    break;
            }
        }
        qbds = _query.dataSourceTable(tableNum(PerdiemHeader));
        qbds.clearRanges();
        if (!qbr)
        {
            qbr = qbds.addRange(fieldNum(PerdiemHeader, PerdiemRequestID));
        }
        if(perdiemheader)
        {
            qbr.value(perdiemheader.PerdiemRequestID);
        }

     }

     public boolean showQueryValues(str parameterName)
    {
        return true;
    }

     public static SMJ_PerdiemReportController construct(Args _args)
    {
        SMJ_PerdiemReportController controller=new SMJ_PerdiemReportController();
        controller.parmArgs(_args);
        return controller;
    }

     public static void main(Args _args)
    {
        SMJ_PerdiemReportController controller = new SMJ_PerdiemReportController();
        controller.parmReportName(#ReportName);
        controller.parmArgs(_args);
        controller.setRange(_args,               controller.parmReportContract().parmQueryContracts().lookup(controller.getFirstQueryContractKey()));
        controller.parmShowDialog(false);// if give true contract class dialog will show.
        controller.startOperation();
    }
}

 Contract class dialog:
          user can give data for filter purpose.

Output:


1 Get current company name:
=Microsoft.Dynamics.Framework.Reports.DataMethodUtility.GetFullCompanyNameForUser(Parameters!AX_CompanyName.Value, Parameters!AX_UserContext.Value) 

 write this code in report design «Expr» expression.

 2 Page number:
="Page " & space(1) &Globals!PageNumber &" of "&Globals!TotalPages    

 3 Get time and date:
=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)

 write this code in report design «Expr» expression.
   
I'm a technical developer that has been doing Microsoft Dynamics 365 development since 2018

Comments

Post a Comment

Popular posts from this blog

Exporting data to Excel through X++ code

By -
             Sometimes we need to export data from Microsoft Dynamics 365 to Excel using x++ code. Through this post can see how to export data from form to excel class SMJ_ExportData {     public static void main( Args args)     {         PurchParmLine   PurchParmLine,PurchParmLineSelect;         PurchParmLine = args.record();         DocuFileSaveResult saveResult = DocuFileSave ::promptForSaveLocation( "@ApplicationPlatform:Testingexcelexport ", "xlsx" , null , "Testing excel export" );         if (saveResult && saveResult.parmAction() != DocuFileSaveAction ::Cancel)         {             saveResult.parmOpenParameters( 'web=1' );             saveResult.parmOpenInNewWindow( false );             System.IO. Stream workbookStream = new System.IO. MemoryStream ();             System.IO. MemoryStream memoryStream = new System.IO. MemoryStream ();                    using ( var package = new Of
Read more

COC for Form level method

By -
We can extend the logic of public and protected methods without having to use event handlers. COC, allows to use the method local and global variables. COC must be end with _Extension. Form level method : System search there are any extend methods , If Extend method is exist,run COC method first , next() method Invoke Standard form methods . Override Method: [ ExtensionOf ( formstr ( CustTable ))]     final class CustTableForm_Extension     {         public void init()         {             // here add the business logics             next init();             // here add the business logics         }     } Get buffers : FormRun formRun = this as   FormRun ;     FormDataSource CustTable_DS =formRun.datasource(ForomDatasourceStr(CustTable,CustTable));     CustTable custTable = CustTable_DS.Cursor();     FormControl custAccount = formRun.design().ControlName( FormControlStr ( FormName ,ControlName));        Example:
Read more

How to pass the parameter from one form to another in Dynamic365

By -
1. Create two forms with Name FormA & FormB   2. Below code is override in clicked method() of button. void  clicked() {      // Args class is usually used in Axapta for passing parameters between forms      Args             args;      FormRun          formRun;     ;     args =  new   args ();      // Our values which we want to pass to FormB      // If we want pass just simple string we can use 'parm' method of 'Args' class like     args.parm(  LeaveRequestID.text() );      // If we want pass whole record we can use 'parm' method of 'Args' class        args.record(TableName);      // Run FormB     args.name(  formstr ( FormB ) );     formRun = classFactory.formRunClass( Args );     formRun.init();     formrun.run();     formrun.wait();      super (); } 3. Now override init() method in FormB. public   void  init() {      str             anyStringValueFromCaller;      TableName       tablename;
Read more

Multi Select Lookup in SSRS Report in D365

By -
Multi Select Lookup in SSRS Report in D365 Description:-  Here we will create multi select lookup in ssrs report so we can select multiple data from lookup. Here I have given sample demonstration for how to generate multi select lookup in ssrs report. First, you must create contract class for that and create method for parameters. Contract Class: - [DataContractAttribute, SysOperationContractProcessingAttribute( classstr (SampleUIBuilder))] class SampleContract implements SysOperationValidatable {     List   ListItemId; [DataMemberAttribute( "Item Id" ),AifCollectionTypeAttribute( "Item Id" , Types ::String),        SysOperationLabelAttribute( literalStr ( "Item Id" ))]        public List parmItemId( List _ListItemId = ListItemId) {               ListItemId = _ListItemId;               return ListItemId; } } //For validation parameters,     public boolean validate()     {         boolean              is
Read more