Showing posts with label pdf. Show all posts
Showing posts with label pdf. Show all posts

Friday, March 30, 2012

ReportViewer Export PDF (Huge size) Workaround

If you have a chart or image in your reportviewer and you want to export file in PDF format, you will have an unusable big size pdf file.

Here is a work around fromsnapApps:(1/19/2007)

"snapApps createda solution for this problem. It involves disabling the export featurefrom the reportViewer toolbar and rendering the PDF through a custombutton. That's the easy part. Then you just use our PDFCompress libraryto compress the image streams contained within the PDF. You candownload PDFCompress athttp://www.snapapps.com/Components.aspx."

Hope this helps someone.

Hi,

I found a possible solution for this:

Download Orcas 2 Beta (I used the Virtual PC image, but the regular installation should work)

Look for:

Microsoft.ReportViewer.Common.dll

Microsoft.ReportViewer.WebForms.dll

Microsoft.ReportViewer.ProcessingObjectModel.dll

Note that the ProcessingObjectModel is in the global assembly cache. The way I was able to copy it was by going to the command line and doing adir Microsoft.ReportViewer.ProcessingObjectModel.dll /sin the root of the c drive. Then I found the location of the file, changed directory and copied the file to a previously created directory.

Make sure that the files that you pick are version 9.0.0.0!

Copy all those files and add the references in your VS2005 project. It seems that the ReportViewer version 9.0.0.0 which is in Orca is compatible with .NET 2.0.

Next, replace all references to 8.0.0.0 in any page that uses the report viewer with 9.0.0.0. Also, the web.config file has a reference to report viewer, make sure you substitute 8.0.0.0 for 9.0.0.0.

I have tested this method and it works. Make sure that the bin directory of your deployed application has the three files above.

ReportViewer Export Mode--Local Report

Is there a way to turn off PDF export for the ReportViewer control, while keeping the option to export to Excel?

Please let me know.

Thanks.

Unfortunately there is not. You can, however, turn off the entire export option and provide your own button to perform the Excel export, calling ReportViewer.LocalReport.Render() to get the data.

Wednesday, March 28, 2012

ReportViewer and pdf export

Hello,

I created a report using the ReportViewer control in client mode. The report is designed for the landscape orientation. In the rdlc file, the width is set to 11in and the height is set to 8.5in . When I export the file using the pdf format, it always uses the portrait orientation and thus cuts the main report table. I tried different page sizes, I can't figure out how to make the report viewer create a pdf file that uses the landscape orientation. Please help.

Thanks and regards,

Phil

Its based on the printer's default settings. Change those and it should work.

Eric

|||

Do you mean that the client user should set the default orientation of his default printer to Landscape or are you talking about server settings?

This is unrelated but my post was moved to SQL Server Reporting Services. I use VS 2005 on an Oracle database via ODBC. I don't know whether all ReportViewer related posts are moved here, but this is confusing for people who don't use SQL Server, like me.

Thanks and regards,

Phil

|||

Not sure, try server first then client.

Eric

|||

