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 :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / No report data table w...
Microsoft Dynamics AX (Archived)

No report data table with name SalesInvoiceTmp exists in report schema for data provider SalesInvoiceDP.

(0) ShareShare
ReportReport
Posted on by Community Member

When I run the SalesInvoice Report in AX, I get the error 'No report data table with name SalesInvoiceTmp exists in report schema for data provider SalesInvoiceDP.' Checked the report and it has only one dataset and the Tmp table exists. How can this error be resolved?

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    Since it complains on the schema I think it is good to open the visual studio project for this report, rebuild and deploy it. If that doesn't help see if you have made any changes to the methods that return the temptable, specially the decorators. Recompile the DP and the contract, delete any report data from Usage data and try again.

  • Community Member Profile Picture
    Community Member on at

    Hello Kamal,

    I tried all the steps that you mentioned. But still i facing the same error? Also trying to regenerate XppIL, restarted AOS & SSRS, deployed BI service group. But still same issue. Has anyone found any resolution?

    I started facing this in production environment after migrating model store(CU5 , FP) from test environment.

    Thanks.

  • Community Member Profile Picture
    Community Member on at

    I see its not being answered for long time. This should be due to the data source in Query (Visual Studio) .

    Select the datasource in visual studio - select query again.

    Build and deploy.

  • AxaptaAmarSingh Profile Picture
    AxaptaAmarSingh 40 on at

    Thanks Bro, your solution helped me after 5 years :)

  • Muhammad Saleh Profile Picture
    Muhammad Saleh 15 on at

    have you come up with a solution to this bug?

  • atajjo Profile Picture
    atajjo 509 on at

    Hello,

    I'm facing the same issue in a custom report. Does anyone know what causes this?

  • atajjo Profile Picture
    atajjo 509 on at

    The error seems to be coming from below method in "SrsProxy" class. Line no. 25 to be exact.

    /// Renders an SRS report and saves the results in the file and file format specified.
    /// Path to the report in Reporting Services
    /// Array containing ParameterValue objects.
    /// The path and name of the file to be created.
    /// The file format of the file to be created.
    /// Device specific information used by Reporting Services for printing the specified file format.
    /// Execution ID of a previous report run. If report output needs to be archived this is provided. Optional.
    /// A binary representation of the report.
    
    public System.Byte[] renderReportToByteArray(str _reportPath,
                                  Microsoft.Dynamics.AX.Framework.Reporting.Shared.ReportingService.ParameterValue[] _parameterValueArray,
                                  SRSReportFileFormat _fileFormat,
                                  str _deviceInfo,
                                  str _executionID = #EmptyString)
    {
        Microsoft.Dynamics.AX.Framework.Reporting.Shared.ReportFileFormat reportFileFormat;
        System.Collections.IEnumerator enumerator;
        System.Byte[] reportBytes = new System.Byte[0]();

        reportFileFormat = SRSProxy::convertToReportFileFormat(_fileFormat);

        try
        {
            this.SetReportingClusterHeadersIfNeeded();
            reportBytes = reportingServicesProxy.renderReportToByteArray(_reportPath, _parameterValueArray, reportFileFormat, _deviceInfo, _executionID);

            // Ensure the report was successfully returned
            if(reportBytes.Length == 0)
            {
                throw Exception::Error;
            }

            this.setExecutionInformation();
            
        }
        catch (Exception::CLRError)
        {
            // We must trap CLRError explicitly, to be able to retrieve the CLR exception later (using CLRInterop::getLastException() )
            SRSProxy::handleClrException(Exception::Error);
        }

        return reportBytes;
    }

  • atajjo Profile Picture
    atajjo 509 on at

    I'm using D365 btw

  • Shabir Ahmad Profile Picture
    Shabir Ahmad 3,124 on at

    Hi,

    Anyone find solution for this error, any idea??

    Best Regards,

    Shabir Ahmad

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!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Joris dG Profile Picture

Joris dG 5

#2
Alexey Lekanov Profile Picture

Alexey Lekanov 2

#2
Henrik Nordlöf Profile Picture

Henrik Nordlöf 2 User Group Leader

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans