Error while exporting SSRS Reports to Excel

Introduction:

Recently, we encountered an issue while exporting the SSRS Reports to Excel. In CRM, the SSRS Report was displaying the data correctly but for few filter criteria, we were not able to export the Reports to Excel.  On troubleshooting in SQL Data Tools, we found that it was throwing the below error.

Error Details:

The row item structure object corresponding to a line cannot be null.

Reason for the error:

We had 2 matrix in our Report one of which had data and another was retrieving no rows according to few criteria. Whenever a matrix is null, you cannot export the Report to Excel as Excel does not render null matrix.

Solution:

Add a visibility condition on the matrix that if the dataset pertaining to the matrix returns no rows then hide the table.

Voila! You are good to go.

Happy Reporting!!