Always show Subreport (need to always show Background Color)

I have tried adding a second dataset so that my subreport always returns a result, but this has not worked yet. I need a subreport to always show because the row is in Gainsboro background color and when there is no data, half the row is Gainsboro and half is White.

Any ideas?

make sure your query is returning a row, even if it is blank, or at least return a empty value if your result set is empty.

if mydataset.count (or whatever) =0 then

return " "

end if

you could check for this in your sql statement or query.

Always Display Subreport (including background color)

I have tried adding a second dataset so that my subreport always returns a
result, but this has not worked yet. I need a subreport to always shown
because the row is in Gainsboro background color and when there is no data,
half the row is Gainsboro and half is White.
Any ideas?I also do something like that too. I use a dataset called 'ForceRows' that
looks like this.
SELECT 'DummyRow'
Steve MunLeeuw
"bjkaledas" <bjkaledas@.discussions.microsoft.com> wrote in message
news:F2859D73-24D0-4F7D-96BD-A18B4B4BD4E7@.microsoft.com...
>I have tried adding a second dataset so that my subreport always returns a
> result, but this has not worked yet. I need a subreport to always shown
> because the row is in Gainsboro background color and when there is no
> data,
> half the row is Gainsboro and half is White.
> Any ideas?