How to Run a Docentric SSRS Report from Code

You can print a Docentric SSRS report from X++ using the standard approach of running an SSRS report from the code. The only difference is that you have to additionally specify that the target print destination is Docentric Screen/File/Email/Printer/Print Archive and set the corresponding settings.

To achieve some custom scenarios such as sending report to a web service, you can use Docentric Memory print destination to print report to a memory stream or container, and handle it from there as needed.
Learn how >>

Generate and save Customer Invoice to Azure Blob storage

In the following example we are going to generate Customer Invoice using its built-in SSRS report design and save it to Azure Blob storage using the Docentric File print destination.

public static void printSalesInvoice_useOriginalDesign()
{
    SalesInvoiceController     salesInvoiceController;
    SalesInvoiceContract       salesInvoiceContract;
    Args                       args = new Args();
    CustInvoiceJour            custInvoiceJour;
    SalesInvoiceJournalPrint   salesInvoiceJournalPrint;

    select firstonly custInvoiceJour where custInvoiceJour.SalesId != '';

    // Add record to be printed.
    // In order to have the context table we need to set args.record().
    args.record(custInvoiceJour);

    salesInvoiceController = SalesInvoiceController::construct();
    salesInvoiceController.parmReportName(
        PrintMgmtDocType::construct(PrintMgmtDocumentType::SalesOrderInvoice).getDefaultReportFormat());

    salesInvoiceContract = salesInvoiceController.parmReportContract().parmRdpContract();
    salesInvoiceContract.parmCountryRegionISOCode(SysCountryRegionCode::countryInfo());
    salesInvoiceController.parmArgs(args);
    salesInvoiceController.parmExecutionMode(SysOperationExecutionMode::Synchronous);

    // Set print destinations.
    SRSPrintDestinationSettings pds = salesInvoiceController.parmReportContract().parmPrintSettings();
    pds.printMediumType(SRSPrintMediumType::File_DC);
    pds.parmFilePrintDestSettings_DC().parmOutputFilename('SalesInvoice_@FIELD_InvoiceId@.xlsx');
    pds.parmFilePrintDestSettings_DC().parmOutputFileFormatSrs(SRSReportFileFormat::Excel);

    // Save to Azure Blob storage.
    pds.parmFilePrintDestSettings_DC().parmSendOutputFileToUser(false);
    pds.parmFilePrintDestSettings_DC().parmSaveToAzureBlobStorage(true);
    pds.parmFilePrintDestSettings_DC().parmAzureBsContainerName('docentric-report-output');
    pds.parmFilePrintDestSettings_DC().parmAzureBsBlobPath('@COMPANYID@/Invoices');
    pds.parmFilePrintDestSettings_DC().parmAzureBsOverrideFileIfExists(true);

    // Use the original SSRS design.
    pds.parmFilePrintDestSettings_DC().parmUseSsrsBuiltInDesign(true);
    pds.parmSrsPrintReportSettings_DC().setProperty_PrintSrsOriginalDesign(true);

    /* Use the default Docentric design */
    //pds.parmSrsPrintReportSettings_DC().setProperty_PrintSrsOriginalDesign(false);
    //pds.parmFilePrintDestSettings_DC().parmUseSsrsBuiltInDesign(false);
    //pds.parmFilePrintDestSettings_DC().parmOutputFilename('SalesInvoice_@FIELD_InvoiceId@.pdf');
    //pds.parmFilePrintDestSettings_DC().parmOutputFileFormat(DocOutputFileFormat::PDF);
    
    
    // Initalize SalesInvoiceJournalPrint class instance because there is no other way
    // NOT to use Print Management.
    salesInvoiceJournalPrint = SalesInvoiceJournalPrint::construct();
    salesInvoiceJournalPrint.parmPrintFormletter(NoYes::Yes);
    salesInvoiceJournalPrint.parmUsePrintManagement(false);
    salesInvoiceJournalPrint.parmUseUserDefinedDestinations(true);
    salesInvoiceJournalPrint.parmPrinterSettingsFormLetter(salesInvoiceController.parmReportContract().parmPrintSettings().pack());

    args.caller(salesInvoiceJournalPrint);
    args.parmEnumType(enumNum(PrintCopyOriginal));
    args.parmEnum(PrintCopyOriginal::OriginalPrint);

    // Start the report execution.
    salesInvoiceController.parmShowDialog(false);
    salesInvoiceController.startOperation();
}

