Hiding a Subreport

Hi, Folks.
I have a "List" report which contains a "Table"-style subreport.
I'd like to display the table, WITH the headers, as the subreport ONLY IF
there are some elements to be displayed within the table. In many cases,
there will be no data in the subreport. I'd like to suppress the entire
subreport if there are no rows in the table.
Alternatively, I'd be happy to simply suppress/hide the table header row
when the number of rows returned is zero. I have a field in the table
header called "NumKey", which is the Count(KeyValue). If no records, then
the table should be hidden; if there are one or more records, all the
records AND the table leader should be displayed.
Alas, there doesn't seem to be anyplace that I can access the "Visible"
property for the entire subreport from within the subreport itself, and
there's no place within the table header that allows me to change the
"Visible" propery of the header row based on the "NumKey" text box.
This ought to be possible. What am I missing?
Thanks.
--
---
Ken Mitchell ken@.creativemindssacramento.com
916-275-3610 (voice) Citrus Heights, CA
--http://www.creativemindssacramento.com--
"Those of us who DO remember our history are condemned to live
watching others around us trying to repeat it. "
---Two options:
1. Set the visible property on the table and use Count(KeyValue) in the
expression for this property.
2. Set the NoRows property on the table, so the NoRows text will be shown
instead of the table when there is no data.
Fang Wang (MSFT)
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ken Mitchell" <cmmcken@.comcast.net> wrote in message
news:OFTN4w%23XEHA.2972@.TK2MSFTNGP12.phx.gbl...
> Hi, Folks.
> I have a "List" report which contains a "Table"-style subreport.
> I'd like to display the table, WITH the headers, as the subreport ONLY IF
> there are some elements to be displayed within the table. In many cases,
> there will be no data in the subreport. I'd like to suppress the entire
> subreport if there are no rows in the table.
> Alternatively, I'd be happy to simply suppress/hide the table header row
> when the number of rows returned is zero. I have a field in the table
> header called "NumKey", which is the Count(KeyValue). If no records, then
> the table should be hidden; if there are one or more records, all the
> records AND the table leader should be displayed.
> Alas, there doesn't seem to be anyplace that I can access the "Visible"
> property for the entire subreport from within the subreport itself, and
> there's no place within the table header that allows me to change the
> "Visible" propery of the header row based on the "NumKey" text box.
> This ought to be possible. What am I missing?
> Thanks.
> --
> ---
> Ken Mitchell ken@.creativemindssacramento.com
> 916-275-3610 (voice) Citrus Heights, CA
> --http://www.creativemindssacramento.com--
> "Those of us who DO remember our history are condemned to live
> watching others around us trying to repeat it. "
> ---
>
>