Friday, November 16, 2012 5:40 PM
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?
Friday, November 16, 2012 7:09 PM
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.
Friday, November 16, 2012 9:43 PMyou 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.
Monday, November 19, 2012 6:37 AMModerator
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:
TechNet Community Support