custamization in standard SSRS report

(0) Share

Report

Posted on by @rp@n

Hi team,

I look for custamization in standard SSRS report in D365O. Like changes in contarct, controller, DP and in report design

So, that I can get idea on how will custamize the stnd. report.

I google it but not get proper link which I am looking for

If anyone has done , Kindly share with me.

pls give me more shed on this.

thanks!

I have the same question (0)

All responses (26)

Answers (8)

Verified answer

GirishS 27,825 Moderator on at

Like (0)

Report

RE: custamization in standard SSRS report

Hi,

Below are the links for customizing standard SSRS report.

https://nuxulu.com/2019-10-10-extend-the-standard-reports-in-dynamics-365-finance-and-operations/

http://msdynamics.nevoitech.com/microsoft/customize-ssrs-report-using-extension-in-d365fo/

http://axraja.blogspot.com/2019/12/bulk-operations.html

https://d365byjp.blogspot.com/2021/02/customizing-standard-report-in-dynamics.html

Thanks,

Girish S.

Was this reply helpful? Yes No
@rp@n 30 on at

Like (0)

Report

RE: custamization in standard SSRS report

Hi all, I go through the links you provided.

Sales Confirm report -

I like to add field on Table - SalesConfirmDetailsTmp and like to add business logic in SalesConfirmDP - ProcessReport method.

For the table, I can create an extension and added the field over there . Let me know how we can add business logic in processReport method ?

Pls give me more shed on this.

thanks!

Was this reply helpful? Yes No
Verified answer

GirishS 27,825 Moderator on at

Like (0)

Report
RE: custamization in standard SSRS report

If you want to add a new field, to make it simple you can populate the newly added field via onInserting event handler of the temp table.

[DataEventHandler(tableStr(TempTableName), DataEventType::Inserting)] public static void TempTableName_onInserting(Common sender, DataEventArgs e) { TempTableName tempTable = sender as TempTableName; //you can get the current value using tempTable and add logic based on that. tempTable.NewFieldName = "SomeValue"; }

Thanks,

Girish S.

Was this reply helpful? Yes No
@rp@n 30 on at

Like (0)

Report

RE: custamization in standard SSRS report

thanks Girish, and If i wants to do the same in processReport method than how will achieve this?

just for my knowledge to know

Was this reply helpful? Yes No
Verified answer

Bharani Preetham Pe... 3,634 Moderator on at

Like (0)

Report

RE: custamization in standard SSRS report

Just check feasibility of adding the field in which temp table so that you should have correct table buffer so that you can use that buffer for getting data. And writing code is same way how you will extend a method using COC and write the code.

Was this reply helpful? Yes No
GirishS 27,825 Moderator on at

Like (0)

Report

RE: custamization in standard SSRS report

You need to write post handler for process report method and update the newly added field values.

Thanks,

Girish S.

Was this reply helpful? Yes No
@rp@n 30 on at

Like (0)

Report

RE: custamization in standard SSRS report

thanks Girish and Bharani,

Let me check & post you the code for the processReport method.

just for my knowledge if like to modify SalesConfirmController and SalesConformContract class then how will achieve this?

Was this reply helpful? Yes No
Verified answer

GirishS 27,825 Moderator on at

Like (0)

Report

RE: custamization in standard SSRS report

Modification of controller class and contract class depends on the scenario.

For example you are creating new design for the standard report, in that case you can duplicate the standard controller class and point to the custom design you created and map that controller class by extending output menu item.

For contract class suppose you need to add new parameter to the existing report you can create extension of contract class and add the new parm method for report parameter.

This is available in the blog I send you can check that.

Thanks,

Girish S.

Was this reply helpful? Yes No
@rp@n 30 on at

Like (0)

Report
RE: custamization in standard SSRS report

For the modification in ProcessReport method

As you mentioned

Bharani Preetham Peraka - Just check feasibility of adding the field in which temp table so that you should have correct table buffer so that you can use that buffer for getting data. And writing code is same way how you will extend a method using COC and write the code.

@ Girish - You need to write post handler for process report method and update the newly added field values.

So, I wrote the code for processReport method for SalesConfirmDP class

[ExtensionOf(classStr(SalesConfirmDP))] final class ARP_SalesConfirmDP_Extension { SalesConfirmDetailsTmp confirmDetailsTmp; public void processReport() { next processReport(); // custom code } }

Kindly verify is it correct ?

Pls give me more shed on this.

thanks!

Was this reply helpful? Yes No
Verified answer

Andrew Xu 3,877 on at

Like (0)

Report

RE: custamization in standard SSRS report

that's right, you'll use the chain-of-command mechanism to extend the existing class.

Was this reply helpful? Yes No