Getting this error when viewing the SSRS report

Copper Contributor

1. when I am writing a subquery that must also include null values records this error is populating 

 

Error message: 

  • An error has occurred during report processing. (rsProcessingAborted)
    • Query execution failed for dataset 'CSIP'. (rsErrorExecutingCommand)
      • For more information about this error navigate to the report server on the local server machine, or enable remote errors

2. when trying with join condition it is not throwing error but null value records are not populating

I want to show report with all records including null values 

 

can anyone help me with this error.

Thanks in advance

0 Replies