sql server reporting services: Subreports and NoRows -- sql server reporting services

Subreports and NoRows

Dune
9/8/2004 4:23:02 PM

sql server reporting services: Hi there,

I have a report that contains several subreports. My main report consists of
a list and within that list, a table. My subreports each reside in a detail
row of this table. Each subreport is set up in the same way, with a table
within a list.

I have set the NoRows property of the lists in each subreport. However, when
there are no rows for the subreports, in my main report, I just get a blank
detail row for each subreport instead of the NoRows message. When I run each
subreport separately and there are no rows, the NoRows message shows up fine
for each subreport.

Any ideas?

Re: Subreports and NoRows

Robert Bruckner [MSFT]
9/9/2004 8:34:07 PM

In the main report where you added the subreport reportitem - did you set
the NoRows message there?
Note: if a subreport has no rows, then NoRows messages on data regions
inside the subreport will not be shown, because the subreport is not
executed. Only the NoRows message of the subreport reportitem in the main
report will be shown.

--
This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]