Forum Discussion

navya942's avatar
navya942
Copper Contributor
May 07, 2024

Getting this error when viewing the SSRS report

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

1 Reply

  • ih_bbb's avatar
    ih_bbb
    Copper Contributor
    May 23, 2024
    This looks like a sql issue. not report issue. You probably be better luck posting this in SQL fourm. However, it depends on what you want to do. If you want to bring back rows with null values from your sub query, you may want to use left join. Don't use inner join or join (plain join can also act as inner join). Again, it's hard to do it without knowing the whole thing. Good luck

Resources