Error: Subreport can not be shown

Hello,
I have a parameterized subreport and I'm getting this error message when
ever my subreport has an empty recordset (which is normal). Is there and
anyway to hide this or suppress the error message.
Thanks
RandyHi William,
I have a report that with a list control and each list item takes up a whole
page. On the page I have 9 subreports all tied to a Building ID (which is a
unique ID =Fields!BuildingID.Value) it seems to work fine on the first
page but after that I get the Error sub report message.
Randy
"William Wang[MSFT]" <v-rxwang@.online.microsoft.com> wrote in message
news:ueyb9YkcFHA.2788@.TK2MSFTNGXA01.phx.gbl...
> Hi Randy,
> Based on my research, this issue does not occur when the dataset of the
> subreport has no rows. Here I've attached the parent report and the
> subreport I used for testing purpose. 'Modified Employee Sales Summary' is
> the parent report and EmpSalesDetail is the subreport. They are created
> based on the sample report 'Employee Sales Summary'. After you select
> 'Pamela Ansman-Wolfe' from the 'Employee' drop down list (while 'Month' is
> set to December and Year is set to 2003 by default) and click View Report,
> you will find the subreport does not appear and there is not an error.
> For your issue, I suspect that in some cases you don't pass the correct
> parameter to the subreport. The probable situation is, your parent report
> passes a null or blank value to your subreport, but the subreport does not
> allow a null or blank value. This will result in the "Subreport could not
> be shown" error displayed in the parent report. If this is the case, you
> need to ensure that the correct value is passed to the subreport.
> Please feel free to let me know if anything is unclear.
> Sincerely,
> William Wang
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> --
>>From: "Randy_ts" <randy_ts@.nospam.nospam>
>>Subject: Error: Subreport can not be shown
>>Date: Wed, 15 Jun 2005 07:55:06 -0400
>>Lines: 11
>>X-Priority: 3
>>X-MSMail-Priority: Normal
>>X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
>>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527
>>X-RFC2646: Format=Flowed; Original
>>Message-ID: <ukEDVEacFHA.2688@.TK2MSFTNGP14.phx.gbl>
>>Newsgroups: microsoft.public.sqlserver.reportingsvcs
>>NNTP-Posting-Host: 198.77.232.92
>>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP14.phx.gbl
>>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:45986
>>X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
>>Hello,
>>I have a parameterized subreport and I'm getting this error message when
>>ever my subreport has an empty recordset (which is normal). Is there and
>>anyway to hide this or suppress the error message.
>>Thanks
>>Randy
>>|||Hi Randy,
I'm sorry that I'm unable to identify what the problem is just based on
your description. Could you reproduce this problem by creating a simple
main report and two subreports? I hope you could do this with the sample
database AdventureWorks, then I will follow your steps to produce the issue
on my end and see what the problem is. You could also send your sample
reports to me at v-rxwang@.microsoft.com.
If anything is unclear, feel free to contact me.
Sincerely,
William Wang
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>From: "Randy_ts" <randy_ts@.nospam.nospam>
>References: <ukEDVEacFHA.2688@.TK2MSFTNGP14.phx.gbl>
<ueyb9YkcFHA.2788@.TK2MSFTNGXA01.phx.gbl>
>Subject: Re: Error: Subreport can not be shown
>Date: Tue, 21 Jun 2005 11:32:22 -0400
>Lines: 78
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
>X-RFC2646: Format=Flowed; Original
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527
>Message-ID: <ulcptZndFHA.2180@.TK2MSFTNGP12.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.reportingsvcs
>NNTP-Posting-Host: 198.77.232.92
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:46393
>X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
>Hi William,
>I have a report that with a list control and each list item takes up a
whole
>page. On the page I have 9 subreports all tied to a Building ID (which is
a
>unique ID =Fields!BuildingID.Value) it seems to work fine on the first
>page but after that I get the Error sub report message.
>
>Randy
>
>
>"William Wang[MSFT]" <v-rxwang@.online.microsoft.com> wrote in message
>news:ueyb9YkcFHA.2788@.TK2MSFTNGXA01.phx.gbl...
>> Hi Randy,
>> Based on my research, this issue does not occur when the dataset of the
>> subreport has no rows. Here I've attached the parent report and the
>> subreport I used for testing purpose. 'Modified Employee Sales Summary'
is
>> the parent report and EmpSalesDetail is the subreport. They are created
>> based on the sample report 'Employee Sales Summary'. After you select
>> 'Pamela Ansman-Wolfe' from the 'Employee' drop down list (while 'Month'
is
>> set to December and Year is set to 2003 by default) and click View
Report,
>> you will find the subreport does not appear and there is not an error.
>> For your issue, I suspect that in some cases you don't pass the correct
>> parameter to the subreport. The probable situation is, your parent report
>> passes a null or blank value to your subreport, but the subreport does
not
>> allow a null or blank value. This will result in the "Subreport could not
>> be shown" error displayed in the parent report. If this is the case, you
>> need to ensure that the correct value is passed to the subreport.
>> Please feel free to let me know if anything is unclear.
>> Sincerely,
>> William Wang
>> Microsoft Online Partner Support
>> When responding to posts, please "Reply to Group" via your newsreader so
>> that others may learn and benefit from your issue.
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> --
>>From: "Randy_ts" <randy_ts@.nospam.nospam>
>>Subject: Error: Subreport can not be shown
>>Date: Wed, 15 Jun 2005 07:55:06 -0400
>>Lines: 11
>>X-Priority: 3
>>X-MSMail-Priority: Normal
>>X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
>>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527
>>X-RFC2646: Format=Flowed; Original
>>Message-ID: <ukEDVEacFHA.2688@.TK2MSFTNGP14.phx.gbl>
>>Newsgroups: microsoft.public.sqlserver.reportingsvcs
>>NNTP-Posting-Host: 198.77.232.92
>>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP14.phx.gbl
>>Xref: TK2MSFTNGXA01.phx.gbl
microsoft.public.sqlserver.reportingsvcs:45986
>>X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
>>Hello,
>>I have a parameterized subreport and I'm getting this error message when
>>ever my subreport has an empty recordset (which is normal). Is there and
>>anyway to hide this or suppress the error message.
>>Thanks
>>Randy
>>
>
>