Changing the properties of the local printer has no effect (actually, you don't even need a local printer to export the report). I can't change the server printer settings and anyway some of my reports use the portrait orientation that I also need. There must be a way to make the report viewer export a pdf file with either the landscape or portrait format based on report settings...

Thanks and regards,

Phil

|||

Are you sure thatall the different size settings are set to width: 11in, height: 8.5in...?

In the "REPORT", there is both an "Interactive Size" and a "Page Size"... and then in the "BODY" there is also a "Size" setting. You are sure that you set the correct one?

Good luck!

|||

Ouch, I feel stupid now... I was only setting the BODY size, I never noticed that there is also a REPORT size, and that both sizes are independant. Thank you very much for your help, it is working now.

|||

Hi,

Can you specify what you did to overcome this problem. I am facing the same problem.

And for which is there a "Report" property. For a RDLC file or a reportviewer control. Because I dont find that for both of them.

To be more specific I have set all the four (Header , footer, body and also the report to width : 8.5 and height : 11 inch).

But Still i see 2 pages for PDF for one page.....

|||

Hello,

I opened the rdlc file in VS. In the menu bar, I went to Report >> Report Properties. I selected the second tab named Layout and I set the Page width and Page height properties to 11.69in and 8.27in (A4 landscape, 11in and 8.5in for US letter size).

HTH

Philippe

|||

Thanks Philippe. That was great and Thanks for the sooner reply.

|||

Click Report > Report Properties
Click the layout tab
Change the page width to 11
change the page height to 8.5

|||

Thanks.........

I did find the same in one of the sites and did.

Finally it did workout

|||

Thanks a lot

I spent two days to make page lanscape orientationSmile

Monday, March 26, 2012

ReportView control taking long time to Export report

When using Reserved.ReportViewerWebControl.axd control from within a web
application on a web server to export a Reporting Services report in PDF
format takes 5-10 minutes (note same problem no matter what export format
used). The control was incorporated into the web application via Visual
Studio. But when you export the same report using the web interface provided
on the Reporting Services machine it runs in seconds. The web services
machine of course is using the same control but it is on reporting services
web machine, where as the slow application uses the control provided by
Visual Studio which resides on the web box where the application lives. So
why is the ReportViewer control on the application IIS box, so much slower
than the ReportViewer on the Reporting Services IIS box for the same report?
--
If you are looking for SQL Server examples or a free SQL Server DBA
Dashboard tool check out my Website at http://www.sqlserverexamples.comJust to be clear. Are you saying when you use the Report Manager it takes
seconds? And when you use the report viewer web control it takes minutes?
Because below you are saying this: "The web services machine of course is
using the same control but it is on reporting services" This confuses me.
Is it your app on the machine or Report Manager. I don't think Report
Manager is using the control.
Now as far as the 5-10 minutes, are you using the control in local mode or
server mode?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Greg Larsen" <gregalarsen@.removeit.msn.com> wrote in message
news:85AD0C03-0420-4C4B-A241-C9249A3EE1CD@.microsoft.com...
> When using Reserved.ReportViewerWebControl.axd control from within a web
> application on a web server to export a Reporting Services report in PDF
> format takes 5-10 minutes (note same problem no matter what export format
> used). The control was incorporated into the web application via Visual
> Studio. But when you export the same report using the web interface
> provided
> on the Reporting Services machine it runs in seconds. The web services
> machine of course is using the same control but it is on reporting
> services
> web machine, where as the slow application uses the control provided by
> Visual Studio which resides on the web box where the application lives.
> So
> why is the ReportViewer control on the application IIS box, so much slower
> than the ReportViewer on the Reporting Services IIS box for the same
> report?
> --
> If you are looking for SQL Server examples or a free SQL Server DBA
> Dashboard tool check out my Website at http://www.sqlserverexamples.com

Friday, March 23, 2012

ReportServer Service Issue

We have multiple reports that are rendered in pdf format and delivered using
the email extension. We have started experiencing a rendering error that
stops the reports form rendering/delivery and only seems to be fixed after
restarting the ReportServer service. Could this be a timing issue? We have
multiple reports kicking off at the same time that render in pdf format. Any
help would be greatly appreciated.
Thanks,
SteveThe first thing to do is to go to the Logs for Report Server, generally under
MSSQL.3 directory of your install... Look there for clues...
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"Steve Bennett" wrote:
> We have multiple reports that are rendered in pdf format and delivered using
> the email extension. We have started experiencing a rendering error that
> stops the reports form rendering/delivery and only seems to be fixed after
> restarting the ReportServer service. Could this be a timing issue? We have
> multiple reports kicking off at the same time that render in pdf format. Any
> help would be greatly appreciated.
> Thanks,
> Steve
>
>|||This is the first exception in the log file, a generic GDI+ error and then
it cascades from there...
ReportingServicesService!reportrendering!524!01/30/2006-04:00:13:: e ERROR:
Throwing
Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown., ;
Info:
Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. -->
Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. --> System.Runtime.InteropServices.ExternalException: A generic
error occurred in GDI+.
at System.Drawing.Graphics.MeasureString(String text, Font font, SizeF
layoutArea, StringFormat stringFormat)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasFont.LineHeight(Graphics
graphics, SizeF maxSizeF)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasBase.LineHeight(CanvasFont
font)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.TextBox.CalculateItemMeasurement(Orientation
orientation)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItem.CalculatePage(Orientation
orientation, Boolean repeatableParent, Boolean canDelete, Double&
minimumCoordinate, Double& distance)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.CalculatePage(Orientation
orientation, Boolean repeatableParent, Boolean canDelete, Double&
minimumCoordinate, Double& distance)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.CalculatePage(Orientation
orientation, Boolean repeatableParent, Boolean canDelete, Double&
minimumCoordinate, Double& distance)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.CalculatePage(Orientation
orientation, Boolean repeatableParent, Boolean canDelete, Double&
minimumCoordinate, Double& distance)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.ProcessPages(CompositionBase
theComposition, Report theReport, Boolean needTotalPages, Int32 startPage,
Int32 endPage, Boolean render)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.ImageReport.RenderReport(Report
report, NameValueCollection deviceInfo, EvaluateHeaderFooterExpressions
evaluateHeaderFooterExpressions, CreateAndRegisterStream
createAndRegisterStreamCallback)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report
report, NameValueCollection reportServerParameters, NameValueCollection
deviceInfo, NameValueCollection clientCapabilities,
EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
CreateAndRegisterStream createAndRegisterStream)
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report
report, NameValueCollection reportServerParameters, NameValueCollection
deviceInfo, NameValueCollection clientCapabilities,
EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
CreateAndRegisterStream createAndRegisterStream)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(DateTime
A_0, GetReportChunk A_1, ProcessingContext A_2, RenderingContext A_3,
CreateReportChunk A_4, Boolean& A_5)
-- End of inner exception stack trace --
ReportingServicesService!library!524!01/30/2006-04:00:13:: i INFO:
Initializing EnableExecutionLogging to 'True' as specified in Server system
properties.
ReportingServicesService!notification!524!01/30/2006-04:00:13:: Notification
4a595bbc-4073-48ac-ac3c-e39b1aa50018 completed. Success: False, Status:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown., DeliveryExtension: Printer Delivery Sample, Report: TMP
ExceptionConformance Report, Attempt 1
ReportingServicesService!dbpolling!524!01/30/2006-04:00:13::
NotificationPolling finished processing item
4a595bbc-4073-48ac-ac3c-e39b1aa50018
ReportingServicesService!reportrendering!1210!01/30/2006-04:00:18:: e ERROR:
Throwing
Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown., ;
Info:
Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. -->
Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. --> System.Runtime.InteropServices.ExternalException: A generic
error occurred in GDI+.
at System.Drawing.Graphics.MeasureString(String text, Font font, SizeF
layoutArea, StringFormat stringFormat)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasFont.LineHeight(Graphics
graphics, SizeF maxSizeF)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasBase.LineHeight(CanvasFont
font)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.TextBox.CalculateItemMeasurement(Orientation
orientation)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItem.CalculatePage(Orientation
orientation, Boolean repeatableParent, Boolean canDelete, Double&
minimumCoordinate, Double& distance)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.CalculatePage(Orientation
orientation, Boolean repeatableParent, Boolean canDelete, Double&
minimumCoordinate, Double& distance)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.CalculatePage(Orientation
orientation, Boolean repeatableParent, Boolean canDelete, Double&
minimumCoordinate, Double& distance)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.CalculatePage(Orientation
orientation, Boolean repeatableParent, Boolean canDelete, Double&
minimumCoordinate, Double& distance)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.ProcessPages(CompositionBase
theComposition, Report theReport, Boolean needTotalPages, Int32 startPage,
Int32 endPage, Boolean render)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.ImageReport.RenderReport(Report
report, NameValueCollection deviceInfo, EvaluateHeaderFooterExpressions
evaluateHeaderFooterExpressions, CreateAndRegisterStream
createAndRegisterStreamCallback)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report
report, NameValueCollection reportServerParameters, NameValueCollection
deviceInfo, NameValueCollection clientCapabilities,
EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
CreateAndRegisterStream createAndRegisterStream)
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report
report, NameValueCollection reportServerParameters, NameValueCollection
deviceInfo, NameValueCollection clientCapabilities,
EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
CreateAndRegisterStream createAndRegisterStream)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(DateTime
A_0, GetReportChunk A_1, ProcessingContext A_2, RenderingContext A_3,
CreateReportChunk A_4, Boolean& A_5)
-- End of inner exception stack trace --
ReportingServicesService!library!1210!01/30/2006-04:00:18:: i INFO:
Initializing EnableExecutionLogging to 'True' as specified in Server system
properties.
ReportingServicesService!notification!1210!01/30/2006-04:00:18::
Notification d1ffd955-b678-4a68-83d2-dddfffa5fe9e completed. Success:
False, Status: Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown., DeliveryExtension: Printer Delivery Sample, Report: GWD
ExceptionConformance Report, Attempt 1
Sorry, the first reply went to the wrong message...
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:687E1061-75DB-400E-BB7A-5975FE043A9B@.microsoft.com...
> The first thing to do is to go to the Logs for Report Server, generally
> under
> MSSQL.3 directory of your install... Look there for clues...
>
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> I support the Professional Association for SQL Server ( PASS) and it''s
> community of SQL Professionals.
>
> "Steve Bennett" wrote:
>> We have multiple reports that are rendered in pdf format and delivered
>> using
>> the email extension. We have started experiencing a rendering error that
>> stops the reports form rendering/delivery and only seems to be fixed
>> after
>> restarting the ReportServer service. Could this be a timing issue? We
>> have
>> multiple reports kicking off at the same time that render in pdf format.
>> Any
>> help would be greatly appreciated.
>> Thanks,
>> Steve
>>

