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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / No data displays when ...
Microsoft Dynamics AX (Archived)

No data displays when adding new table in "SalesInvoice" SSRS report

(0) ShareShare
ReportReport
Posted on by Sathish Sivakumar 3,732

Hi,

I'm working on the sales invoice report customization. I have added a couple of new tables in the sales invoice report. But after adding it to the table dataset in the report, the data is not populating in the report. This happens only for the newly added table data, rest of the standard table data are populating.

Note: I have created a new design in SalesInvoice report.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Vilmos Kintera Profile Picture
    Vilmos Kintera 46,149 on at

    Data is coming from the Data provider classes. Have you altered SalesInvoiceDP / SalesInvoiceController correctly? Please familiarize yourself with SSRS DP from the documentation, also you could find a lot of blogs about this:

    https://technet.microsoft.com/en-us/library/hh456296.aspx

    Also did you add your new design in the Report configurations list in the System administrator module, and have you set the new design in the Sales parameters for the Print management settings on the customer invoices original/copy entry?

  • Sathish Sivakumar Profile Picture
    Sathish Sivakumar 3,732 on at

    Hi Vilmos,

    Yes I have did the coding in the DP class and that data is also inserting into the table which I have newly created. But my issue is the data which are coming from the newly created table means, the data is not showing up in the report.

  • Suggested answer
    Vilmos Kintera Profile Picture
    Vilmos Kintera 46,149 on at

    I am sorry but it is a bit hazy what you have explained, that the data inserting but it it not showing. Are you saying you have debugged the data provider class explained in the link I have posted, and the data is being populated in your regular AX table (because SalesInvoice is a pre-processed SSRS report) with the createdtransactionid (preprocessid) and everything fine, but it is just not being rendered on the report? Are you sure the correct design that has your datasources are being rendered? Check the settings I have explained above to be sure.

    Also on SQL Server where your ReportServer database is sitting, check the ExecutionLog3 SQL View. It will tell you exactly what design is being called.

  • Sathish Sivakumar Profile Picture
    Sathish Sivakumar 3,732 on at

    Hi Crispin,

    There is no relation between the new and existing table.

    Yes some fields from new table are displaying in the exisiting table tablix.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans