How to create QR code in SSRS report in D365 F&O

-

 AxParadise.com

How to create QR code in SSRS report in D365 F&O

Even in the era of electronic reporting and PowerBI reporting, SSRS still plays a crucial role in D365 Finance & Operations ERP. SSRS report delivers most reports in ERP in a predefined format, which is beneficial for providing any legal document. For instance, a Legal invoice document containing a QR code has mandatory information specified by the government.

This article will explain how you can create QR codes in DP class and populate the same in the design part of the SSRS report.

Time needed: 30 minutes.

Create QR code

  1. 1. Create a new field in tmp table of the SSRS report

    Field type: Extends
    Extends: Bitmap
    TmpTableQRCodeBitmap


  2. 2. Create the below static function in the new QRHelper class

    public static container QRCode(Str _QRContents)
    {
    // QRContents is a formatted string provided as input to this function.
    // For example _QRContents= ?name='Customer name'&rr='RFCno'&tt='totalInvoiceAmount';
    System.Drawing.Bitmap bm = null;
    try
    {
    var qrCodeEncoder = new Encoder();
    bm = qrCodeEncoder.Encode(_QRContents);
    }
    catch (Exception::CLRError)
    {
    error(CLRInterop::getLastException().ToString());
    }
    using (var stream = new System.IO.MemoryStream())
    {
    bm.Save(stream, System.Drawing.Imaging.ImageFormat::Bmp);
    bm.Dispose();
    return Binary::constructFromMemoryStream(stream).getContainer();
    }
    }
    view rawQRHelper.cs hosted with ❤ by GitHub

  3. 3. Call above created function in DP class

    Provide formatted string for which QR code needs to be created and
    populate the tmp.QRCode =QRHelper::QRCode(_FormattedString)


  4. 4. Insert Image in RDLC design part of SSRS

    QRCodeImageRDLC


  5. 5. Build the project and deploy the report

    The report is now generated with a QR code.
    QRCodeSSRS

Ref :- https://axparadise.com/how-to-create-qr-code-in-ssrs-report-in-d365fo/

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