Generate and attach a SSRS report as PDF file in document attachment form through X++ code

By -

               Sometimes we face this requirement to attach a SSRS reports directly on attachment form. Following is the code that helps you to achieve.

        str                          fileName;
        String10                     Extension;
        Args                         _args;
        SRSPrintDestinationSettings  printerSettings;
        System.Byte[]                reportBytes = new System.Byte[0]();
        SRSProxy                     srsProxy;
        SRSReportRunService          srsReportRunService = new SrsReportRunService();
                Microsoft.Dynamics.AX.Framework.Reporting.Shared.ReportingService.ParameterValue[]  parameterValueArray;
        Map                          reportParametersMap;
        str                          reportnamerun;
        SRSReportExecutionInfo       executionInfo = new SRSReportExecutionInfo();
        System.IO.Stream             stream = null;
        _args = new Args();
        filename = strfmt('%1%2',_rentAgreement.AgreementId,'.pdf');
 
AgreementController ssrsController = new AgreementController();
        _args.record(agreementUnit);
        ssrsController.parmReportName(reportname);
        ssrsController.parmArgs(_args);
        ssrsController.setRange(_args, ssrsController.parmReportContract().parmQueryContracts().lookup(ssrsController.getFirstQueryContractKey()));
        ssrsController.parmShowDialog(false);
        printerSettings = ssrsController.parmReportContract().parmPrintSettings();
        //print to pdf and always overwrite if the file exists
        printerSettings.printMediumType(SRSPrintMediumType::File);
        printerSettings.fileFormat(SRSReportFileFormat::PDF);
        printerSettings.overwriteFile(true);
        printerSettings.fileName(filename);
   
        ssrsController.parmReportContract().parmReportServerConfig(SRSConfiguration::getDefaultServerConfiguration());
        ssrsController.parmReportContract().parmReportExecutionInfo(executionInfo);
   
        srsReportRunService.getReportDataContract(ssrsController.parmreportcontract().parmReportName());
        srsReportRunService.preRunReport(ssrsController.parmreportcontract());
        reportParametersMap = srsReportRunService.createParamMapFromContract(ssrsController.parmReportContract());
        parameterValueArray = SrsReportRunUtil::getParameterValueArray(reportParametersMap);
   
        srsProxy = SRSProxy::constructWithConfiguration(ssrsController.parmReportContract().parmReportServerConfig());
        // Actual rendering to byte array
        reportBytes = srsproxy.renderReportToByteArray(ssrsController.parmreportcontract().parmreportpath(),
                                                                      parameterValueArray,
                                                                      printerSettings.fileFormat(),
                                                                      printerSettings.deviceinfo());
 
 
 
        stream         = new System.IO.MemoryStream(reportBytes);
        System.IO.MemoryStream Memorystream = stream;
        if (Memorystream && Memorystream.Length > 0)
        {
            Memorystream.Position = 0;
            DocumentManagement::attachFile(CustTable.TableId, CustTable.RecId, CustTable.RefCompany,enum2Symbol(enumNum(SRSPrintMediumType), SRSPrintMediumType::File), Memorystream, filename,
                                                 classstr (FileUploadTemporaryStorageStrategy), "Cust account");
        }
 
 
I'm a technical developer that has been doing Microsoft Dynamics 365 development since 2018

Comments

Post a Comment

Popular posts from this blog

SSRS Report using Controller , Contract and RDP classes in D365

By -
Image
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 SRSReportDat...
Read more

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' );   ...
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...
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...
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;         ...
Read more