Override a DP class for customize an SSRS report

(1) Share

Report

Posted on by CU09091357-0

501

I want to print the LedgerTransPerJournal report in d365fo. There's already a built in LedgerTransPerJournalDP class for it. But it print the posted ones.

What I want is to create a new button (already did), and print but unposted ones, how?

Means how can I change the DP condition or query in a way that prints the unposted ones.

I already created a code extension but I don't what are the next steps to proceed with.

I have the same question (0)

All responses (8)

Answers (1)

Martin Dráb 237,987 Most Valuable Professional on at

Like (1)

Report

I'm assuming your can manipulate the query in an CoC extension of buildQueryToProcessReport() method.

Was this reply helpful? Yes No
CU09091357-0 501 on at

Like (0)

Report

Martin Dráb thank you for your response, can you please give me an example how? Because I didn't find the buildQueryToProcessReport() method in AOT.

Was this reply helpful? Yes No
Martin Dráb 237,987 Most Valuable Professional on at

Like (1)

Report

If you don't have it in your application, writing an example of how to extend it would be a waste of time, because you couldn't use it.

I'm looking into 10.0.41; what is your version? Mybe you've just made a mistake when looking for the method.

Anyway, you can simply look into LedgerTransPerJournalDP.processReport() to see how the query is obtained in your application.

Was this reply helpful? Yes No
CU09091357-0 501 on at

Like (0)

Report
Martin Dráb yes I have it, but I didn't find anything related to the posted or not posted

protected final Query buildQueryToProcessReport() { Query query = this.parmQuery(); QueryBuildDataSource ds = query.dataSourceTable(tableNum(GeneralJournalEntry)); QueryBuildRange range = SysQuery::findOrCreateRange(ds, fieldNum(GeneralJournalEntry, Ledger)); range.value(SysQuery::value(Ledger::current())); if (this.parmDataContract().parmFromDate() != dateNull() && this.parmDataContract().parmToDate() != dateNull()) { QueryBuildRange dateRange = SysQuery::findOrCreateRange(ds, fieldnum(GeneralJournalEntry, AccountingDate)); dateRange.value(SysQuery::range(this.parmDataContract().parmFromDate(), this.parmDataContract().parmToDate())); } return query; }

Was this reply helpful? Yes No
Martin Dráb 237,987 Most Valuable Professional on at

Like (1)

Report

That's true, but it's not related to the problem. Still, this the the method that you can extend and where you can change the filter value. That the range was added somewhere else doesn't change anything.

Was this reply helpful? Yes No
Suggested answer

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

Like (1)

Report

The DP class is using "LedgerTransPerJournal" query. In the query, they are specifically joining LedgerJournalEntry with LedgerJournalTable. And from this LedgerJournalTable, they are specifically using PostedDateTime. I think, only after posting only we can make the above join since there is no other place where there is a range on Posted. So please check these joins so that you can understand if you need to recreate the report from scratch.

Was this reply helpful? Yes No
Suggested answer

Sankar Ramalingam 262 on at

Like (1)

Report

You can't do it with LedgerTransPerJournalDP because query "LedgerTransPerJournal" used has GeneralJournalEntry data source which will have only Posted transactions.

I would recommend to duplicate LedgerTransPerJournalDP class with new query with LedgerJournalTable and LedgerJournalTrans. By doing this, you may need to duplicate the SSRS report as well to change the data source as well. I think this is the way you can proceed.

Was this reply helpful? Yes No
Verified answer

Martin Dráb 237,987 Most Valuable Professional on at

Like (2)

Report

You could disable the data source in the query, so that's not a problem as such, but the code of LedgerTransPerJournalDP depends on it, therefore it would fail there. It seems that the overall idea of reusing this report is wrong indeed.

Was this reply helpful? Yes No