Error while exporting SSRS Reports to Excel | CloudFronts

Error while exporting SSRS Reports to Excel


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.


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!!

Share Story :

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.