Showing posts with label exporting. Show all posts
Showing posts with label exporting. Show all posts

Wednesday, March 28, 2012

PDF rendering bug in SP2

We just upgraded to SP2 and some reports now fail to render in PDF format. They render successfully as HTML within IE, but exporting to PDF gives the following error:

An error occurred during rendering of the report. (rrRenderingError)

An error occurred during rendering of the report.

Non-negative number required. Parameter name: value

The log gives the following traceback:

at Microsoft.Reporting.WebForms.ServerReport.InternalRender(String format, String deviceInfo, String& extension, String& mimeType, String& encoding, String[]& streams, Warning[]& warnings)
at Microsoft.Reporting.WebForms.ServerReport.Render(String format, String deviceInfo, NameValueCollection additionalParams, String& mimeType, String& extension)
at Microsoft.Reporting.WebForms.ServerReportControlSource.RenderReport(String format, String deviceInfo, NameValueCollection additionalParams, String& mimeType, String& fileExtension)
at Microsoft.Reporting.WebForms.ExportOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response)
at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
aspnet_wp!library!6!17/04/2007-10:27:17:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
aspnet_wp!library!5!17/04/2007-10:28:09:: i INFO: Call to RenderNext( '/EFaultReports/FaultReport' )
aspnet_wp!cache!5!17/04/2007-10:28:09:: i INFO: Session live: /EFaultReports/FaultReport
aspnet_wp!library!5!17/04/2007-10:28:23:: i INFO: Call to RenderNext( '/EFaultReports/FaultReport' )
aspnet_wp!reportrendering!5!17/04/2007-10:28:23:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException: An error occurred during rendering of the report., ;
Info: Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException: An error occurred during rendering of the report. > Microsoft.ReportingServices.ReportRendering.ReportRenderingException: An error occurred during rendering of the report. > System.ArgumentOutOfRangeException: Non-negative number required.
Parameter name: value
at System.IO.MemoryStream.set_Position(Int64 value)
at Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasPDF.MonochromeJpeg(MemoryStream memStream)
at Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasPDF.ProcessImage(CanvasImagePDF image, Double left, Double top, Double width, Double height, Boolean scaleImage)
at Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasPDF.DrawImage(OutlineObjects outlines, CanvasImage image, Double left, Double top, Double width, Double height)
at Microsoft.ReportingServices.Rendering.ImageRenderer.Image.RenderToPage(Measurement parentClipBorder)
at Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement parentClipBorder)
at Microsoft.ReportingServices.Rendering.ImageRenderer.Table.TableCell.RenderToPage(Measurement parentClipBorder)
at Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement parentClipBorder)
at Microsoft.ReportingServices.Rendering.ImageRenderer.Table.TableRow.RenderToPage(Measurement parentClipBorder)
at Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement parentClipBorder)
at Microsoft.ReportingServices.Rendering.ImageRenderer.Table.RenderToPage(Measurement parentClipBorder)
at Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement parentClipBorder)
at Microsoft.ReportingServices.Rendering.ImageRenderer.Rectangle.RenderToPage(Measurement parentClipBorder)
at Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement parentClipBorder)
at Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.ProcessPages(CompositionBase theComposition, Report theReport, Boolean needTotalPages, Int32 startPage, Int32 endPage, Boolean render)
at Microsoft.ReportingServices.Rendering.ImageRenderer.PdfReport.RenderReport(Report report, NameValueCollection deviceInfo, EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions, CreateAndRegisterStream createAndRegisterStreamCallback, Int32 streamPageNumber)
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.RenderSnapshot(IRenderingExtension renderer, CreateReportChunk createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
End of inner exception stack trace
aspnet_wp!library!5!17/04/2007-10:28:23:: Unhandled exception was caught: Microsoft.Reporting.WebForms.ReportServerException: An error occurred during rendering of the report. (rrRenderingError) > Microsoft.Reporting.WebForms.ReportServerException: An error occurred during rendering of the report. > Microsoft.Reporting.WebForms.ReportServerException: Non-negative number required.
Parameter name: value
End of inner exception stack trace
End of inner exception stack trace

Hi

We have got same problem and I have found that it happens with reports containing *.pjpeg images. Not all *.pjpeg gives this problem.

Please reply if anyone knows the fix. it is urgent

Thanks

Satjinder

sql

PDF rendering bug in SP2

We just upgraded to SP2 and some reports now fail to render in PDF format. They render successfully as HTML within IE, but exporting to PDF gives the following error:

An error occurred during rendering of the report. (rrRenderingError)

An error occurred during rendering of the report.

Non-negative number required. Parameter name: value

The log gives the following traceback:

at Microsoft.Reporting.WebForms.ServerReport.InternalRender(String format, String deviceInfo, String& extension, String& mimeType, String& encoding, String[]& streams, Warning[]& warnings)
at Microsoft.Reporting.WebForms.ServerReport.Render(String format, String deviceInfo, NameValueCollection additionalParams, String& mimeType, String& extension)
at Microsoft.Reporting.WebForms.ServerReportControlSource.RenderReport(String format, String deviceInfo, NameValueCollection additionalParams, String& mimeType, String& fileExtension)
at Microsoft.Reporting.WebForms.ExportOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response)
at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
aspnet_wp!library!6!17/04/2007-10:27:17:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
aspnet_wp!library!5!17/04/2007-10:28:09:: i INFO: Call to RenderNext( '/EFaultReports/FaultReport' )
aspnet_wp!cache!5!17/04/2007-10:28:09:: i INFO: Session live: /EFaultReports/FaultReport
aspnet_wp!library!5!17/04/2007-10:28:23:: i INFO: Call to RenderNext( '/EFaultReports/FaultReport' )
aspnet_wp!reportrendering!5!17/04/2007-10:28:23:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException: An error occurred during rendering of the report., ;
Info: Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException: An error occurred during rendering of the report. > Microsoft.ReportingServices.ReportRendering.ReportRenderingException: An error occurred during rendering of the report. > System.ArgumentOutOfRangeException: Non-negative number required.
Parameter name: value
at System.IO.MemoryStream.set_Position(Int64 value)
at Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasPDF.MonochromeJpeg(MemoryStream memStream)
at Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasPDF.ProcessImage(CanvasImagePDF image, Double left, Double top, Double width, Double height, Boolean scaleImage)
at Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasPDF.DrawImage(OutlineObjects outlines, CanvasImage image, Double left, Double top, Double width, Double height)
at Microsoft.ReportingServices.Rendering.ImageRenderer.Image.RenderToPage(Measurement parentClipBorder)
at Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement parentClipBorder)
at Microsoft.ReportingServices.Rendering.ImageRenderer.Table.TableCell.RenderToPage(Measurement parentClipBorder)
at Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement parentClipBorder)
at Microsoft.ReportingServices.Rendering.ImageRenderer.Table.TableRow.RenderToPage(Measurement parentClipBorder)
at Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement parentClipBorder)
at Microsoft.ReportingServices.Rendering.ImageRenderer.Table.RenderToPage(Measurement parentClipBorder)
at Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement parentClipBorder)
at Microsoft.ReportingServices.Rendering.ImageRenderer.Rectangle.RenderToPage(Measurement parentClipBorder)
at Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement parentClipBorder)
at Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.ProcessPages(CompositionBase theComposition, Report theReport, Boolean needTotalPages, Int32 startPage, Int32 endPage, Boolean render)
at Microsoft.ReportingServices.Rendering.ImageRenderer.PdfReport.RenderReport(Report report, NameValueCollection deviceInfo, EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions, CreateAndRegisterStream createAndRegisterStreamCallback, Int32 streamPageNumber)
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.RenderSnapshot(IRenderingExtension renderer, CreateReportChunk createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
End of inner exception stack trace
aspnet_wp!library!5!17/04/2007-10:28:23:: Unhandled exception was caught: Microsoft.Reporting.WebForms.ReportServerException: An error occurred during rendering of the report. (rrRenderingError) > Microsoft.Reporting.WebForms.ReportServerException: An error occurred during rendering of the report. > Microsoft.Reporting.WebForms.ReportServerException: Non-negative number required.
Parameter name: value
End of inner exception stack trace
End of inner exception stack trace

Hi

We have got same problem and I have found that it happens with reports containing *.pjpeg images. Not all *.pjpeg gives this problem.

Please reply if anyone knows the fix. it is urgent

Thanks

Satjinder

Monday, March 26, 2012

PDF Exporting problem

I am using report viewer and exporting my report to pdf format.The report is displaying very odd there.Can anyone help me to adjust the original format there.

What do you mean by odd?

Not to hijack your post, but maybe you are having the same problem as I am.


My report has three columns of yearly sales (in dollars), when I export the report the columns will shift to the left if any of the columns are blank.

|||

try putting the information in a rectangle so that they can stay together if any part of ur data is missing.

|||

FYI, I fixed my problem, by taking the Yearly columns out of a filtered List and just filtered the textbox with an "If.. Then.." and made it return $0.00 instead of a blank.

|||

If you're report width is too wide then while exporting to pdf it wraps the content exceeding the standard width (8.5") and pushes it to the next page. If you apply colors to the various ctrls on your report including its body you can debug where exactly it spills over.

Remember while exporting to pdf or printing, the interactive height of the report should be 8.5" x 11" . Your report's body width should also be 8.5" however the height can be as long as you want it.

............................................................................

Remember to mark as "Answer" on the post that helped you

http://technoblab.blogspot.com

|||Hi,My problem is same as your problem.I think this is the report problem itself.I had a table and it has 5 columns,when i export data from my repot viewer to pdf so the column shifted to next pages.and 2 column is display in one page and next is shifted in next page.Using rectangle is another way.Can i use third party control.|||

you should be able to fix any problem with the normal report controls etc. Please describe your problem a bit more thoroughly. THanks!

PDF export results in extra pages.

I am experiencing some quirks when exporting to PDF.
I have read all the other posts about page sizes, margins, etc and my situation seems to be a bit different.

PageWidth = 21cm
PageHeight = 29.7cm
Margins = 1cm

Body.Width = 19cm

I have a report that contains a bar chart (Height = 15cm, Width = 19cm) and below that a rectangle that contains two text boxes with totals information (Left = 11.6cm, Width = 7.4cm, Height 0.5cm)

Now most of the time it exports to PDF perfectly - all on one page as would be expected

If however the chart has more than say 20 items on the y-axis then the rectangle gets pushed onto an new page.

For extra information, but not to confuse the issue I also have a page header and footer that have items lined up right to the edge (left + width = 19cm) and they all display fine on the one page. It is just this rectangle that is having the problem.

When I move the rectangle to the left a bit (11.4cm) so 0.2cm away from the right hand edge then it works fine.

It is just very strange because I cant see how it is getting shifted only when the chart contains a lot of items.

Any ideas?

I finally found a solution that works for me, just after I posted - usually the way.

I have created a rectangle with left = 0cm and width = 19cm and then placed the text boxes
inside that rectangle, positioned where I need them.

Once I do that it renders onto one page.

What I think is going on here is a precision problem. I suspect that MS being a US based company their base units are the imperial system so Inches. So even though you can express your measurements in cm, pt's, etc - they are always converted to a base unit of inches. With any conversion process you can get problems with precision and that is what I think is happening here.

So I feel the best way to avoid these precision bugs is to adopt a report design strategy of not having floating report items in your report. Group items by placing them in a rectangle and set the left to 0 and the width to the exact page width boundary (in this case 19cm)

The other solution is to always use the same base units as the renderer (inches) that way you wont suffer conversion precision problems. Unfortunately for me it would take forever to convert all mine from cm to inches.

PDF Export Prompts for Authentication

I am having a weird problem with just one report in production. When
exporting to PDF format only, the browser prompts for user authentication.
No matter what you type in the window (even admin for server) it just keeps
popping up. When you click cancel you see the following error.
HTTP Error 401.1 - Unauthorized: Access is denied due to invalid credentials.
Internet Information Services (IIS)
The log file shows the following
w3wp!chunks!2dd8!04/01/2005-10:08:15:: i INFO: ###
GetReportChunk('RenderingInfo_PDF', Other), chunk was not found!
this=ea4cb70a-7dac-4390-bac8-140c7d6f67d5
w3wp!reportrendering!2dd8!04/01/2005-10:08:15:: 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.StackOverflowException: Exception of type
System.StackOverflowException was thrown.
-- 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.RenderSnapshot(CreateReportChunk
createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
-- End of inner exception stack trace --
w3wp!webserver!2dd8!04/01/2005-10:08:18:: 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.StackOverflowException: Exception of type
System.StackOverflowException was thrown.
w3wp!webserver!3234!04/01/2005-10:08:18:: e ERROR: Reporting Services error
Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error has
occurred during report processing. -->
Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An
error has occurred during report processing. -->
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query
execution failed for data set 'dsChangesInLargeLoss'. -->
System.Data.SqlClient.SqlException: The conversion of a char data type to a
datetime data type resulted in an out-of-range datetime value.
w3wp!library!2dd8!04/01/2005-10:08:19:: e ERROR: Found
System.StackOverflowException exception:
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.StackOverflowException: Exception of type
System.StackOverflowException was thrown.
w3wp!library!2dd8!04/01/2005-10:08:19:: e ERROR: Terminating worker process
Other reports in production export to PDF without a problem, just this one
report is causing issues.
Any idea what might be causing this issue? The report exports to PDF fine
in development for this report. Has anyone else seen this issue before?Does this report render correctly in other formats like HTML? Can you help
me understand this error:
Query execution failed for data set 'dsChangesInLargeLoss'. -->
System.Data.SqlClient.SqlException: The conversion of a char data type to a
datetime data type resulted in an out-of-range datetime value.
If it isn't an obvious place in your report that's doing this and leading to
us blowing up, can you email me a copy of your .rdl and .rdl.data file so I
can investigate?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"spindlej" <spindlej@.discussions.microsoft.com> wrote in message
news:87D82688-AEB0-4721-A115-8D160537514B@.microsoft.com...
>I am having a weird problem with just one report in production. When
> exporting to PDF format only, the browser prompts for user authentication.
> No matter what you type in the window (even admin for server) it just
> keeps
> popping up. When you click cancel you see the following error.
> HTTP Error 401.1 - Unauthorized: Access is denied due to invalid
> credentials.
> Internet Information Services (IIS)
> The log file shows the following
>
> w3wp!chunks!2dd8!04/01/2005-10:08:15:: i INFO: ###
> GetReportChunk('RenderingInfo_PDF', Other), chunk was not found!
> this=ea4cb70a-7dac-4390-bac8-140c7d6f67d5
> w3wp!reportrendering!2dd8!04/01/2005-10:08:15:: 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.StackOverflowException: Exception of type
> System.StackOverflowException was thrown.
> -- 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.RenderSnapshot(CreateReportChunk
> createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
> -- End of inner exception stack trace --
> w3wp!webserver!2dd8!04/01/2005-10:08:18:: 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.StackOverflowException: Exception of type
> System.StackOverflowException was thrown.
> w3wp!webserver!3234!04/01/2005-10:08:18:: e ERROR: Reporting Services
> error
> Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error
> has
> occurred during report processing. -->
> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException:
> An
> error has occurred during report processing. -->
> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException:
> Query
> execution failed for data set 'dsChangesInLargeLoss'. -->
> System.Data.SqlClient.SqlException: The conversion of a char data type to
> a
> datetime data type resulted in an out-of-range datetime value.
> w3wp!library!2dd8!04/01/2005-10:08:19:: e ERROR: Found
> System.StackOverflowException exception:
> 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.StackOverflowException: Exception of type
> System.StackOverflowException was thrown.
> w3wp!library!2dd8!04/01/2005-10:08:19:: e ERROR: Terminating worker
> process
> Other reports in production export to PDF without a problem, just this one
> report is causing issues.
> Any idea what might be causing this issue? The report exports to PDF fine
> in development for this report. Has anyone else seen this issue before?
>|||It would be really creepy if this renders in HTML but not in PDF (makes no
sense)
I am looking forward getting the rdl ;-)
Jens Süßmeyer.
"Donovan Smith [MSFT]" <donovans@.online.microsoft.com> schrieb im
Newsbeitrag news:emN7AkRQFHA.3140@.tk2msftngp13.phx.gbl...
> Does this report render correctly in other formats like HTML? Can you
> help me understand this error:
> Query execution failed for data set 'dsChangesInLargeLoss'. -->
> System.Data.SqlClient.SqlException: The conversion of a char data type to
> a
> datetime data type resulted in an out-of-range datetime value.
> If it isn't an obvious place in your report that's doing this and leading
> to us blowing up, can you email me a copy of your .rdl and .rdl.data file
> so I can investigate?
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "spindlej" <spindlej@.discussions.microsoft.com> wrote in message
> news:87D82688-AEB0-4721-A115-8D160537514B@.microsoft.com...
>>I am having a weird problem with just one report in production. When
>> exporting to PDF format only, the browser prompts for user
>> authentication.
>> No matter what you type in the window (even admin for server) it just
>> keeps
>> popping up. When you click cancel you see the following error.
>> HTTP Error 401.1 - Unauthorized: Access is denied due to invalid
>> credentials.
>> Internet Information Services (IIS)
>> The log file shows the following
>>
>> w3wp!chunks!2dd8!04/01/2005-10:08:15:: i INFO: ###
>> GetReportChunk('RenderingInfo_PDF', Other), chunk was not found!
>> this=ea4cb70a-7dac-4390-bac8-140c7d6f67d5
>> w3wp!reportrendering!2dd8!04/01/2005-10:08:15:: 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.StackOverflowException: Exception of type
>> System.StackOverflowException was thrown.
>> -- 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.RenderSnapshot(CreateReportChunk
>> createChunkCallback, RenderingContext rc, GetResource
>> getResourceCallback)
>> -- End of inner exception stack trace --
>> w3wp!webserver!2dd8!04/01/2005-10:08:18:: 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.StackOverflowException: Exception of type
>> System.StackOverflowException was thrown.
>> w3wp!webserver!3234!04/01/2005-10:08:18:: e ERROR: Reporting Services
>> error
>> Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error
>> has
>> occurred during report processing. -->
>> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException:
>> An
>> error has occurred during report processing. -->
>> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException:
>> Query
>> execution failed for data set 'dsChangesInLargeLoss'. -->
>> System.Data.SqlClient.SqlException: The conversion of a char data type to
>> a
>> datetime data type resulted in an out-of-range datetime value.
>> w3wp!library!2dd8!04/01/2005-10:08:19:: e ERROR: Found
>> System.StackOverflowException exception:
>> 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.StackOverflowException: Exception of type
>> System.StackOverflowException was thrown.
>> w3wp!library!2dd8!04/01/2005-10:08:19:: e ERROR: Terminating worker
>> process
>> Other reports in production export to PDF without a problem, just this
>> one
>> report is causing issues.
>> Any idea what might be causing this issue? The report exports to PDF
>> fine
>> in development for this report. Has anyone else seen this issue before?
>|||We tested the report on another server and duplicated the problem. Once we
upgraded to SP1, the problem went away.
"Donovan Smith [MSFT]" wrote:
> Does this report render correctly in other formats like HTML? Can you help
> me understand this error:
> Query execution failed for data set 'dsChangesInLargeLoss'. -->
> System.Data.SqlClient.SqlException: The conversion of a char data type to a
> datetime data type resulted in an out-of-range datetime value.
> If it isn't an obvious place in your report that's doing this and leading to
> us blowing up, can you email me a copy of your .rdl and .rdl.data file so I
> can investigate?
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "spindlej" <spindlej@.discussions.microsoft.com> wrote in message
> news:87D82688-AEB0-4721-A115-8D160537514B@.microsoft.com...
> >I am having a weird problem with just one report in production. When
> > exporting to PDF format only, the browser prompts for user authentication.
> > No matter what you type in the window (even admin for server) it just
> > keeps
> > popping up. When you click cancel you see the following error.
> >
> > HTTP Error 401.1 - Unauthorized: Access is denied due to invalid
> > credentials.
> > Internet Information Services (IIS)
> >
> > The log file shows the following
> >
> >
> > w3wp!chunks!2dd8!04/01/2005-10:08:15:: i INFO: ###
> > GetReportChunk('RenderingInfo_PDF', Other), chunk was not found!
> > this=ea4cb70a-7dac-4390-bac8-140c7d6f67d5
> > w3wp!reportrendering!2dd8!04/01/2005-10:08:15:: 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.StackOverflowException: Exception of type
> > System.StackOverflowException was thrown.
> > -- 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.RenderSnapshot(CreateReportChunk
> > createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
> > -- End of inner exception stack trace --
> > w3wp!webserver!2dd8!04/01/2005-10:08:18:: 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.StackOverflowException: Exception of type
> > System.StackOverflowException was thrown.
> > w3wp!webserver!3234!04/01/2005-10:08:18:: e ERROR: Reporting Services
> > error
> > Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error
> > has
> > occurred during report processing. -->
> > Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException:
> > An
> > error has occurred during report processing. -->
> > Microsoft.ReportingServices.ReportProcessing.ReportProcessingException:
> > Query
> > execution failed for data set 'dsChangesInLargeLoss'. -->
> > System.Data.SqlClient.SqlException: The conversion of a char data type to
> > a
> > datetime data type resulted in an out-of-range datetime value.
> > w3wp!library!2dd8!04/01/2005-10:08:19:: e ERROR: Found
> > System.StackOverflowException exception:
> > 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.StackOverflowException: Exception of type
> > System.StackOverflowException was thrown.
> > w3wp!library!2dd8!04/01/2005-10:08:19:: e ERROR: Terminating worker
> > process
> >
> > Other reports in production export to PDF without a problem, just this one
> > report is causing issues.
> >
> > Any idea what might be causing this issue? The report exports to PDF fine
> > in development for this report. Has anyone else seen this issue before?
> >
>
>|||Well, that was an easier answer than I expected. Good to know it's working.
:)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"spindlej" <spindlej@.discussions.microsoft.com> wrote in message
news:6FFDE7FB-5525-469A-AEC4-4189555A94E8@.microsoft.com...
> We tested the report on another server and duplicated the problem. Once
> we
> upgraded to SP1, the problem went away.
> "Donovan Smith [MSFT]" wrote:
>> Does this report render correctly in other formats like HTML? Can you
>> help
>> me understand this error:
>> Query execution failed for data set 'dsChangesInLargeLoss'. -->
>> System.Data.SqlClient.SqlException: The conversion of a char data type to
>> a
>> datetime data type resulted in an out-of-range datetime value.
>> If it isn't an obvious place in your report that's doing this and leading
>> to
>> us blowing up, can you email me a copy of your .rdl and .rdl.data file so
>> I
>> can investigate?
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "spindlej" <spindlej@.discussions.microsoft.com> wrote in message
>> news:87D82688-AEB0-4721-A115-8D160537514B@.microsoft.com...
>> >I am having a weird problem with just one report in production. When
>> > exporting to PDF format only, the browser prompts for user
>> > authentication.
>> > No matter what you type in the window (even admin for server) it just
>> > keeps
>> > popping up. When you click cancel you see the following error.
>> >
>> > HTTP Error 401.1 - Unauthorized: Access is denied due to invalid
>> > credentials.
>> > Internet Information Services (IIS)
>> >
>> > The log file shows the following
>> >
>> >
>> > w3wp!chunks!2dd8!04/01/2005-10:08:15:: i INFO: ###
>> > GetReportChunk('RenderingInfo_PDF', Other), chunk was not found!
>> > this=ea4cb70a-7dac-4390-bac8-140c7d6f67d5
>> > w3wp!reportrendering!2dd8!04/01/2005-10:08:15:: 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.StackOverflowException: Exception of type
>> > System.StackOverflowException was thrown.
>> > -- 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.RenderSnapshot(CreateReportChunk
>> > createChunkCallback, RenderingContext rc, GetResource
>> > getResourceCallback)
>> > -- End of inner exception stack trace --
>> > w3wp!webserver!2dd8!04/01/2005-10:08:18:: 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.StackOverflowException: Exception of type
>> > System.StackOverflowException was thrown.
>> > w3wp!webserver!3234!04/01/2005-10:08:18:: e ERROR: Reporting Services
>> > error
>> > Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error
>> > has
>> > occurred during report processing. -->
>> > Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException:
>> > An
>> > error has occurred during report processing. -->
>> > Microsoft.ReportingServices.ReportProcessing.ReportProcessingException:
>> > Query
>> > execution failed for data set 'dsChangesInLargeLoss'. -->
>> > System.Data.SqlClient.SqlException: The conversion of a char data type
>> > to
>> > a
>> > datetime data type resulted in an out-of-range datetime value.
>> > w3wp!library!2dd8!04/01/2005-10:08:19:: e ERROR: Found
>> > System.StackOverflowException exception:
>> > 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.StackOverflowException: Exception of type
>> > System.StackOverflowException was thrown.
>> > w3wp!library!2dd8!04/01/2005-10:08:19:: e ERROR: Terminating worker
>> > process
>> >
>> > Other reports in production export to PDF without a problem, just this
>> > one
>> > report is causing issues.
>> >
>> > Any idea what might be causing this issue? The report exports to PDF
>> > fine
>> > in development for this report. Has anyone else seen this issue
>> > before?
>> >
>>

PDF Export Failing after SP1

Am also having a problem exporting to PDF since installing SP1. Error is
"Cannot download format=PDF from <server>"
"Internet Explorer was not able to open this Internet Site. The requested
site is either unavailable or cannot be found. Please try again later".
Micktry to export same report to PDF in visual studio designer
you will recive different error
this error is explained in two of todays posts
HTH,
Kamil
U¿ytkownik "Mick Horne" <mick.horne@.conchango.com> napisa³ w wiadomo¶ci
news:%23bePBQeXEHA.1656@.TK2MSFTNGP09.phx.gbl...
> Am also having a problem exporting to PDF since installing SP1. Error is
> "Cannot download format=PDF from <server>"
> "Internet Explorer was not able to open this Internet Site. The requested
> site is either unavailable or cannot be found. Please try again later".
> Mick
>
>|||> try to export same report to PDF in visual studio designer
> you will recive different error
> this error is explained in two of todays posts
As posted before I've got the same problem. And yes, you are right, in the
designer I receive a different error. Unfortunately I can not find the posts
where a solution for this is stated. Can you please explain to me how to fix
it?
Thanks.
Christian|||Workaround solution with following post:
"SP1 - Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown" by Rahul
U¿ytkownik "Christian Anders" <anders.christian@.firemail.de> napisa³ w
wiadomo¶ci news:ewNfcgeXEHA.2388@.TK2MSFTNGP11.phx.gbl...
> > try to export same report to PDF in visual studio designer
> > you will recive different error
> > this error is explained in two of todays posts
> As posted before I've got the same problem. And yes, you are right, in the
> designer I receive a different error. Unfortunately I can not find the
posts
> where a solution for this is stated. Can you please explain to me how to
fix
> it?
> Thanks.
> Christian
>sql

PDF Export error in reporting services 2000

Hi,

I am exporting my report in PDF format and i am getting following error:-

Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. (rrRenderingError) Get Online Help

Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown.

Font 'Arial' doesn't support style 'Regular'.

I am using sql server2000 reporting services....

can anyone help !

thanks

amit_800 wrote:

Hi,

I am exporting my report in PDF format and i am getting following error:-

Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. (rrRenderingError) Get Online Help

Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown.

Font 'Arial' doesn't support style 'Regular'.

I am using sql server2000 reporting services....

can anyone help !

thanks

|||

I have seen this only once before and reinstalling the Arial font fixed this issue. The error message you see comes from the Windows GDI library. To reinstall Arial, do the following. Note that these instructions are for Windows XP or Windows Server 2003 only.

1. In Windows Explorer, navigate to C:\Windows\Fonts

2. Right-click the Arial (TrueType) font and select delete

3. Reboot

4. Expand Arial.tt_ from the i386 or AMD64 directory on your Windows CD to a directory on your hard drive. To expand, you can use the expand.exe file in the i386/amd64 directory or an application like 7-Zip.

5. In Windows Explorer, navigate to C:\Windows\Fonts

6. From the File menu, choose Install New Font and then select the Arial.TTF file you expanded.

7. Reboot

Thanks.

PDF Export error in reporting services 2000

Hi,

I am exporting my report in PDF format and i am getting following error:-

Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. (rrRenderingError) Get Online Help

Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown.

Font 'Arial' doesn't support style 'Regular'.

I am using sql server2000 reporting services....

can anyone help !

thanks

amit_800 wrote:

Hi,

I am exporting my report in PDF format and i am getting following error:-

Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. (rrRenderingError) Get Online Help

Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown.

Font 'Arial' doesn't support style 'Regular'.

I am using sql server2000 reporting services....

can anyone help !

thanks

|||

I have seen this only once before and reinstalling the Arial font fixed this issue. The error message you see comes from the Windows GDI library. To reinstall Arial, do the following. Note that these instructions are for Windows XP or Windows Server 2003 only.

1. In Windows Explorer, navigate to C:\Windows\Fonts

2. Right-click the Arial (TrueType) font and select delete

3. Reboot

4. Expand Arial.tt_ from the i386 or AMD64 directory on your Windows CD to a directory on your hard drive. To expand, you can use the expand.exe file in the i386/amd64 directory or an application like 7-Zip.

5. In Windows Explorer, navigate to C:\Windows\Fonts

6. From the File menu, choose Install New Font and then select the Arial.TTF file you expanded.

7. Reboot

Thanks.

PDF export buggy?

Hi,
I have a LocalReport, when I'm exporting to a PDF using the following
code:
Warning[] warnings;
string mimeType;
string encoding;
string fileNameExtension;
string[] streams;
byte[] pdfContent;
string fileName;
FileStream pdfFile;
fileName = Path.GetTempPath();
fileName = Path.Combine( fileName, Report.DisplayName +
".pdf" );
pdfContent = report.Render( "PDF", null, out mimeType, out
encoding,
out fileNameExtension, out streams, out warnings );
using ( pdfFile = new FileStream( fileName,
FileMode.Create ) ) {
pdfFile.Write( pdfContent, 0, pdfContent.Length );
}
This works, except that some people that recieve the PDF cannot print
it properly. Our graphics guru was able to reproduce the problem and
said it seemed that those that didn't have postscript drivers wouldn't
be able to print the PDF. PCL drivers print the PDF fine.
Any idea what I can do to correct this? Is this a known issue?
Thanks
AndyI've been able to verify this.
Using the PCL drivers for a laser printer we have here, the PDF prints
fine. Uninstalling the print drivers and installing the PS printer
drivers, and we get one page with a few portions of text, followed by
a second page with this text:
ERROR: unmatchedmark
OFFENDING COMMAND: ]
STACK:
8
Any ideas?|||I've narrowed it down a bit more. I have an embedded PNG in the rdlc
file; if I remove the Image control which displays the png from the
report, it prints fine.|||On Aug 30, 11:51 am, Andy <an...@.med-associates.com> wrote:
> I've narrowed it down a bit more. I have an embedded PNG in the rdlc
> file; if I remove the Image control which displays the png from the
> report, it prints fine.
So I don't know if the particular PNG I was using was corrupt, or if
LocalReport.Render simply can't handle PNGs, but changing the PNG to a
JPG and using the JPG has fixed the issue, in case anyone else has
this problem.

PDF Export and extra pages

I'm having a problem exporting a report to PDF. In the viewer, the report looks great. When I export to PDF, all the group totals end up on a separate page. This inflates the pages by a great deal for a good size report.
I'm using SQL Server 2005 beta2 but I have also read about this problem in 2000 SP2. Does anyone have a solution to this? I'm going crazy trying to figure out the answer!!! Sad
Thanks fir any replies,
Bill
The report width is too large.
Click on the main area of the report and observe the size in the properties.
Now click on the gray area outside the report and look at the PageSize and the Margins properties.
The width of the report itself must be less than or equal to the width in the PageSize property minus the sum of the left and right margins.|||Have you read the following blog article:
http://blogs.msdn.com/bwelcker/archive/2005/08/19/454043.aspx

It explains some of the "magic" related to page breaks and logical vs. physical page rendering.

-- Robertsql

PDF EXPORT

Dear All

I use sql server reporting services..in visual studio 2005..

when exporting report to pdf in the report viewer alignment varies..

single table report split up in to two pages not in proper manner..

how to tackle this export to pdf event in report viewer..

did anyone can help me in this.

Regards

Senthil

You need to do adjust the table correctly. just decrease the width of the table and other objects.

if width of the objects does not fit in a page than it will be divided into two pages in pdf. so try to adjust the width of the objects.

|||

I had the same problem and this is what I found. If the report is defined as an 11 x 8.5 (landscape) report with .5 margins (defined in report properties) all around your report data cannot exceed 10".

10" + .5 left margin + .5 right margin = 11.

If you exceed this the page will split.

|||

Thnx jhaberer

its working fine!...

sql

Friday, March 23, 2012

PDF bookmarks

Hi all,
I need help. I want to have bookmarks in my report after exporting to pdf format. How to do this?
Using: CR 11 R2, JRC for exporting
Thanks for replyOK found something...

class: com.crystaldecisions.sdk.occa.report.exportoptions.PDFExport FormatOptions

code:
PDFExportFormatOptions pdfOptions = new PDFExportFormatOptions();
pdfOptions.setCreateBookmarksFromGroupTree(true);
ExportOptions exportOptions = new ExportOptions();
exportOptions.setExportFormatType(ReportExportFormat.PDF );
exportOptions.setFormatOptions(pdfOptions);

But after invoking printOutputController.export(exportOptions) the report is without bookmarks. Pdf built via Crystal reports HAS bookmarks.

Can anybody tell me what am I doing wrong?

Peter

PDF and Excel Issues

I have two issues when exporting a report to Excel or pdf.
1. When exporting to pdf, the underline font attribute is lost. Is
this a version issue or is there something I can do to circumvent this
(other than place a border on the text box which will look bad)?
2. When exporting to pdf and Excel, I am getting a lot of white space
at the start of the report (in pdf) or between list items (in excel).
The pdf white space is almost an entire page.
I am using Reporting Services SP1.I am not seeing the first issue. I can successfully export textboxes with
underline set.
On the second one, do you have CanGrow on textboxes with extra content in
them (spaces, returns)?
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Lara" <wwilliam@.umn.edu> wrote in message
news:ca6a3f4a.0406281323.62a2e87c@.posting.google.com...
>I have two issues when exporting a report to Excel or pdf.
> 1. When exporting to pdf, the underline font attribute is lost. Is
> this a version issue or is there something I can do to circumvent this
> (other than place a border on the text box which will look bad)?
> 2. When exporting to pdf and Excel, I am getting a lot of white space
> at the start of the report (in pdf) or between list items (in excel).
> The pdf white space is almost an entire page.
> I am using Reporting Services SP1.|||Perhaps the first issue is a font issue on the client? I am going to
research this tomorrow. The underline was not in a text box, rather
in a table group header.
I do have some text boxes with cangrow, but they are pretty limited in
size. When I looked at the PDF, it was not really empty space, rather
it was not writing some of the report items. I have a table in a list
box for employee data. The report required a parameter which would
then render the report for that company. Some of the employee tables
were not writing to PDF - it would skip the first 6-7 employees and
pick up from there. I was actually able to address this with
rewriting some of the report. The list was grouping on a number of
items, some of which could be null. I addressed the null in the
stored procedure so that it was replaced with an actual value, and
that seemed to work. Those nasty nulls can sneak up on you! It
should be noted that this was consistant for specific parameters which
caused larger reports. The small one to two page reports didn't seem
to have an issue, with or without nulls.
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message news:<e1sO#FaXEHA.1128@.TK2MSFTNGP10.phx.gbl>...
> I am not seeing the first issue. I can successfully export textboxes with
> underline set.
> On the second one, do you have CanGrow on textboxes with extra content in
> them (spaces, returns)?
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Lara" <wwilliam@.umn.edu> wrote in message
> news:ca6a3f4a.0406281323.62a2e87c@.posting.google.com...
> >I have two issues when exporting a report to Excel or pdf.
> >
> > 1. When exporting to pdf, the underline font attribute is lost. Is
> > this a version issue or is there something I can do to circumvent this
> > (other than place a border on the text box which will look bad)?
> >
> > 2. When exporting to pdf and Excel, I am getting a lot of white space
> > at the start of the report (in pdf) or between list items (in excel).
> > The pdf white space is almost an entire page.
> >
> > I am using Reporting Services SP1.|||OK, I misspoke when I related my solution to the missing data. I had
been trying a couple of things, and the null grouping wasn't the
solution. Actually, here is the skinny.
I have a table of employee data. I had a list which grouped the
employee id inside a group for location which was inside a group for
company. All of these list groups were necessary to provide the
different pieces of information to the user. A text box with the
employee name was placed in the employee list group and also a table
provided the detail employee information necessary. When this is
rendered to the Report Manager, all is visible as expected. When I
render to PDF, the first several employees are missing with the larger
reports.
To work around this issue, I instead placed a table header with the
employee name on the table and removed the Employee id list. This
table was then placed in the location group. All data is now
rendered as expected in PDF. This is not as the users hoped, as the
text box allowed me to move the employee name where they wanted on the
report and I am a bit more limited with the table grouping.
If you would like any further information, please feel free to contact
me at lara(dot)rubbelke(at)born(dot)com.
Thanks!
wwilliam@.umn.edu (Lara) wrote in message news:<ca6a3f4a.0406291706.5162366a@.posting.google.com>...
> Perhaps the first issue is a font issue on the client? I am going to
> research this tomorrow. The underline was not in a text box, rather
> in a table group header.
> I do have some text boxes with cangrow, but they are pretty limited in
> size. When I looked at the PDF, it was not really empty space, rather
> it was not writing some of the report items. I have a table in a list
> box for employee data. The report required a parameter which would
> then render the report for that company. Some of the employee tables
> were not writing to PDF - it would skip the first 6-7 employees and
> pick up from there. I was actually able to address this with
> rewriting some of the report. The list was grouping on a number of
> items, some of which could be null. I addressed the null in the
> stored procedure so that it was replaced with an actual value, and
> that seemed to work. Those nasty nulls can sneak up on you! It
> should be noted that this was consistant for specific parameters which
> caused larger reports. The small one to two page reports didn't seem
> to have an issue, with or without nulls.
> "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message news:<e1sO#FaXEHA.1128@.TK2MSFTNGP10.phx.gbl>...
> > I am not seeing the first issue. I can successfully export textboxes with
> > underline set.
> >
> > On the second one, do you have CanGrow on textboxes with extra content in
> > them (spaces, returns)?
> >
> > --
> > Brian Welcker
> > Group Program Manager
> > SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> > "Lara" <wwilliam@.umn.edu> wrote in message
> > news:ca6a3f4a.0406281323.62a2e87c@.posting.google.com...
> > >I have two issues when exporting a report to Excel or pdf.
> > >
> > > 1. When exporting to pdf, the underline font attribute is lost. Is
> > > this a version issue or is there something I can do to circumvent this
> > > (other than place a border on the text box which will look bad)?
> > >
> > > 2. When exporting to pdf and Excel, I am getting a lot of white space
> > > at the start of the report (in pdf) or between list items (in excel).
> > > The pdf white space is almost an entire page.
> > >
> > > I am using Reporting Services SP1.