Dynamics AX 2009 and SSRS Stack issue and Nested Query issue

• Question

• 

  

  0

  Sign in to vote

  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

  Regards,

  Raja

  Saturday, October 6, 2012 5:51 PM