Dynamics AX 2009 and SSRS Stack issue and Nested Query issue RRS feed

  • Question

  • Hi,

    Please find the below issue and suggest any solution.

    Issue :An error has occurred during report processing. (rsProcessingAborted)
    Cannot read the next data row for the dataset SalesCommission. (rsErrorReadingNextDataRow)
    Dynamics Object Adapter Call failed.
    Stack trace: The operation that you are performing generates a
    SQL statement that contains too many nested statements. Break the operation into multiple parts, and try again. (C)\Classes\QueryRun\next



    Saturday, October 6, 2012 5:51 PM