ReportServer is hanging - what should I look for? what to do?

Greetings,
Someone was trying to run a report today, but the normal pdf is not coming
up from Internet Explorer. I tried to go straight to the Report server from
Internet Explorer
http://myserver/ReportServer
This would normally bring up a page displaying the various Report
directories. But Internet Explorer is just spinning around and the
ReportServer page is not coming up. Is it the ReportServer or Internet
Explorer? I went directly to the main server computer and tried to open the
ReportServer page from there (on Internet Explorer), but IE is hanging there
too. What should I do? What should I look for?
Thanks,
RichWe had a webcast going on, and I am pretty sure that was on a different
server. But after the webcast was over, everything returned back to normal
on our primary server. '
"Rich" wrote:
> Greetings,
> Someone was trying to run a report today, but the normal pdf is not coming
> up from Internet Explorer. I tried to go straight to the Report server from
> Internet Explorer
> http://myserver/ReportServer
> This would normally bring up a page displaying the various Report
> directories. But Internet Explorer is just spinning around and the
> ReportServer page is not coming up. Is it the ReportServer or Internet
> Explorer? I went directly to the main server computer and tried to open the
> ReportServer page from there (on Internet Explorer), but IE is hanging there
> too. What should I do? What should I look for?
> Thanks,
> Rich|||On Jan 23, 3:39 pm, Rich <R...@.discussions.microsoft.com> wrote:
> We had a webcast going on, and I am pretty sure that was on a different
> server. But after the webcast was over, everything returned back to normal
> on our primary server. '
> "Rich" wrote:
> > Greetings,
> > Someone was trying to run a report today, but the normal pdf is not coming
> > up from Internet Explorer. I tried to go straight to the Report server from
> > Internet Explorer
> >http://myserver/ReportServer
> > This would normally bring up a page displaying the various Report
> > directories. But Internet Explorer is just spinning around and the
> > ReportServer page is not coming up. Is it the ReportServer or Internet
> > Explorer? I went directly to the main server computer and tried to open the
> > ReportServer page from there (on Internet Explorer), but IE is hanging there
> > too. What should I do? What should I look for?
> > Thanks,
> > Rich
This article might help in terms of performance.
http://msdn2.microsoft.com/en-us/library/ms159809.aspx
It could very well be related to network latency; however, you will
want to look into various things. The perfmon.exe/Performance Monitor
is a good place to start. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

