{"id":130,"date":"2023-11-09T16:45:45","date_gmt":"2023-11-09T08:45:45","guid":{"rendered":"https:\/\/live-d365fo.pantheonsite.io\/?p=130"},"modified":"2024-07-19T17:47:13","modified_gmt":"2024-07-19T09:47:13","slug":"how-to-extend-standard-ssrs-report","status":"publish","type":"post","link":"https:\/\/dev-d365fo.pantheonsite.io\/how-to-extend-standard-ssrs-report\/","title":{"rendered":"\u5982\u4f55\u4fee\u6539\u7cfb\u7edf\u6807\u51c6\u7684SSRS\u62a5\u8868\uff08how-to-extend-standard-ssrs-report\uff09"},"content":{"rendered":"\n<h1 class=\"wp-block-heading\">CustAccountStatementExt<\/h1>\n\n\n\n<p>\u6f14\u793a\u5982\u4f55\u5411&nbsp;Customer account statement&nbsp;report \u6dfb\u52a0\u65b0\u5b57\u6bb5<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">1.\u6dfb\u52a0\u65b0\u5b57\u6bb5<\/h2>\n\n\n\n<p class=\"add-remove-bottom-space\">\u4e3b\u4e34\u65f6\u8868\u662f CustAccountStatementExtTmp\uff0c\u53f3\u952e\u5355\u51fb\u5e76\u521b\u5efa\u6269\u5c55\uff1b\u6211\u5c06\u6dfb\u52a0\u4e00\u4e2a\u65b0\u7684\u5b57\u7b26\u4e32\u5b57\u6bb5 MaxTxT\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/nashome-image-bucket.oss-cn-shanghai.aliyuncs.com\/PicGo\/202311161507654.png\" alt=\"\"\/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">2. \u590d\u5236\u8fd9\u4e2a\u62a5\u8868<\/h2>\n\n\n\n<p class=\"add-remove-bottom-space\">\u91cd\u547d\u540d\u4e3a\uff1aCustAccountStatementExt<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/nashome-image-bucket.oss-cn-shanghai.aliyuncs.com\/PicGo\/202311161510303.png\" alt=\"\"\/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">3.\u4fee\u6539\u62a5\u544a\u8bbe\u8ba1<\/h2>\n\n\n\n<p>\u53f3\u952e\u5355\u51fb\u62a5\u8868\u6570\u636e\u96c6\u5e76\u9009\u62e9\u6062\u590d\u4ee5\u5237\u65b0\u65b0\u5b57\u6bb5\uff0c\u6253\u5f00\u62a5\u8868\u8bbe\u8ba1\u5668\u5e76\u5c06\u8be5\u5b57\u6bb5\u6dfb\u52a0\u5230\u8868\u4e2d<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/nashome-image-bucket.oss-cn-shanghai.aliyuncs.com\/PicGo\/202311161514341.png\" alt=\"\"\/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">4. \u521b\u5efa\u4e00\u4e2a\u65b0\u7684\u6269\u5c55\u7c7b\u6765\u6269\u5c55\u6807\u51c6\u62a5\u8868Controller class<\/h2>\n\n\n\n<pre lang=\"python\">\nclass CustAccountStatementExtControllerExtextends CustAccountStatementExtController\n{\n    \/\/Add construct\n    public static CustAccountStatementExtControllerExtconstruct()\n    {\n        return new CustAccountStatementExtControllerExt();\n    }\n\n    public static void main(Args _args)\n    {\n        SrsPrintMgmtFormLetterController controller = new CustAccountStatementExtControllerExt();\n        controller.parmReportName(PrintMgmtDocType::construct(PrintMgmtDocumentType::CustAccountStatement).getDefaultReportFormat());\n        controller.parmArgs(_args);\n        CustAccountStatementExtControllerExt::startControllerOperation(controller, _args);\n    }\n    \u00a0\n    protected static void startControllerOperation(SrsPrintMgmtFormLetterController _controller, Args _args)\n    {\n        _controller.startOperation();\n    }\n}\n<\/pre>\n\n\n\n<p class=\"add-remove-bottom-space\">\u53ef\u9009\u65b9\u6cd5\uff0c\u786e\u5b9a\u62a5\u8868\u7684\u9ed8\u8ba4\u8bbe\u8ba1\uff0c\u6709\u4e9b\u62a5\u8868\u4e0d\u4f7f\u7528<\/p>\n\n\n\n<pre lang=\"python\">\nprotected void outputReport()\n{\n    SRSCatalogItemName  reportDesign;\n    reportDesign = ssrsReportStr(CustAccountStatementExt,Report);\n    this.parmReportName(reportDesign);\n    this.parmReportContract().parmReportName(reportDesign);\n    formletterReport.parmReportRun().settingDetail().parmReportFormatName(reportDesign);\n    super();\n}\n\n<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">5. \u521b\u5efa\u65b0\u7684report handler class<\/h2>\n\n\n\n<p>\u6211\u4eec\u6709\u4e24\u79cd\u4e0d\u540c\u7684\u65b9\u6cd5\u6765\u586b\u5145\u62a5\u8868\u5904\u7406\u7a0b\u5e8f\u7c7b\u4e2d\u7684\u6570\u636e\uff1a<\/p>\n\n\n\n<ul>\n<li>\u6dfb\u52a0\u4e34\u65f6\u8868\u63d2\u5165\u4e8b\u4ef6\uff0c\u9010\u884c\u8ba1\u7b97\u3002\u8f6c\u5230 AOT \u4e2d\u7684 CustAccountStatementExtTmp\uff0c\u5c55\u5f00\u4e8b\u4ef6\u8282\u70b9\uff0c\u7136\u540e\u590d\u5236\u4e8b\u4ef6\u5904\u7406\u7a0b\u5e8f\u65b9\u6cd5\u3002<\/li>\n\n\n\n<li><span style=\"color: rgb(37, 37, 37); font-family: Roboto, arial, sans-serif; white-space-collapse: collapse;\">\u6dfb\u52a0\u6570\u636e\u5904\u7406post-handler\uff0c\u63d2\u5165\u5bf9\u6807\u51c6\u89e3\u51b3\u65b9\u6848\u7684\u7ed3\u679c\u96c6\u4f7f\u7528\u5355\u6b21\u4f20\u9012\u7684\u64cd\u4f5c\u3002<\/span><\/li>\n<\/ul>\n\n\n\n\u6dfb\u52a0\u4e34\u65f6\u8868\u63d2\u5165\u4e8b\u4ef6\n<pre lang=\"python\">\nclass MaxCustAccountStatementExtHandler\n{\n    [DataEventHandlerAttribute(tableStr(CustAccountStatementExtTmp), DataEventType::Inserting)]\n    public static void CustAccountStatementExtTmpInsertEvent(Common c, DataEventArgs e)\n    {\n        CustAccountStatementExtTmp  tempTable = c;\n        CustGroup custGroup;\n        select * from tempTable\n            where tempTable.CustGroup == custGroup.CustGroup;\n\n        tempTable.MaxTxT = custGroup.Description;\n    }\n}\n<\/pre>\n\n\n\n\u6dfb\u52a0\u6570\u636e\u5904\u7406post-handler\n<pre lang=\"python\">\nclass MaxCustAccountStatementExtHandler\n{\n    [PostHandlerFor(classStr(CustAccountStatementExtDP), methodstr(CustAccountStatementExtDP, processReport))]\n    public static void TmpTablePostHandler(XppPrePostArgs arguments)\n    {\n        CustAccountStatementExtDP dpInstance = arguments.getThis() as CustAccountStatementExtDP;\n        CustAccountStatementExtTmp tmpTable = dpInstance.getCustAccountStatementExtTmp();\n        CustGroup custGroup;\n        ttsbegin;\n        while select forUpdate tmpTable\n        {\n            select * from tempTable\n                where tempTable.CustGroup == custGroup.CustGroup;\n            tempTable.MaxTxT = custGroup.Description;\n            tmpTable.update();\n        }\n        ttscommit;\n    }\n}\n<\/pre>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">6. \u6dfb\u52a0delegate handler <\/h2>\n\n\n\n<p class=\"add-remove-bottom-space\">\u5728\u6b64\u793a\u4f8b\u4e2d\uff0c\u4f7f\u7528\u4ee5\u4e0b\u4ee3\u7801\u6269\u5c55 PrintMgtDocTypeHandlerExt \u7c7b\u4e2d\u7684 getDefaultReportFormatDelegate \u65b9\u6cd5\u3002<\/p>\n\n\n\n<pre lang=\"python\">\nclass PrintMgtDocTypeHandlersExt\n{\n    [SubscribesTo(classstr(PrintMgmtDocType), delegatestr(PrintMgmtDocType, getDefaultReportFormatDelegate))]\n    public static void getDefaultReportFormatDelegate(PrintMgmtDocumentType _docType, EventHandlerResult _result)\n    {\n        switch (_docType)\n        {\n            case PrintMgmtDocumentType::CustAccountStatement:\n                _result.result(ssrsReportStr(CustAccountStatementExt, Report));\n                break;\n        }\n    }\n}\n<\/pre>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">7. \u4e3a\u73b0\u6709\u83dc\u5355\u9879\u521b\u5efa\u6269\u5c55<\/h2>\n\n\n\n<p>\u5bfc\u822a\u5230 CustAccountStatementExt \u8f93\u51fa\u83dc\u5355\u9879\u5e76\u521b\u5efa\u6269\u5c55\u3002\u53e6\u8bf7\u786e\u4fdd\u5c06 Object \u5c5e\u6027\u7684\u503c\u8bbe\u7f6e\u4e3a CustAccountStatementExtControllerExt\uff0c\u4ee5\u5c06\u7528\u6237\u5bfc\u822a\u91cd\u5b9a\u5411\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/nashome-image-bucket.oss-cn-shanghai.aliyuncs.com\/PicGo\/202311161526774.png\" alt=\"\"\/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">8. \u66f4\u65b0Print management settings<\/h2>\n\n\n\n<p>\u8f6c\u81f3\u5e94\u4ed8\u8d26\u6b3e &gt; \u67e5\u8be2\u548c\u62a5\u544a &gt; \u8bbe\u7f6e &gt; \u8868\u5355 &gt; \u8868\u5355\u8bbe\u7f6e \u5355\u51fb\u6253\u5370\u7ba1\u7406\uff0c\u627e\u5230\u6587\u6863\u914d\u7f6e\u8bbe\u7f6e\uff0c\u7136\u540e\u9009\u62e9\u81ea\u5b9a\u4e49\u8bbe\u8ba1<\/p>\n\n\n\n<p>\u5173\u4e8e\u5982\u4f55\u6839\u636e\u4e0d\u540c\u7684\u516c\u53f8\u6253\u5370\u4e0d\u540c\u7684\u62a5\u8868Design,\u8bf7\u53c2\u8003:<\/p>\n\n\n<div class=\"vlp-link-container vlp-layout-compact-copy wp-block-visual-link-preview-link\"><a href=\"https:\/\/dev-d365fo.pantheonsite.io\/how-to-print-ssrs-report-by-print-management\/\" class=\"vlp-link\" title=\"\u5982\u4f55\u901a\u8fc7Print management \u6253\u5370SSRS\u62a5\u8868\uff08how-to-print-ssrs-report-using-print-management\uff09 \u00bb Microsoft Dynamics AX\/365 FO Developer`s Blog\" rel=\"nofollow\" target=\"_blank\"><\/a><div class=\"vlp-layout-zone-main\"><div class=\"vlp-block-0 vlp-link-title\">\u5982\u4f55\u901a\u8fc7Print management \u6253\u5370SSRS\u62a5\u8868\uff08how-to-print-ssrs-report-using-print-management\uff09 \u00bb Microsoft Dynamics AX\/365 FO Developer`s Blog<\/div><\/div><\/div>\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">9. \u8fd0\u884c\u62a5\u544a\u5e76\u6d4b\u8bd5\u7ed3\u679c<\/h2>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/nashome-image-bucket.oss-cn-shanghai.aliyuncs.com\/PicGo\/202311161531321.png\" alt=\"\"\/><\/figure>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>CustAccountStatementExt \u6f14\u793a\u5982\u4f55\u5411&nbsp;Customer account statement&nbsp;report \u6dfb\u52a0\u65b0\u5b57\u6bb5 1.\u6dfb\u52a0\u65b0\u5b57\u6bb5 \u4e3b\u4e34\u65f6\u8868\u662f CustAccountStatementExtTmp\uff0c\u53f3\u952e\u5355\u51fb\u5e76\u521b\u5efa\u6269\u5c55\uff1b\u6211\u5c06\u6dfb\u52a0\u4e00\u4e2a\u65b0\u7684\u5b57\u7b26\u4e32\u5b57\u6bb5 MaxTxT\u3002 2. \u590d\u5236\u8fd9\u4e2a\u62a5\u8868 \u91cd\u547d\u540d\u4e3a\uff1aCustAccountStatementExt 3.\u4fee\u6539\u62a5\u544a\u8bbe\u8ba1 \u53f3\u952e\u5355\u51fb\u62a5\u8868\u6570\u636e\u96c6\u5e76\u9009\u62e9\u6062\u590d\u4ee5\u5237\u65b0\u65b0\u5b57\u6bb5\uff0c\u6253\u5f00\u62a5\u8868\u8bbe\u8ba1\u5668\u5e76\u5c06\u8be5\u5b57\u6bb5\u6dfb\u52a0\u5230\u8868\u4e2d 4. \u521b\u5efa\u4e00\u4e2a\u65b0\u7684\u6269\u5c55\u7c7b\u6765\u6269\u5c55\u6807\u51c6\u62a5\u8868Controller class class CustAccountStatementExtControllerExtextends CustAccountStatementExtController { \/\/Add construct public static CustAccountStatementExtControllerExtconstruct() { return new CustAccountStatementExtControllerExt(); } public static void main(Args _args) { SrsPrintMgmtFormLetterController controller = new CustAccountStatementExtControllerExt(); controller.parmReportName(PrintMgmtDocType::construct(PrintMgmtDocumentType::CustAccountStatement).getDefaultReportFormat()); controller.parmArgs(_args); CustAccountStatementExtControllerExt::startControllerOperation(controller, _args); } \u00a0 protected static void startControllerOperation(SrsPrintMgmtFormLetterController _controller, Args _args) &#8230;<\/p>\n<p><a href=\"https:\/\/dev-d365fo.pantheonsite.io\/how-to-extend-standard-ssrs-report\/\" class=\"more-link\">Continue reading &lsquo;\u5982\u4f55\u4fee\u6539\u7cfb\u7edf\u6807\u51c6\u7684SSRS\u62a5\u8868\uff08how-to-extend-standard-ssrs-report\uff09&rsquo; &raquo;<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[3,10],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/dev-d365fo.pantheonsite.io\/wp-json\/wp\/v2\/posts\/130"}],"collection":[{"href":"https:\/\/dev-d365fo.pantheonsite.io\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dev-d365fo.pantheonsite.io\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dev-d365fo.pantheonsite.io\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/dev-d365fo.pantheonsite.io\/wp-json\/wp\/v2\/comments?post=130"}],"version-history":[{"count":109,"href":"https:\/\/dev-d365fo.pantheonsite.io\/wp-json\/wp\/v2\/posts\/130\/revisions"}],"predecessor-version":[{"id":793,"href":"https:\/\/dev-d365fo.pantheonsite.io\/wp-json\/wp\/v2\/posts\/130\/revisions\/793"}],"wp:attachment":[{"href":"https:\/\/dev-d365fo.pantheonsite.io\/wp-json\/wp\/v2\/media?parent=130"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dev-d365fo.pantheonsite.io\/wp-json\/wp\/v2\/categories?post=130"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dev-d365fo.pantheonsite.io\/wp-json\/wp\/v2\/tags?post=130"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}