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?

Alternative Color

Does anyone know how to do alternative color row dynamically on reports? I
can do that in ASP.NET DataGrid.. but can't seem to find a property on
reporting server..Hi Zean,
You can alternate the color row of your tables putting the following
expression in the BackgroundColor property of the table or part of the table
you want :
=iif(RowNumber(Nothing) Mod 2 , "#F9F9F9","#EBEBEB" )
"Zean Smith" <nospam@.nospamaaamail.com> wrote in message
news:BfSdnRTl74eizsPenZ2dnUVZ_tCdnZ2d@.rogers.com...
> Does anyone know how to do alternative color row dynamically on reports?
I
> can do that in ASP.NET DataGrid.. but can't seem to find a property on
> reporting server..
>|||And in case, you don't have a simple table report item, but a matrix report
item you should check the following blog article:
http://blogs.msdn.com/chrishays/archive/2004/08/30/GreenBarMatrix.aspx
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Maria Isabel Henao" <dev@.hotmail.com> wrote in message
news:eVUEN%23Y2FHA.2444@.TK2MSFTNGP10.phx.gbl...
> Hi Zean,
> You can alternate the color row of your tables putting the following
> expression in the BackgroundColor property of the table or part of the
> table
> you want :
>
> =iif(RowNumber(Nothing) Mod 2 , "#F9F9F9","#EBEBEB" )
> "Zean Smith" <nospam@.nospamaaamail.com> wrote in message
> news:BfSdnRTl74eizsPenZ2dnUVZ_tCdnZ2d@.rogers.com...
>> Does anyone know how to do alternative color row dynamically on reports?
> I
>> can do that in ASP.NET DataGrid.. but can't seem to find a property on
>> reporting server..
>>
>