Monday, March 12, 2012

Reports building from SQL SERVER 2000 and .NET 1.1

Dear all

I would like to produce a report on the data i have in my database probably in a pdf or excel or word document. What i have is SQL Server 2000 with .NET 1.1 platform.

Is there anything out there i could use?

I have done some work on reporting services but thats with SQL server 2005, but now i have to go a bit back.

Any advice?

cheers

Or is there any other solution to the problem or producing reports in excel/word/pdf formats except for using Reporting services or crystal reports?

|||

You need SQL Server 2000 Enterprise edition or Developer edition it helps to have server operating systems, remember not to answer Windows questions unless you are forced or relevant questions, this is one of the hardest things to install, Windows ask stupid questions and stop your installation. The two links below covers all you need, the download is in the first link. Hope this helps.

http://www.microsoft.com/sql/prodinfo/previousversions/default.mspx

http://www.15seconds.com/Issue/041013.htm

Friday, March 9, 2012

ReportRenderingException when exporting to excel

Hi all
I have a report that works fine for html and pdf rendering. But when I
export it to excel RS throws a ReportRenderingException. The error is "Stack
empty". Anything else like PDF, TIFF... is rendering without errors. Does
anyone has similar problems or knows whats wrong? Can this be a bug?
Here's an extraction of the log file:
w3wp!library!ed8!12/07/2004-17:03:20:: i INFO: Call to RenderNext(
'/Astrada/Ferienuebersicht' )
w3wp!chunks!ed8!12/07/2004-17:03:20:: i INFO: ###
GetReportChunk('RenderingInfo_EXCEL', 2), chunk was not found!
this=cdb86ab2-85ce-41b8-9edc-3faffec8410b
w3wp!reportrendering!ed8!12/07/2004-17:03:24:: e ERROR: Throwing
Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown., ;
Info:
Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. -->
Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. --> System.InvalidOperationException: Stack empty.
at System.Collections.Stack.Pop()
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelFormulaHandler.GetPostFixNotation(String[] tokens, ArrayList finalExpr)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelFormulaHandler.ProcessFormula(String formula, ArrayList& postFixList, Hashtable& literals)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GenerateExcelFormula(IReportItemInfo
reportItemInfo, String outputTypeCode, Hashtable& literals)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderTextBox(ReportItemInfo
reportItemInfo, PageCell pageCell, PageTableGrid pageTableGrid, Hashtable&
duplicateItemsTable, Int32 row, Int32 col, Boolean addHeaderRows)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderGridCell(PageLayout
pageLayout, Int32 row, Int32 col, Hashtable& duplicateItemsTable, Boolean
addHeaderRows)
at
Microsoft.ReportingServices.Rendering.BIFFUtility.WorkSheet.WriteRowBlocksAndCells(ExcelRenderer
excelRenderer, Stream stream, UInt32 indexBeginOffsetPosition, Int32 minCol,
Int32 maxCol)
at
Microsoft.ReportingServices.Rendering.BIFFUtility.BaseWorkSheet.WriteWorkSheet(ExcelRenderer excelRenderer, Stream stream, Int32 offset)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderPageLayout(PageLayout pageLayout, Int32& currentPageNumber, Stack& stack)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderPageCollection(PageCollection
pageCollection, Int32& currentPageNumber, Stack& stack, PageLayout&
lastPageLayout)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GenerateWorkSheets()
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GenerateMainSheet()
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderExcelWorkBook(CreateAndRegisterStream createAndRegisterStream)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.ProcessReport(CreateAndRegisterStream createAndRegisterStream)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.Render(Report
report, NameValueCollection reportServerParameters, NameValueCollection
deviceInfo, NameValueCollection clientCapabilities,
EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
CreateAndRegisterStream createAndRegisterStream)
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.Render(Report
report, NameValueCollection reportServerParameters, NameValueCollection
deviceInfo, NameValueCollection clientCapabilities,
EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
CreateAndRegisterStream createAndRegisterStream)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk
createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
-- End of inner exception stack trace --
w3wp!webserver!ed8!12/07/2004-17:03:30:: e ERROR: Reporting Services error
Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. -->
Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. --> System.InvalidOperationException: Stack empty.
Thanks for any help!
M. PeyerThis problem occurred for me when I had a value expression in a text
box on the group header/footer. I am running SP1. Before SP1 was loaded
the report would export to excel without the Stack Empty but the
expression would not evaluate. With SP1 I get the Stack Empty error.
Once I removed the expressions the stack empty error went away.
Steve|||This problem occurred for me when I had a value expression in a text
box on the group header/footer. I am running SP1. Before SP1 was loaded
the report would export to excel without the Stack Empty but the
expression would not evaluate. With SP1 I get the Stack Empty error.
Once I removed the expressions the stack empty error went away.
Steve

