Finance | Project Operations, Human Resources, ...

Extend Base SSRS Report

(0) Share

Report

Posted on by Antony

I try to extend the base print management report(PurchPurchaseOrder) But I got this error, I did three things

1.Created extension for Tmp Table (PurchPurchaseOrder), and Duplicated the report (PurchPurchaseOrder)

2.Added the field(AntDlvMode) That I wanted, restored the data set in the report and edited the report

3.atlast wrote coding for COC Class and print management

Anybody help me out

Thanks

COC Class

[ExtensionOf(classStr(PurchPurchaseOrderDP))]
public final class Purch_Extension
{
protected PurchPurchaseOrderTmp initializeOrderLine(
PurchPurchaseOrderHeader _purchaseOrderHeader,
boolean _highlightUpdated,
PurchPurchaseOrderDPOrderLineQuerySelection _orderLineSelection)
{
PurchPurchaseOrderTmp purchPurchaseOrderTmp = next initializeOrderLine(_purchaseOrderHeader, _highlightUpdated, _orderLineSelection);
PurchTable purchTable;
select purchPurchaseOrderTmp;
purchPurchaseOrderTmp.AntDlvMode = purchTable.DlvMode;
purchPurchaseOrderTmp.insert();
return purchPurchaseOrderTmp;
}
}

Print management class Code

class MaxPrintMgtDocTypeHandlersExt{    [SubscribesTo(classstr(PrintMgmtDocType), delegatestr(PrintMgmtDocType, getDefaultReportFormatDelegate))]    public static void getDefaultReportFormatDelegate(PrintMgmtDocumentType _docType, EventHandlerResult _result)    {        switch (_docType)        {            case PrintMgmtDocumentType::CustAccountStatement:                _result.result(ssrsReportStr(MaxCustAccountStatementExt, Report));                break;        }    }}

Here some example images

Extende objects

All responses (6)

Answers (0)

Antony 23 on at

Like (0)

Report

Extend Base SSRS Report

Sorry Martin, Yeah I can deploy other reports and also There is a values in DlvMode
Suggested answer

Bharani Preetham Pe... 3,613 Super User 2024 Season 1 on at

Like (0)

Report

Extend Base SSRS Report

It seems the parameters in report got changed. Or this type of error comes when you have added new field in design which says cells are not matching like some sort of error.

The work around here is to open the XML file of ssrs report and you need to edit the cells shown.

https://daxonline.org/1708-the-number-of-defined-parameters-is-not-equal-to-the-number-of-cell-definitions-in-the-parameter-panel.html

Check the 2nd resolution in the link provided.
Martin Dráb 230,445 Most Valuable Professional on at

Like (0)

Report

Extend Base SSRS Report

I thought you want to discuss the problem with deployment, but you didn't answer my question and you aren't talking about it anymore. Does it mean that it's all right now?

Regarding the code, I recommend you do what I suggested in my first reply. Please try it and if you run into a problem, please describe it here.
Antony 23 on at

Like (0)

Report

Extend Base SSRS Report
Antony 23 on at

Like (0)

Report

Extend Base SSRS Report

Thank you martin, Can you give me the code
Martin Dráb 230,445 Most Valuable Professional on at

Like (0)

Report

Extend Base SSRS Report

Moved from Dynamics AX forum.

The error suggests that you have a problem with SSRS in general. Are you sure that you can deploy other records?

By the way, you have a bug in Purch_Extension class. The field purchTable.DlvMode will always be empty, because you forgot to assign a value purchTable variable. Because you take a values from the order header, the field belongs to PurchPurchaseOrderHeader table, not PurchPurchaseOrderTmp, and the right method to initialize it is PurchPurchaseOrderHeader.initFromPurchTableAllVersions().