How to change background color for NULL subreport?

Question

I have a parent RDL that links a subreport into one of the table columns.  So if this subreport has records, it displays correctly as you can see from this screenshot.  I want the background color to be purple always, whether or not subreport has data.  But when subreport does not have any data for that row, it displays a white background color.  How do I change this so that it displays purple background color?

---

Ryan D

Answer 1

Is the background color of the subreport set to purple? If not, try setting it to purple.

---

Please Mark posts as answers or helpful so that others can more easily find the answers they seek.

Answer 2

you would need to pad some null rows in your subreport query, possibly using union all, to make sure your subreport will always bring back at least a row. that way your background purple will always shows. good luck.

Answer 3

Hi Ryan,

To work around this issue, you can try to union a dummy row with none values in the Subreport dataset, just as I_h posted above.

The following threads are about the same issue, please take as reference:
http://social.msdn.microsoft.com/Forums/is/sqlreportingservices/thread/63497900-cd53-4017-b1c1-64a5ca1d4183
http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/3af7479e-8604-4e1a-af12-8170f0272c9d

Regards,
Fanny Liu

TechNet Subscriber Support
If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here.

---

Fanny Liu

TechNet Community Support