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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Extend Report InventValueReport

(0) ShareShare
ReportReport
Posted on by 618

Hi,


I like to extend the standard report InventValueReport with the item name. So I create a new report MyInventValueReport, copied from the standard one. To use this new report I extend the InventValueReportController class method reportName() to return the new report name. 

I also extend the table InventValueReportTmpLine.MyExtension with the field MyItemName and the related query InventValueReportTmpLine.MyExtension as well.
To fill the new field, I extend the class method InventValueReportPopulateItem.findReportLine(). In SQL-Manager I can see the field will be filled.

I also create a new class called MyInventValueReportDP. That's because the methode processInventValueReportTmpLine() to fill the temporary table InventValueReportTmpLine where I stored the item name is private and not extensible (F***! why is this methode a private one???). Here I extend the field MyItemName to local macro GroupByFields.

In MyInventValueReport I change the dataset properties to MyInventValueReportDP and placed the MyItemName in both designs.

Now I get two things: first the query to filter records in the dialog is not available anymore and I got this error: Unable to add the table field 'MyItemNameDisplay' to the query source 'InventValueReportTmpLine'. Table field 'MyItemNameDisplay' does not exist on table 'InventValueReportTmpLine'.

So... where is/are the fail(s)?

Regards

Christian

I have the same question (0)
  • GirishS Profile Picture
    27,843 Moderator on at

    Hi Christian Busche ,

    Instead of creating new DP class you can create postEventHandler for ProcessReport method and assign the values to your custom field.

    Please go through the below URL.

    https://kishoredynamics11.blogspot.com/2021/07/add-new-field-in-standard-report-in.html

    Thanks,

    Girish S.

  • Christian Busche Profile Picture
    618 on at

    Hi,

    I think the postEventHandler didn't do anything else than the CoC method processReport()? Because I try to use this solution... But I think also that the logic in InventValueReport is different to the logic of the journal reports.. The new field MyItemName will be shown in the extended standard report, but it is emtpy although it is filled in CoC method... So I try to take the way described above...

  • GirishS Profile Picture
    27,843 Moderator on at

    So you have written COC for processReport method from "InventValueReportDP" class to populate "MyItemName" field value.

    is that working?

    If not you can write event handler for report temp table "OnInserting" method.

    Thanks,

    Girish S.

  • Christian Busche Profile Picture
    618 on at

    that is working... the values are also stored in database...

    pastedimage1663859249575v1.png

    But the report does not support the values...

    pastedimage1663857611175v2.png

    BTW...

    the reords are inserted in the table with insert_recordset in DP-class... So I think there is no chance to modify them anyway... As the new field is missing in the insert_recordList, I thought I have to copy the DP-class in a new DP-class, because the insert_recordList-method is private!

    I try to extend the getInventValueReportTmpLine() in DP class and told you the result...

  • GirishS Profile Picture
    27,843 Moderator on at

    Hi Christian Busche,

    Have you restarted the SSRS Reporting service. Records get inserted in the table for your custom field so I think there is no problem in the code.

    Restart the service and try running the report.

    Thanks,

    Girish S.

  • Suggested answer
    Christian Busche Profile Picture
    618 on at

    After several changings in source code, several builds, several restart of application and report server suddenly it works... but I don't know why...

  • GirishS Profile Picture
    27,843 Moderator on at

    Hi Christian Busche,

    Normally when you add a new field to the custom or standard report you need to restart the report server. After restarting it will definitely work.

    Thanks,

    Girish S.

  • Christian Busche Profile Picture
    618 on at

    hope you're right... ;-)

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 617

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 461 Super User 2026 Season 1

#3
Syed Haris Shah Profile Picture

Syed Haris Shah 298 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans