web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance forum / Extension of SSRS report
Finance forum

Extension of SSRS report

(0) ShareShare
ReportReport
Posted on by 6,494

Hello,

I want to add new design in SalesInvoice report. I have reference to "ApplicationSuite" model, but when I right click it in AOT "create extension" is grayed out.

Isn't it possible to extend standard ssrs reports? 

0640.salesinvoice.png

I have the same question (0)
  • Verified answer
    Martin Dráb Profile Picture
    239,996 Most Valuable Professional on at

    It's not how it works; you can't create report extensions by your steps. In fact, report designs can't be meaninfully extended, you must create a new report.

    Please look into documentation at Customize with extensions and overlayering > Report extensions and links going from there, especially Custom designs for business documents.

  • Johnny Profile Picture
    6,494 on at

    Hi Martin,

    thanks for docs.

    however I have 1 issue with country specific codes.

    I created a class and method below and added if statement with SysCountryRegionCode. I have also added 'PL' to the salesinvoice output menu item (extension). Still in print management setup the report name is visible in USMF entity too which is US.

    [SubscribesTo(classStr(PrintMgmtDocType), delegateStr(PrintMgmtDocType, getDefaultReportFormatDelegate))]
        public static void PrintMgmtDocType_getDefaultReportFormatDelegate(PrintMgmtDocumentType _docType, EventHandlerResult _result)
        {
            #ISOCountryRegionCodes
            switch (_docType)
            {
                case PrintMgmtDocumentType::SalesOrderInvoice:
                    if (SysCountryRegionCode::isLegalEntityInCountryRegion([#isoPL]))
                    {
                        _result.result(ssrsReportStr(SalesInvoiceXXX, ReportXXX));
                        break;
                    }
            }
        }


    Where else should I filter it the report name to be available only for 'PL' entities?

  • Sukrut Parab Profile Picture
    71,741 Moderator on at

    Make sure you have address set up correctly on legal entity with correct ISO code for the address

  • NoobDaxCoder Profile Picture
    6 on at

    Hi Martin,

    I have checked your links. Currently working on VendInvoice report extension.I am stuck at this enum PrintMgmtDocumentType. Not sure what is the relavant enum value for that one..

    Please advise.

  • Martin Dráb Profile Picture
    239,996 Most Valuable Professional on at

    That's PurchaseOrderInvoice.

    If you don't know, you can also look at what's returned from PurchFormLetter_Invoice.printMgmtDocumentType().

  • NoobDaxCoder Profile Picture
    6 on at

    Hi,

    This is the return.  

    protected PrintMgmtDocumentType printMgmtDocumentType()

       {

           return PrintMgmtDocumentType::PurchaseOrderInvoice;

       }

    I am working on VendorInvoice Report. PrintMgmtDocumentType::PurchaseOrderInvoice; <=  this will call Vendor invoice?

    //start example

    case PrintMgmtDocumentType::PurchaseOrderInvoice:

                    _result.result(ssrsReportStr(MyReport, mydesign));

                    break;

    //end

  • Martin Dráb Profile Picture
    239,996 Most Valuable Professional on at

    Yes, I know what it returns; I already told you that in my previous reply. Then I explain to you how you can find the answer by yourself next time.

    The enum value won't call anything, but it will be used to get the right design from print management.

  • NoobDaxCoder Profile Picture
    6 on at

    Ah.

    Right design as in the report design or am i missing something. Please do explain.

  • NoobDaxCoder Profile Picture
    6 on at

    Oh i understood. So enum will set the report up in the print management. All i have to do is, set appropriate report.

  • NoobDaxCoder Profile Picture
    6 on at

    How to choose appropriate enums however. there are very limited number of enums available. Im working on serveral reports to be moved to extensions. CustAgeingreport. I assume, since it is associated with sales i will choose salesorderinvoice?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Finance

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans