SSRS Reporting Errors

SSRS report with blank sub report shows white space

This articles SSRS reporting error looks at missing background colors on a blank sub report.

You have setup your table, got your group in order and created your sub reports. Everything looks good except for the white space left be an empty sub report. This post from ChallengerX looks at this annoying problem.

There are many varying solutions around. Pass the color via a parameter to the sub report seems to be a common one. Our scenario looks at a sub report in merged cells. We have tested this will single Tablix cells and the problem in our case is the same.

The best, easiest solution is as follows: Before adding the sub report add a rectangle to where the sub report will go. Make sure the rectangle is the exact same size as the sub report.

The technicians at ChallengerX have been collectively working with SQL Server for over 30 years. In this time we have been called upon to solve many database and reporting challenges. We have been involved in many reporting projects that feature SSRS and Crystal reports.

Have SSRS reporting errors we can help.

Phone: 1300 088 712

Email: [email protected]