Problems with Subreports when no data is returned & page breaks ar

I've been fighting a problem in SQL Reporting Services 2005 and am about to
go nuts! I have a main report that contains multiple subreports. Each
subreport is contained within its own List (I've tried Tables too), tied to
the DataSet specific to each subreport. Each subreport may or may not return
data, based on the DataSet of the List/Table.
My problem occurs when one or all of the subreports do not return data. The
users would like each subreport to start on a new page, which I thought
should be simply handled by setting the Page Break at Start property of the
List/Table's Grouping. This does in fact work as desired, but only when ALL
subreports return data. When one (or more) of the subreports is blank, an
extra page is rendered, which when paged to causes an error (An error
occurred during local report processing. An internal error occurred on the
report server. See the error log for more details.) I've been able to find
nothing in any error log, which is what the BOL says for this error (in
addition to telling you that this error should never occcur!).
Can someone please help!? I have a deadline to meet!
Thanks in advance.Hi Jeff,
I am stuck with the same problem and have been recommended to use the NoRows
property. However this does unfortunately not help. The problem seems to
arise as soon as something re-renders the page. In my case a drill-down
re-renders the page and causes this error if I have an empty sub-report on
the page.
If you have found a work-around I would be glad if you could post it.
"Jeff Rautzahn" wrote:
> I've been fighting a problem in SQL Reporting Services 2005 and am about to
> go nuts! I have a main report that contains multiple subreports. Each
> subreport is contained within its own List (I've tried Tables too), tied to
> the DataSet specific to each subreport. Each subreport may or may not return
> data, based on the DataSet of the List/Table.
> My problem occurs when one or all of the subreports do not return data. The
> users would like each subreport to start on a new page, which I thought
> should be simply handled by setting the Page Break at Start property of the
> List/Table's Grouping. This does in fact work as desired, but only when ALL
> subreports return data. When one (or more) of the subreports is blank, an
> extra page is rendered, which when paged to causes an error (An error
> occurred during local report processing. An internal error occurred on the
> report server. See the error log for more details.) I've been able to find
> nothing in any error log, which is what the BOL says for this error (in
> addition to telling you that this error should never occcur!).
> Can someone please help!? I have a deadline to meet!
> Thanks in advance.

Problems with RS Unattended Execution Account

HI all
I have RS2000 Report Server with a report that contains an image control.
The image control value is a UNC path to an image (ie
\\<server>\images\image.jpg. The <server> is a different server to the
Report Server. I have setup the unattended execution account to be the
domain administrator (for testing purposes). WHen running the report on my
machine in Visual Studio, I can see the images, however when running it off
the server the images do not appear. I setup object access auditing on the
server containing the images and it seems like the report server is not even
attemting to access the images.
Anyone know what I may be missing here.
Thanks in advance
GeorgeOn Aug 29, 2:15 am, "_george" <none@.nojne@.none> wrote:
> HI all
> I have RS2000 Report Server with a report that contains an image control.
> The image control value is a UNC path to an image (ie
> \\<server>\images\image.jpg. The <server> is a different server to the
> Report Server. I have setup the unattended execution account to be the
> domain administrator (for testing purposes). WHen running the report on my
> machine in Visual Studio, I can see the images, however when running it off
> the server the images do not appear. I setup object access auditing on the
> server containing the images and it seems like the report server is not even
> attemting to access the images.
> Anyone know what I may be missing here.
> Thanks in advance
> George
It might be that since you are accessing the image through the Report
Server, which is basically a website, you may be using the default
ASPNET account that has minimal permissions in the system. On
occasion, explicit settings are overridden in ASP.NET and IIS.
Depending on your circumstances, you could try embedding the image in
the report. Also, you might want to check the settings in one of
the .config files in the path: C:\Program Files\Microsoft SQL Server
\MSSQL.x\Reporting Services\ReportManager it may be overriding your
domain admin account. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Thanks Enrique
I had swapped the default ASP.Net account used in the Out of process
components for IIS to a Domain Administrator account but still no go. As for
the config files, what exactly should I be looking for' I was under the
impression that all usernames and pwds in the .config files are encrypted.
Thanks again
George
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1188435094.798326.100950@.22g2000hsm.googlegroups.com...
> On Aug 29, 2:15 am, "_george" <none@.nojne@.none> wrote:
>> HI all
>> I have RS2000 Report Server with a report that contains an image control.
>> The image control value is a UNC path to an image (ie
>> \\<server>\images\image.jpg. The <server> is a different server to the
>> Report Server. I have setup the unattended execution account to be the
>> domain administrator (for testing purposes). WHen running the report on
>> my
>> machine in Visual Studio, I can see the images, however when running it
>> off
>> the server the images do not appear. I setup object access auditing on
>> the
>> server containing the images and it seems like the report server is not
>> even
>> attemting to access the images.
>> Anyone know what I may be missing here.
>> Thanks in advance
>> George
>
> It might be that since you are accessing the image through the Report
> Server, which is basically a website, you may be using the default
> ASPNET account that has minimal permissions in the system. On
> occasion, explicit settings are overridden in ASP.NET and IIS.
> Depending on your circumstances, you could try embedding the image in
> the report. Also, you might want to check the settings in one of
> the .config files in the path: C:\Program Files\Microsoft SQL Server
> \MSSQL.x\Reporting Services\ReportManager it may be overriding your
> domain admin account. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>