ReportRenderingException for Subscription PDF

I deployed reports to a new server running Server 2003 and RS SP2. I can view
my reports in IE, and export them as PDF's. But when I put them on a shared
schedule, the PDF's throw a ReportRenderingException. The Excel reports are
running fine.
I need to run several hundred reports tomorrow, so any help would be
appreciated.
I can't find where this might be in the log files, searching for the report
name or the
string ReportRenderingException yields nothing.Hello,
From the post, it seems that you can view the report, and manually export
it to a pdf file successfully; however, when exporting the report via
Subscription as pdf file, you received the ReportRenderingException error.
You can export the report via Subscription as Excel reports successfully.
If I'm off base, please feel free to let me know.
Please note that the newsgroups are staffed weekdays by Microsoft Support
professionals to answer your non-urgent, break/fix systems and applications
questions. Since this issue is urgent, please contact Customer Service and
Support (CSS) for more immediate assistance. For more information on
available CSS services, please click here:
http://support.microsoft.com/default.aspx?scid=fh;EN-US;OfferProPhone#faq607
.
If you are outside the United States, please visit our International
Support page:
http://support.microsoft.com/default.aspx?scid=%2finternational.aspx.
If you'd like to work with newsgroup, please help me collect some
information to troubleshoot the issue or perform troubleshooting steps:
1. Please check if the issue is report related. If possible, test a simple
report to check the issue.
For example, if the issue occurs on a matrix report which has a several
matrix columns, check other report which isn't matrix report.
2. Please check if the issue is account related.
If possible, log on as a domain\administrative user account to test the
issue.
3. Please check if the issue is machine related.
4. Use FileMon and RegMon to check if there is any registry permission
issue or file permission issue.
You can download them from the following web site:
FileMon:
http://www.sysinternals.com/ntw2k/source/filemon.shtml
RegMon:
http://www.sysinternals.com/ntw2k/source/regmon.shtml
Check the FileMon log file and RegMon log file to see if there is any
"Access Denied" error. If so, grant full control on the related registry
key or files.
5. Check the reporting services log files. By default, the log files are
located in the C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\LogFiles folder.
6. Post here the exact error message.
I hope the information is helpful.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================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.|||Thanks, Sophie!
I resolved this particular problem with at "shot in the dark", makeing sure
that "Do not timeout report execution" was checked on Site Settings. This got
most of my reports to run properly.
I'm still getting occasional "Error: Subreport could not be shown" for
reports that I can run manually, and which can be run with the same
parameters on the same schedule! Reports running on that schedule after that
report run fine. Sometimes the error shows with the first subreport,
sometimes with only some (but once it shows up, all the subreports in that
report fail until the last one which has no external data connection.)
Perhaps there's another setting, not in the web-gui that I can set?
Thanks,
Avery.
"Sophie Guo [MSFT]" wrote:
> Hello,
> From the post, it seems that you can view the report, and manually export
> it to a pdf file successfully; however, when exporting the report via
> Subscription as pdf file, you received the ReportRenderingException error.
> You can export the report via Subscription as Excel reports successfully.
>|||Hello,
Based on my research, similar issue was resolved by recreating main report
or Subreport which has problems.
I suggest that you perform the following steps to narrow down the issue:
1. Check if the Subreport is able to render by itself as a stand-alone
report.
2. Check if the Main report is able to render by itself as a stand-alone
report.
3. Create a test report with a test subreport. Make sure it works fine.
4. Add the failing subreport to the test project and the test main report.
If it works fine, the original main report may have problems. If so,
recreate the original main report and add the subreport to it to test.
Also, you can configure the Report Server for Tracing. You may need to set
the Tracing Levels to 4 (Verbose mode). Then reproduce the issue. After
that, check the Reporting Services Trace Logs to find the cause.
For more information to configure a Report Server for Tracing, please
access the following web site:
Configuring a Report Server for Tracing
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm
/arp_configserver_v1_273t.asp
If the issue still exists, please post here the trace logs for research.
I hope the information is helpful.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================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.