public static void printSalesInvoice_useOriginalDesign()

{

SalesInvoiceController salesInvoiceController;

SalesInvoiceContract salesInvoiceContract;

Args args = new Args();

CustInvoiceJour custInvoiceJour;

SalesInvoiceJournalPrint salesInvoiceJournalPrint;

select firstonly custInvoiceJour where custInvoiceJour.SalesId != '';

// Add record to be printed.

// In order to have the context table we need to set args.record().

args.record(custInvoiceJour);

salesInvoiceController = SalesInvoiceController::construct();

salesInvoiceController.parmReportName(

PrintMgmtDocType::construct(PrintMgmtDocumentType::SalesOrderInvoice).getDefaultReportFormat());

salesInvoiceContract = salesInvoiceController.parmReportContract().parmRdpContract();

salesInvoiceContract.parmCountryRegionISOCode(SysCountryRegionCode::countryInfo());

salesInvoiceController.parmArgs(args);

salesInvoiceController.parmExecutionMode(SysOperationExecutionMode::Synchronous);

// Set print destinations.

SRSPrintDestinationSettings pds = salesInvoiceController.parmReportContract().parmPrintSettings();

pds.printMediumType(SRSPrintMediumType::File_DC);

pds.parmFilePrintDestSettings_DC().parmOutputFilename('SalesInvoice_@FIELD_InvoiceId@.xlsx');

pds.parmFilePrintDestSettings_DC().parmOutputFileFormatSrs(SRSReportFileFormat::Excel);

// Save to Azure Blob storage.

pds.parmFilePrintDestSettings_DC().parmSendOutputFileToUser(false);

pds.parmFilePrintDestSettings_DC().parmSaveToAzureBlobStorage(true);

pds.parmFilePrintDestSettings_DC().parmAzureBsContainerName('docentric-report-output');

pds.parmFilePrintDestSettings_DC().parmAzureBsBlobPath('@COMPANYID@/Invoices');

pds.parmFilePrintDestSettings_DC().parmAzureBsOverrideFileIfExists(true);

// Use the original SSRS design.

pds.parmFilePrintDestSettings_DC().parmUseSsrsBuiltInDesign(true);

pds.parmSrsPrintReportSettings_DC().setProperty_PrintSrsOriginalDesign(true);

/* Use the default Docentric design */

//pds.parmSrsPrintReportSettings_DC().setProperty_PrintSrsOriginalDesign(false);

//pds.parmFilePrintDestSettings_DC().parmUseSsrsBuiltInDesign(false);

//pds.parmFilePrintDestSettings_DC().parmOutputFilename('SalesInvoice_@FIELD_InvoiceId@.pdf');

//pds.parmFilePrintDestSettings_DC().parmOutputFileFormat(DocOutputFileFormat::PDF);

// Initalize SalesInvoiceJournalPrint class instance because there is no other way

// NOT to use Print Management.

salesInvoiceJournalPrint = SalesInvoiceJournalPrint::construct();

salesInvoiceJournalPrint.parmPrintFormletter(NoYes::Yes);

salesInvoiceJournalPrint.parmUsePrintManagement(false);

salesInvoiceJournalPrint.parmUseUserDefinedDestinations(true);

salesInvoiceJournalPrint.parmPrinterSettingsFormLetter(salesInvoiceController.parmReportContract().parmPrintSettings().pack());

args.caller(salesInvoiceJournalPrint);

args.parmEnumType(enumNum(PrintCopyOriginal));

args.parmEnum(PrintCopyOriginal::OriginalPrint);

// Start the report execution.

salesInvoiceController.parmShowDialog(false);

salesInvoiceController.startOperation();

}

CONTENTS

How to Run a Docentric SSRS Report from Code

IN THIS ARTICLE

Generate and save Customer Invoice to Azure Blob storage

See also

IN THIS ARTICLE