Passing result sets: format

Showing posts with label format. Show all posts

Friday, March 30, 2012

PDF-Export Format not readable for non-windows users

Hi NG,
i received the following mail today:
<snipp>
May be the reason is that I didn't read
this file with the Acroreader version 7.0 which is the latest available
for Windows. Please take into account that not everybody lives in a
Microsoft world: The latest available Acroreader under Linux is version
5! So I kindly request a readable version of my personal pdf-statement
P.S.: A closer analysis of the pdf file shows this error message:
**** This file has a corrupted %%EOF marker, or garbage after the %%EOF.
**** The file was produced by Microsoft Rptg Srvcs PDF Rendering
Extension 8. 0:
**** please notify the author of this software
**** that the file does not conform to Adobe's published PDF
</snipp>
My question:
Does the hotfix from
http://support.microsoft.com/kb/885444/en-us
fix my problems?
I got the beta SP2 already here, but the production environment is german so
i couldn't install the sp2 there.
Brian?
regards
FrankDear "Frank",
are you running SP1 now?
dlr
"Frank Matthiesen" <fm@.xax.de> wrote in message
news:3bcph6F6ggsklU1@.individual.net...
> Hi NG,
> i received the following mail today:
> <snipp>
> May be the reason is that I didn't read
> this file with the Acroreader version 7.0 which is the latest available
> for Windows. Please take into account that not everybody lives in a
> Microsoft world: The latest available Acroreader under Linux is version
> 5! So I kindly request a readable version of my personal pdf-statement
> P.S.: A closer analysis of the pdf file shows this error message:
> **** This file has a corrupted %%EOF marker, or garbage after the
%%EOF.
> **** The file was produced by Microsoft Rptg Srvcs PDF Rendering
> Extension 8. 0:
> **** please notify the author of this software
> **** that the file does not conform to Adobe's published PDF
> </snipp>
>
> My question:
> Does the hotfix from
> http://support.microsoft.com/kb/885444/en-us
> fix my problems?
> I got the beta SP2 already here, but the production environment is german
so
> i couldn't install the sp2 there.
> Brian?
> regards
> Frank
>
>|||Dennis Redfield wrote:
> are you running SP1 now?
Yes i do.
Franksql

PDF to RDL conversion

I have a project that we need to dynamically output a PDF document.
The format I have it in now is PDF. I want to be able to bring this
PDF into the Visual Studio report designer as a starting point. I will
the drop report parameters on to the report to add the dynamic data.
Is there any way I can convert a PDF document into an RDL file?I haven't heard of an automatic converter that will take a PDF and create an
RED, not sure how it would be able to do that anyway.
--
Floyd
"Paul Hester" <phester@.gmail.com> wrote in message
news:1123797876.993952.76350@.g44g2000cwa.googlegroups.com...
>I have a project that we need to dynamically output a PDF document.
> The format I have it in now is PDF. I want to be able to bring this
> PDF into the Visual Studio report designer as a starting point. I will
> the drop report parameters on to the report to add the dynamic data.
> Is there any way I can convert a PDF document into an RDL file?
>|||Nope, Floyd is correct, there is no way to do this...Start from scratch...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Paul Hester" <phester@.gmail.com> wrote in message
news:1123797876.993952.76350@.g44g2000cwa.googlegroups.com...
>I have a project that we need to dynamically output a PDF document.
> The format I have it in now is PDF. I want to be able to bring this
> PDF into the Visual Studio report designer as a starting point. I will
> the drop report parameters on to the report to add the dynamic data.
> Is there any way I can convert a PDF document into an RDL file?
>

Wednesday, March 28, 2012

PDF rendering: Characters overlap in Verdana

On some of our RS machines the Verdana font doesn't render correctly in PDF
format, there is no spacing between the letters (all at the same location).
Other fonts like Arial render correctly. Is this a known issue? sp1 has been
installed (I know there were some issues with this before service pack 1).
--
Callidus
Software DesignerEnsure Verdana is on the server box as well as the development
computers.
Then, on the server, use the Fonts control panel to open all Verdana
font files. Then reboot the server.
This helped us with similar problem - hope it works for you!|||Thanks for your reply. This doesn't solve our problems however. Any other
suggestions?
Was it the first time you rebooted the server after installings sp1?
"Parker" wrote:
> Ensure Verdana is on the server box as well as the development
> computers.
> Then, on the server, use the Fonts control panel to open all Verdana
> font files. Then reboot the server.
> This helped us with similar problem - hope it works for you!
>|||Yes - the server had been up for a fairly long time, as I recall.
Sounds like your problem may lie elsewhere - other things to try would
be ensuring you are using Acrobat Reader 7, or simply not using the
problematic font (kludgy, I know...)|||We use Arial Narrow and ever since we went to a W2K3 box everything exports
correctly, except for PDF which substitutes Helvetica or something with weird
spacing. Did you ever get it fixed?
"Callidus" wrote:
> Thanks for your reply. This doesn't solve our problems however. Any other
> suggestions?
> Was it the first time you rebooted the server after installings sp1?
> "Parker" wrote:
> > Ensure Verdana is on the server box as well as the development
> > computers.
> >
> > Then, on the server, use the Fonts control panel to open all Verdana
> > font files. Then reboot the server.
> >
> > This helped us with similar problem - hope it works for you!
> >
> >

PDF Rendering from an ASP page

Hi Friends,
How can we render a page in pdf format directly from the Web
Aplication. With out the File Down Load screen.
Thanks
Josethis is a browser issue. You can stream the report (in any format) down to
the browser as
contenttype={what ever you got} and
response.writebinary({your array of bytes})
The browser decides to do the open vs. save dialog depending on its own
settings, I think.
dlr
"Jose Francis" <josefrancis@.gmail.com> wrote in message
news:482833ae.0409170516.1ec28fb2@.posting.google.com...
> Hi Friends,
> How can we render a page in pdf format directly from the Web
> Aplication. With out the File Down Load screen.
> Thanks
> Jose

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

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:

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

PDF Rendering

I am trying to find the best way (as well as sample code) to render a report
(probably in PDf format) to a shared directory when the user clicks on a
button called from a web page. The report should be converted to PDF and
placed in a predefined location without any interaction from the user ,
except the click of course. Any ideas, sites, sample code?here is some sample code (using VS.net 2005 against RS 2000)
to make the web reference, right click on 'references' and 'add web reference'
then enter
http://<servername>/reportserver/reportservice.asmx
and name/rename it 'reportservice' to match with my sample
this is just in a win32 vb.net form with a button to run the code
Private Sub ReportGen(ByVal OutputFormat As String, ByVal ReportLocation As
String, ByVal startdt As String, ByVal enddt As String, ByVal CustRepGp As
Integer, ByVal CustName As String)
Dim rs As New ReportService.ReportingService()
rs.Credentials = System.Net.CredentialCache.DefaultCredentials
' Render arguments
Dim result As Byte() = Nothing
Dim reportPath As String = ReportLocation
Dim format As String = OutputFormat
Dim historyID As String = Nothing
Dim devInfo As String ="<DeviceInfo><Toolbar>False</Toolbar></DeviceInfo>"
' Prepare report parameter.
'this report takes 3 parameters - if you don't use any then scrap this bit
'N.B. the parameter names are case sensitive as per what you called them in
the
'report designer (you can also check using report
manger-properties-parameters)
Dim parameters(2) As ReportService.ParameterValue
parameters(0) = New ParameterValue()
parameters(0).Name = "startDate"
parameters(0).Value = startdt.ToString()
parameters(1) = New ParameterValue()
parameters(1).Name = "endDate"
parameters(1).Value = enddt.ToString()
parameters(2) = New ParameterValue()
parameters(2).Name = "OpsCustGroupID"
parameters(2).Value = CustRepGp.ToString()
Dim credentials As DataSourceCredentials() = Nothing
Dim showHideToggle As String = Nothing
Dim encoding As String
Dim mimeType As String
Dim warnings As Warning() = Nothing
Dim reportHistoryParameters As ParameterValue() = Nothing
Dim streamIDs As String() = Nothing
Dim sh As New SessionHeader()
rs.SessionHeaderValue = sh
Try
'this is the important bit, this is calling the RENDER method on the report
web service
result = rs.Render(reportPath, format, historyID, devInfo,
parameters, credentials, showHideToggle, encoding, mimeType,
reportHistoryParameters, warnings, streamIDs)
sh.SessionId = rs.SessionHeaderValue.SessionId
Console.WriteLine("SessionID after call to Render: {0}",
rs.SessionHeaderValue.SessionId)
Console.WriteLine("Execution date and time: {0}",
rs.SessionHeaderValue.ExecutionDateTime)
Console.WriteLine("Is new execution: {0}",
rs.SessionHeaderValue.IsNewExecution)
Catch err As Exception
Console.WriteLine(err.Message)
End Try
' Write the contents of the report to an MHTML file.
Try
'need to change EXCEL to XLS otherwise the app won't recognise it
Dim fileout As String = CustName & "_" & startdt & "_" & enddt &
"." & IIf(OutputFormat = "EXCEL", "XLS", OutputFormat)
Dim stream As FileStream = File.Create("YOUR_FOLDER\" & fileout,
result.Length)
Console.WriteLine("File created: " & fileout)
stream.Write(result, 0, result.Length)
Console.WriteLine("Result written to the file.")
stream.Close()
Catch err As Exception
Console.WriteLine(err.Message)
End Try
End Sub
'in order to call the above code you will need something like
ReportGen("YOUR FORMAT e.g. PDF",
"/folderonReportServer/anotherfolder/REPORTNAME", "MY PARAM 0", "MY PARAM 1",
ANOTHERPARAM, AnotherParamforNamingTheFileOnly)
obviously you can export to other formats
N.B. all non HTML formats come back in a single stream so you can use this
example, can't remember how you do it in HTML but it's pretty similar
"Bon733" wrote:
> I am trying to find the best way (as well as sample code) to render a report
> (probably in PDf format) to a shared directory when the user clicks on a
> button called from a web page. The report should be converted to PDF and
> placed in a predefined location without any interaction from the user ,
> except the click of course. Any ideas, sites, sample code?|||Hey Adolf,
I am quite new to this kind of thing, but this is exactly what I'm trying
to do (autorender to pdf). I am having a couple of difficulties however
trying to understand it all. I have a couple basic questions (I think).
I've created a simple 1 form vb.net application with a button that says
"Create PDF".
For simplicity I've hard coded my 1 parameter (the Invoice Number "Id")
I've modified your code to the point where VB has no errors but Im missing
some values for variables.
1. ReportLocation: How do I determine this? Is this a network location
where the .rdl exists, or is this the ReportServer URL that I see if I access
the report through ReportManager, or is it something else...? Also, should
this include .rdl extension
2. Where does the PDF get created? I'm not sure I understand where the
output goes, as I'm not providing it with a "dump" location
Any help you can give me is greatly appreciated ...
Michael C
"adolf garlic" wrote:
> here is some sample code (using VS.net 2005 against RS 2000)
> to make the web reference, right click on 'references' and 'add web reference'
> then enter
> http://<servername>/reportserver/reportservice.asmx
> and name/rename it 'reportservice' to match with my sample
> this is just in a win32 vb.net form with a button to run the code
> Private Sub ReportGen(ByVal OutputFormat As String, ByVal ReportLocation As
> String, ByVal startdt As String, ByVal enddt As String, ByVal CustRepGp As
> Integer, ByVal CustName As String)
> Dim rs As New ReportService.ReportingService()
> rs.Credentials = System.Net.CredentialCache.DefaultCredentials
> ' Render arguments
> Dim result As Byte() = Nothing
> Dim reportPath As String = ReportLocation
> Dim format As String = OutputFormat
> Dim historyID As String = Nothing
> Dim devInfo As String => "<DeviceInfo><Toolbar>False</Toolbar></DeviceInfo>"
> ' Prepare report parameter.
> 'this report takes 3 parameters - if you don't use any then scrap this bit
> 'N.B. the parameter names are case sensitive as per what you called them in
> the
> 'report designer (you can also check using report
> manger-properties-parameters)
> Dim parameters(2) As ReportService.ParameterValue
> parameters(0) = New ParameterValue()
> parameters(0).Name = "startDate"
> parameters(0).Value = startdt.ToString()
> parameters(1) = New ParameterValue()
> parameters(1).Name = "endDate"
> parameters(1).Value = enddt.ToString()
> parameters(2) = New ParameterValue()
> parameters(2).Name = "OpsCustGroupID"
> parameters(2).Value = CustRepGp.ToString()
> Dim credentials As DataSourceCredentials() = Nothing
> Dim showHideToggle As String = Nothing
> Dim encoding As String
> Dim mimeType As String
> Dim warnings As Warning() = Nothing
> Dim reportHistoryParameters As ParameterValue() = Nothing
> Dim streamIDs As String() = Nothing
> Dim sh As New SessionHeader()
> rs.SessionHeaderValue = sh
> Try
> 'this is the important bit, this is calling the RENDER method on the report
> web service
> result = rs.Render(reportPath, format, historyID, devInfo,
> parameters, credentials, showHideToggle, encoding, mimeType,
> reportHistoryParameters, warnings, streamIDs)
> sh.SessionId = rs.SessionHeaderValue.SessionId
> Console.WriteLine("SessionID after call to Render: {0}",
> rs.SessionHeaderValue.SessionId)
> Console.WriteLine("Execution date and time: {0}",
> rs.SessionHeaderValue.ExecutionDateTime)
> Console.WriteLine("Is new execution: {0}",
> rs.SessionHeaderValue.IsNewExecution)
> Catch err As Exception
> Console.WriteLine(err.Message)
> End Try
> ' Write the contents of the report to an MHTML file.
> Try
> 'need to change EXCEL to XLS otherwise the app won't recognise it
> Dim fileout As String = CustName & "_" & startdt & "_" & enddt &
> "." & IIf(OutputFormat = "EXCEL", "XLS", OutputFormat)
> Dim stream As FileStream = File.Create("YOUR_FOLDER\" & fileout,
> result.Length)
> Console.WriteLine("File created: " & fileout)
> stream.Write(result, 0, result.Length)
> Console.WriteLine("Result written to the file.")
> stream.Close()
> Catch err As Exception
> Console.WriteLine(err.Message)
> End Try
> End Sub
> 'in order to call the above code you will need something like
> ReportGen("YOUR FORMAT e.g. PDF",
> "/folderonReportServer/anotherfolder/REPORTNAME", "MY PARAM 0", "MY PARAM 1",
> ANOTHERPARAM, AnotherParamforNamingTheFileOnly)
>
> obviously you can export to other formats
> N.B. all non HTML formats come back in a single stream so you can use this
> example, can't remember how you do it in HTML but it's pretty similar
>
> "Bon733" wrote:
> > I am trying to find the best way (as well as sample code) to render a report
> > (probably in PDf format) to a shared directory when the user clicks on a
> > button called from a web page. The report should be converted to PDF and
> > placed in a predefined location without any interaction from the user ,
> > except the click of course. Any ideas, sites, sample code?sql

PDF Properties

We know that RS will generate a fixed and limited set of PDF Properties to a
report rendered into PDF format. Can this set of properties be expanded
upon to include CUSTOM PROPERTIES?
thanks.
dlrHello Dennis,
Please refer to "PDF Device Information Settings" topic in BOL to see the
settings that is supported in built in PDF rendering extension.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/
rsp_prog_soapapi_dev_8bld.asp
You may want to custom your own rendering extenstion to support more custom
properties.
Thanks & Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/
If you are outside the United States, please visit our International
Support page:
http://support.microsoft.com/default.aspx?scid=%2finternational.aspx.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
| From: "Dennis Redfield" <dennis_redfield@.newsgroup.nospam>
| Subject: PDF Properties
| Date: Mon, 9 May 2005 11:37:21 -0400
| Lines: 9
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1478
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1478
| Message-ID: <ewUjPyKVFHA.3540@.TK2MSFTNGP15.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: rrcs-24-39-49-178.nys.biz.rr.com 24.39.49.178
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP15.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:43178
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| We know that RS will generate a fixed and limited set of PDF Properties
to a
| report rendered into PDF format. Can this set of properties be expanded
| upon to include CUSTOM PROPERTIES?
|
| thanks.
|
| dlr
|
|
||||Peter,
Indeed BOL documents the PDF Device Information Settings as well as the
(limited) set of meta data properties which may be set. I need to provide
custom properties withing the PDF that something like the Index Server
IFilter can read. So presumably this would be a custom rendering extension.
How would one go about contrusting such an extension for PDF rendering.
Thanks.
dlr
"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:beLYK7QVFHA.388@.TK2MSFTNGXA01.phx.gbl...
> Hello Dennis,
> Please refer to "PDF Device Information Settings" topic in BOL to see the
> settings that is supported in built in PDF rendering extension.
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/
> rsp_prog_soapapi_dev_8bld.asp
> You may want to custom your own rendering extenstion to support more
custom
> properties.
> Thanks & Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> Business-Critical Phone Support (BCPS) provides you with technical phone
> support at no charge during critical LAN outages or "business down"
> situations. This benefit is available 24 hours a day, 7 days a week to all
> Microsoft technology partners in the United States and Canada.
> This and other support options are available here:
> BCPS:
> https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
> Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/
> If you are outside the United States, please visit our International
> Support page:
> http://support.microsoft.com/default.aspx?scid=%2finternational.aspx.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
>
> --
> | From: "Dennis Redfield" <dennis_redfield@.newsgroup.nospam>
> | Subject: PDF Properties
> | Date: Mon, 9 May 2005 11:37:21 -0400
> | Lines: 9
> | X-Priority: 3
> | X-MSMail-Priority: Normal
> | X-Newsreader: Microsoft Outlook Express 6.00.2800.1478
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1478
> | Message-ID: <ewUjPyKVFHA.3540@.TK2MSFTNGP15.phx.gbl>
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: rrcs-24-39-49-178.nys.biz.rr.com 24.39.49.178
> | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP15.phx.gbl
> | Xref: TK2MSFTNGXA01.phx.gbl
microsoft.public.sqlserver.reportingsvcs:43178
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | We know that RS will generate a fixed and limited set of PDF Properties
> to a
> | report rendered into PDF format. Can this set of properties be expanded
> | upon to include CUSTOM PROPERTIES?
> |
> | thanks.
> |
> | dlr
> |
> |
> |
>|||Hello Dennis,
I think this is beyond this newsgroup. You may start with following link:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/
rsp_prog_extend_security_87oi.asp
This issue may fall under the umbrella of Advisory Services. Microsoft now
offers short-term and proactive assistance for specific planning, design,
development or assistance with installing, deploying, and general "how to"
advice via telephone. For more information:
http://support.microsoft.com/default.aspx?scid=fh;en-us;advisoryservice
Also, this is a great idea for a future product enhancement. I'd recommend
that you forward the recommendation to the Microsoft Wish Program:
- Visit the following Microsoft Web site:
http://www.microsoft.com/ms.htm
- Click Microsoft.com Guide in the upper-right corner of the page and then
click Contact Us . Click the link in the Product Suggestion section of the
page that appears.
- Visit the following Microsoft Product Feedback Web site
http://register.microsoft.com/mswish/suggestion.asp
and then complete and submit the form.
E-mail - To send comments or suggestions via e-mail, use the following
Microsoft Wish Program e-mail address, mswish@.microsoft.com.
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
| From: "Dennis Redfield" <dennis_redfield@.newsgroup.nospam>
| References: <ewUjPyKVFHA.3540@.TK2MSFTNGP15.phx.gbl>
<beLYK7QVFHA.388@.TK2MSFTNGXA01.phx.gbl>
| Subject: Re: PDF Properties
| Date: Tue, 10 May 2005 09:41:59 -0400
| Lines: 90
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1478
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1478
| Message-ID: <eNX8bWWVFHA.3532@.TK2MSFTNGP09.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: rrcs-24-39-49-178.nys.biz.rr.com 24.39.49.178
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:43284
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Peter,
| Indeed BOL documents the PDF Device Information Settings as well as
the
| (limited) set of meta data properties which may be set. I need to provide
| custom properties withing the PDF that something like the Index Server
| IFilter can read. So presumably this would be a custom rendering
extension.
| How would one go about contrusting such an extension for PDF rendering.
| Thanks.
|
| dlr
| "Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
| news:beLYK7QVFHA.388@.TK2MSFTNGXA01.phx.gbl...
| > Hello Dennis,
| >
| > Please refer to "PDF Device Information Settings" topic in BOL to see
the
| > settings that is supported in built in PDF rendering extension.
| >
| >
|
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/
| > rsp_prog_soapapi_dev_8bld.asp
| >
| > You may want to custom your own rendering extenstion to support more
| custom
| > properties.
| >
| > Thanks & Regards,
| >
| > Peter Yang
| > MCSE2000/2003, MCSA, MCDBA
| > Microsoft Online Partner Support
| >
| > When responding to posts, please "Reply to Group" via your newsreader so
| > that others may learn and benefit from your issue.
| >
| > =====================================================| >
| > Business-Critical Phone Support (BCPS) provides you with technical phone
| > support at no charge during critical LAN outages or "business down"
| > situations. This benefit is available 24 hours a day, 7 days a week to
all
| > Microsoft technology partners in the United States and Canada.
| >
| > This and other support options are available here:
| >
| > BCPS:
| >
https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
| >
| > Others:
https://partner.microsoft.com/US/technicalsupport/supportoverview/
| >
| > If you are outside the United States, please visit our International
| > Support page:
| > http://support.microsoft.com/default.aspx?scid=%2finternational.aspx.
| >
| > =====================================================| >
| > This posting is provided "AS IS" with no warranties, and confers no
| rights.
| >
| >
| >
| >
| > --
| > | From: "Dennis Redfield" <dennis_redfield@.newsgroup.nospam>
| > | Subject: PDF Properties
| > | Date: Mon, 9 May 2005 11:37:21 -0400
| > | Lines: 9
| > | X-Priority: 3
| > | X-MSMail-Priority: Normal
| > | X-Newsreader: Microsoft Outlook Express 6.00.2800.1478
| > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1478
| > | Message-ID: <ewUjPyKVFHA.3540@.TK2MSFTNGP15.phx.gbl>
| > | Newsgroups: microsoft.public.sqlserver.reportingsvcs
| > | NNTP-Posting-Host: rrcs-24-39-49-178.nys.biz.rr.com 24.39.49.178
| > | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP15.phx.gbl
| > | Xref: TK2MSFTNGXA01.phx.gbl
| microsoft.public.sqlserver.reportingsvcs:43178
| > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
| > |
| > | We know that RS will generate a fixed and limited set of PDF
Properties
| > to a
| > | report rendered into PDF format. Can this set of properties be
expanded
| > | upon to include CUSTOM PROPERTIES?
| > |
| > | thanks.
| > |
| > | dlr
| > |
| > |
| > |
| >
|
|
||||Peter,
Thanks for the link to get started.
If Wishes Were Horses....
dlr
"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:t7ioa7eVFHA.3928@.TK2MSFTNGXA01.phx.gbl...
> Hello Dennis,
> I think this is beyond this newsgroup. You may start with following link:
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/
> rsp_prog_extend_security_87oi.asp
> This issue may fall under the umbrella of Advisory Services. Microsoft now
> offers short-term and proactive assistance for specific planning, design,
> development or assistance with installing, deploying, and general "how to"
> advice via telephone. For more information:
> http://support.microsoft.com/default.aspx?scid=fh;en-us;advisoryservice
> Also, this is a great idea for a future product enhancement. I'd recommend
> that you forward the recommendation to the Microsoft Wish Program:
> - Visit the following Microsoft Web site:
> http://www.microsoft.com/ms.htm
> - Click Microsoft.com Guide in the upper-right corner of the page and then
> click Contact Us . Click the link in the Product Suggestion section of the
> page that appears.
> - Visit the following Microsoft Product Feedback Web site
> http://register.microsoft.com/mswish/suggestion.asp
> and then complete and submit the form.
> E-mail - To send comments or suggestions via e-mail, use the following
> Microsoft Wish Program e-mail address, mswish@.microsoft.com.
> Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================>
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
>
> --
> | From: "Dennis Redfield" <dennis_redfield@.newsgroup.nospam>
> | References: <ewUjPyKVFHA.3540@.TK2MSFTNGP15.phx.gbl>
> <beLYK7QVFHA.388@.TK2MSFTNGXA01.phx.gbl>
> | Subject: Re: PDF Properties
> | Date: Tue, 10 May 2005 09:41:59 -0400
> | Lines: 90
> | X-Priority: 3
> | X-MSMail-Priority: Normal
> | X-Newsreader: Microsoft Outlook Express 6.00.2800.1478
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1478
> | Message-ID: <eNX8bWWVFHA.3532@.TK2MSFTNGP09.phx.gbl>
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: rrcs-24-39-49-178.nys.biz.rr.com 24.39.49.178
> | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09.phx.gbl
> | Xref: TK2MSFTNGXA01.phx.gbl
microsoft.public.sqlserver.reportingsvcs:43284
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | Peter,
> | Indeed BOL documents the PDF Device Information Settings as well as
> the
> | (limited) set of meta data properties which may be set. I need to
provide
> | custom properties withing the PDF that something like the Index Server
> | IFilter can read. So presumably this would be a custom rendering
> extension.
> | How would one go about contrusting such an extension for PDF rendering.
> | Thanks.
> |
> | dlr
> | "Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
> | news:beLYK7QVFHA.388@.TK2MSFTNGXA01.phx.gbl...
> | > Hello Dennis,
> | >
> | > Please refer to "PDF Device Information Settings" topic in BOL to see
> the
> | > settings that is supported in built in PDF rendering extension.
> | >
> | >
> |
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/
> | > rsp_prog_soapapi_dev_8bld.asp
> | >
> | > You may want to custom your own rendering extenstion to support more
> | custom
> | > properties.
> | >
> | > Thanks & Regards,
> | >
> | > Peter Yang
> | > MCSE2000/2003, MCSA, MCDBA
> | > Microsoft Online Partner Support
> | >
> | > When responding to posts, please "Reply to Group" via your newsreader
so
> | > that others may learn and benefit from your issue.
> | >
> | > =====================================================> | >
> | > Business-Critical Phone Support (BCPS) provides you with technical
phone
> | > support at no charge during critical LAN outages or "business down"
> | > situations. This benefit is available 24 hours a day, 7 days a week to
> all
> | > Microsoft technology partners in the United States and Canada.
> | >
> | > This and other support options are available here:
> | >
> | > BCPS:
> | >
> https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
> | >
> | > Others:
> https://partner.microsoft.com/US/technicalsupport/supportoverview/
> | >
> | > If you are outside the United States, please visit our International
> | > Support page:
> | > http://support.microsoft.com/default.aspx?scid=%2finternational.aspx.
> | >
> | > =====================================================> | >
> | > This posting is provided "AS IS" with no warranties, and confers no
> | rights.
> | >
> | >
> | >
> | >
> | > --
> | > | From: "Dennis Redfield" <dennis_redfield@.newsgroup.nospam>
> | > | Subject: PDF Properties
> | > | Date: Mon, 9 May 2005 11:37:21 -0400
> | > | Lines: 9
> | > | X-Priority: 3
> | > | X-MSMail-Priority: Normal
> | > | X-Newsreader: Microsoft Outlook Express 6.00.2800.1478
> | > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1478
> | > | Message-ID: <ewUjPyKVFHA.3540@.TK2MSFTNGP15.phx.gbl>
> | > | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | > | NNTP-Posting-Host: rrcs-24-39-49-178.nys.biz.rr.com 24.39.49.178
> | > | Path:
TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP15.phx.gbl
> | > | Xref: TK2MSFTNGXA01.phx.gbl
> | microsoft.public.sqlserver.reportingsvcs:43178
> | > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> | > |
> | > | We know that RS will generate a fixed and limited set of PDF
> Properties
> | > to a
> | > | report rendered into PDF format. Can this set of properties be
> expanded
> | > | upon to include CUSTOM PROPERTIES?
> | > |
> | > | thanks.
> | > |
> | > | dlr
> | > |
> | > |
> | > |
> | >
> |
> |
> |
>

pdf instead of html as default output format

Hi all,
I would like to output all reports in pdf format instead of html.
I dont want to allow users to choose an export format.
So, if they access an URL and fill some textboxes with appropriated
parameters I can send them a ready-to-print PDF file in Internet Explorer.
Is it possible?
(I´m assuming all clients uses IE browser and Acrobat Reader plugin).
thanks a lot!One way you can do it is in the url of the report. You can add at the end of
your report url:
&rs:Command=Render&rs:format=pdf
Since it is in the url you have to be careful how you open it. I just open
the report in a new windows and it will actually render the report in the
adobe acrobat reader progam so there is no url the user can change. You
could embed it in an iframe on a page to display to a user as well.
"Ricardo" wrote:
> Hi all,
> I would like to output all reports in pdf format instead of html.
> I dont want to allow users to choose an export format.
> So, if they access an URL and fill some textboxes with appropriated
> parameters I can send them a ready-to-print PDF file in Internet Explorer.
> Is it possible?
> (IÂ´m assuming all clients uses IE browser and Acrobat Reader plugin).
> thanks a lot!
>
>

Monday, March 26, 2012

PDF Format Issues

My report was beautiful until I put groups around my two tables... actually
at first it looked fine... then I started changing text box sizes etc...
suddenly every second page in my report is blank... not in the viewer... when
I export to PDF... anyone know a RS exorcist?A bit silly to reply to my own post... but maybe someone else will run into
this problem... and it can be frustrating so here's how I fixed my problem...
1st off... a "page" in html isn't exactly the same size as a page in PDF...
a page in PDF has to be the same size as your paper... or less... I don't
know if html even has an exact page size limit... NEways...
The report designer in Visual Studio will increase your page size... if you
try to move a control outside of the space you have set... a pretty annoying
feature if you ask me... given that you usually want a page size to be
exactly the same forever... and sometimes you are playing with a long text
box, and you might not see the part off to the side increasing your page
width.
Does anyone know... is there a way to lock the page size?
"MER78" wrote:
> My report was beautiful until I put groups around my two tables... actually
> at first it looked fine... then I started changing text box sizes etc...
> suddenly every second page in my report is blank... not in the viewer... when
> I export to PDF... anyone know a RS exorcist?

PDF format - Garbled Data

Hello,
I searched for a response from the already posted queries. But I could not
find an answer to the problem that I have.
I have a report that looks fine on the screen and also when exported to
Excel. But
when exported to PDF some textboxes display garbled data. It may be because
of some characters in those textboxes.
Looks like a lot of people have this problem since some time. (I saw a
question that was posted last year related to the same problem)
Is there a solution to this problem?
Thanks,
SangDo you use the right font (has glyphs for these characters)? Is the font
installed on client and server?
--
Nico Cristache [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Sang" <Sang@.discussions.microsoft.com> wrote in message
news:4CE82890-95A9-42E5-9D3F-CD0243FE7AE8@.microsoft.com...
> Hello,
> I searched for a response from the already posted queries. But I could
not
> find an answer to the problem that I have.
> I have a report that looks fine on the screen and also when exported to
> Excel. But
> when exported to PDF some textboxes display garbled data. It may be
because
> of some characters in those textboxes.
> Looks like a lot of people have this problem since some time. (I saw a
> question that was posted last year related to the same problem)
> Is there a solution to this problem?
> Thanks,
> Sang
>|||I am having the same problem. So far it appears to be caused by the data in
the field. If i render the report with different criteria, it comes out ok.
Im curious to see what characters are causing this. It renders perfectly in
HTML though. This is only a problem with the PDF export.
"Nico Cristache [MSFT]" wrote:
> Do you use the right font (has glyphs for these characters)? Is the font
> installed on client and server?
> --
> Nico Cristache [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Sang" <Sang@.discussions.microsoft.com> wrote in message
> news:4CE82890-95A9-42E5-9D3F-CD0243FE7AE8@.microsoft.com...
> > Hello,
> >
> > I searched for a response from the already posted queries. But I could
> not
> > find an answer to the problem that I have.
> >
> > I have a report that looks fine on the screen and also when exported to
> > Excel. But
> > when exported to PDF some textboxes display garbled data. It may be
> because
> > of some characters in those textboxes.
> >
> > Looks like a lot of people have this problem since some time. (I saw a
> > question that was posted last year related to the same problem)
> >
> > Is there a solution to this problem?
> >
> > Thanks,
> > Sang
> >
> >
>
>|||DBCS characters are unreadable in PDF format
Double byte character set (DBCS) characters may fail to display correctly in a report exported to PDF format
From http://www.developmentnow.com/g/115_2004_10_0_0_451494/PDF-format--Garbled-Data.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.comsql

PDF FORMAT

I am trying to use couple of PDF librararies to do some post processing on the PDF generated by reproting services but all the tools i have tried so far are unable to open PDFs generated by RS - however other PDF (which are not generated by RS) can be opened normally programatically. RS generated PDF can however be viewed using acrobat reader...really strange - has anyone run into this problem - what is so specific about RS generated PDFs?Hey, try thi
"Ashok Jain" <AshokJain@.discussions.microsoft.com> wrote in message
news:69163171-1AD3-49B1-B7D6-333116B1DAE2@.microsoft.com...
> I am trying to use couple of PDF librararies to do some post processing on the
PDF generated by reproting services but all the tools i have tried so far are
unable to open PDFs generated by RS - however other PDF (which are not generated
by RS) can be opened normally programatically. RS generated PDF can however be
viewed using acrobat reader...really strange - has anyone run into this
problem - what is so specific about RS generated PDFs?|||...sorry somthing is wrong w/my keyboard....it keeps posting although I'm not'a
click'in on |Send
Anyway, you may wish to try this...
Rename one of those pdf's to .TXT, then open w/Notepad and remove everything
after the EOF.
Then save, rename to .PDF and retry to open.
I have the same problem rendering a report from .Net web page w/param text and
cmd buttons.
"Ashok Jain" <AshokJain@.discussions.microsoft.com> wrote in message
news:69163171-1AD3-49B1-B7D6-333116B1DAE2@.microsoft.com...
> I am trying to use couple of PDF librararies to do some post processing on the
PDF generated by reproting services but all the tools i have tried so far are
unable to open PDFs generated by RS - however other PDF (which are not generated
by RS) can be opened normally programatically. RS generated PDF can however be
viewed using acrobat reader...really strange - has anyone run into this
problem - what is so specific about RS generated PDFs?|||There is a bug in the PDF renderer which causes one of the offsets written
to the PDF file to be off by one byte. This doesn't impact Acrobat because
Acrobat automatically detects this situation and autorepairs the file, but
other tools may not be that smart. We have fixed this bug, and the fix will
be available in beta 3 of SQL Server 2005.
--
Rajeev Karunakaran [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ashok Jain" <AshokJain@.discussions.microsoft.com> wrote in message
news:69163171-1AD3-49B1-B7D6-333116B1DAE2@.microsoft.com...
>I am trying to use couple of PDF librararies to do some post processing on
>the PDF generated by reproting services but all the tools i have tried so
>far are unable to open PDFs generated by RS - however other PDF (which are
>not generated by RS) can be opened normally programatically. RS generated
>PDF can however be viewed using acrobat reader...really strange - has
>anyone run into this problem - what is so specific about RS generated PDFs?|||::::::::(((((((((
When is beta3 expected?
"Rajeev Karunakaran [MSFT]" wrote:
> There is a bug in the PDF renderer which causes one of the offsets written
> to the PDF file to be off by one byte. This doesn't impact Acrobat because
> Acrobat automatically detects this situation and autorepairs the file, but
> other tools may not be that smart. We have fixed this bug, and the fix will
> be available in beta 3 of SQL Server 2005.
> --
> Rajeev Karunakaran [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Ashok Jain" <AshokJain@.discussions.microsoft.com> wrote in message
> news:69163171-1AD3-49B1-B7D6-333116B1DAE2@.microsoft.com...
> >I am trying to use couple of PDF librararies to do some post processing on
> >the PDF generated by reproting services but all the tools i have tried so
> >far are unable to open PDFs generated by RS - however other PDF (which are
> >not generated by RS) can be opened normally programatically. RS generated
> >PDF can however be viewed using acrobat reader...really strange - has
> >anyone run into this problem - what is so specific about RS generated PDFs?
>
>|||Not yet announced. One way to get news about Yukon is to subscribe to the
newsletter: http://www.microsoft.com/sql/yukon/productinfo/default.asp
--
Rajeev Karunakaran [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ashok Jain" <AshokJain@.discussions.microsoft.com> wrote in message
news:98999417-9289-445D-AFC9-C4F4BF977FFF@.microsoft.com...
> ::::::::(((((((((
> When is beta3 expected?
>
> "Rajeev Karunakaran [MSFT]" wrote:
>> There is a bug in the PDF renderer which causes one of the offsets
>> written
>> to the PDF file to be off by one byte. This doesn't impact Acrobat
>> because
>> Acrobat automatically detects this situation and autorepairs the file,
>> but
>> other tools may not be that smart. We have fixed this bug, and the fix
>> will
>> be available in beta 3 of SQL Server 2005.
>> --
>> Rajeev Karunakaran [MSFT]
>> Microsoft SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "Ashok Jain" <AshokJain@.discussions.microsoft.com> wrote in message
>> news:69163171-1AD3-49B1-B7D6-333116B1DAE2@.microsoft.com...
>> >I am trying to use couple of PDF librararies to do some post processing
>> >on
>> >the PDF generated by reproting services but all the tools i have tried
>> >so
>> >far are unable to open PDFs generated by RS - however other PDF (which
>> >are
>> >not generated by RS) can be opened normally programatically. RS
>> >generated
>> >PDF can however be viewed using acrobat reader...really strange - has
>> >anyone run into this problem - what is so specific about RS generated
>> >PDFs?
>>

PDF file is not in right format

HI,

When I preview the report it is in correct format but when I save it in PDF form it is not coming in the right format.

There is a textbox on 1st page.If the value of that textbox is large it prints the text on 2nd page and leaves a blank

space on 1st page.Why this is happening.Please Help me.

May

Try couple of things:

1) make your textbox multiline. There is property MultiLine so set that to true.

2) Check your report page margins. Keep it according to your page size.

Let me know if this helps

Lav

|||

I have set the page margin to 0.3 and also body size is 6.8in.Still it is shifting the whole text to next page.

Text is a big paragraph .I could not find the multiline property of textbox.

Thanks in Advance.

May

|||

What is your page size??

I assume 6.8in is your width.

For Multiline i meant Can grow property. Make sure its set to True.

|||also make sure your page size must be greater than your width + left margin + right margin|||

Page Size is 8.5in-11in.Can Grow property is True already.

Is there any property like Keep Together.Because it is trying to keep the whole text together thats why

it is shifting it onto the next page.I tried to put textbox in a rectangle..still not working.

May

|||

Is there anything else on that page? Explain me the layout of the page.

If possible add an image of report layout.

|||

I don't know how to add the image from here.Layout is like this:

CustomerName: !First(FieldCustname.value) DateEntered: Fielddate.value

Contact (subreport)

Reason: !First(FieldReason.value)

Action: !First(FieldAction.value)

Reason textbox is giving trouble.After printing the name,date n contact the rest of the page is blank.

reason text is on 2nd page.

|||

I have the same problem with a table which the report try to display on the next page when it fit, butKeepTogether is set toflase and there is noPageBreakBefore.

But it behave like if KeepTogether was set to True.

Any idea ?

PDF expport and printing problem

Hello -
I am trying to export a report to PDF format and receive this error:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. (rrRenderingError) Get Online Help
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown.
Index was out of range. Must be non-negative and less than the size of the
collection. Parameter name: index
When I try to print my report this print error is displayed:
"An error occured during printing. (0x80004005)"
The report exports just fine to Excel and other reports export to PDF &
print just fine.
A previous post from Bruce Johnson referred to report language settings and
I am not sure which setting to verify.
I am running Reporting Services SP2.
Thanks,
PaulHello Paul -
Did you ever figure this error out? I am having the same issue. Thanks.
Mitch
mlake@.3plcorp.com
"Paul Ennamorato" wrote:
> Hello -
> I am trying to export a report to PDF format and receive this error:
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown. (rrRenderingError) Get Online Help
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown.
> Index was out of range. Must be non-negative and less than the size of the
> collection. Parameter name: index
> When I try to print my report this print error is displayed:
> "An error occured during printing. (0x80004005)"
> The report exports just fine to Excel and other reports export to PDF &
> print just fine.
> A previous post from Bruce Johnson referred to report language settings and
> I am not sure which setting to verify.
> I am running Reporting Services SP2.
> Thanks,
> Paul|||Mitch -
Thanks for your reply. We have not yet determined what causes this error
message.
Regards,
Paul
"Mitch Lake" wrote:
> Hello Paul -
> Did you ever figure this error out? I am having the same issue. Thanks.
> Mitch
> mlake@.3plcorp.com
> "Paul Ennamorato" wrote:
> > Hello -
> >
> > I am trying to export a report to PDF format and receive this error:
> >
> > Exception of type
> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> > thrown. (rrRenderingError) Get Online Help
> > Exception of type
> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> > thrown.
> > Index was out of range. Must be non-negative and less than the size of the
> > collection. Parameter name: index
> >
> > When I try to print my report this print error is displayed:
> >
> > "An error occured during printing. (0x80004005)"
> >
> > The report exports just fine to Excel and other reports export to PDF &
> > print just fine.
> >
> > A previous post from Bruce Johnson referred to report language settings and
> > I am not sure which setting to verify.
> >
> > I am running Reporting Services SP2.
> >
> > Thanks,
> >
> > Paul|||Well, I never did figure out what was happening, but SP2 seems to have fixed
the problem. I was able to isolate it down to a particular group footer and
then got the "bright" idea to check for a service pack. Installed to
development and server and all is good again.
Mitch
"Paul Ennamorato" wrote:
> Mitch -
> Thanks for your reply. We have not yet determined what causes this error
> message.
> Regards,
> Paul
> "Mitch Lake" wrote:
> > Hello Paul -
> >
> > Did you ever figure this error out? I am having the same issue. Thanks.
> >
> > Mitch
> > mlake@.3plcorp.com
> >
> > "Paul Ennamorato" wrote:
> >
> > > Hello -
> > >
> > > I am trying to export a report to PDF format and receive this error:
> > >
> > > Exception of type
> > > Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> > > thrown. (rrRenderingError) Get Online Help
> > > Exception of type
> > > Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> > > thrown.
> > > Index was out of range. Must be non-negative and less than the size of the
> > > collection. Parameter name: index
> > >
> > > When I try to print my report this print error is displayed:
> > >
> > > "An error occured during printing. (0x80004005)"
> > >
> > > The report exports just fine to Excel and other reports export to PDF &
> > > print just fine.
> > >
> > > A previous post from Bruce Johnson referred to report language settings and
> > > I am not sure which setting to verify.
> > >
> > > I am running Reporting Services SP2.
> > >
> > > Thanks,
> > >
> > > Paul

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 Very SLOW ! MS Rerporting Services TEAM Where Are you ??

Hi,
I have a matrix report that produce 79 pages on the HTML browser in 30
seconds, but
if I try to export the report in a PDF format it take more than 1 our !!!
The system configuration is:
IBM Server with 2 Pentium Xeon of 2.4 Ghz
1 Gb of RAM
Fast network HD
Windows 2003 Server SP1 (SBS)
SQL Server 2000 SP4
Rerpoting Services SP2
Do you have any idea about this problem ?
I've saw there are some old messages about this problem on this newsgroup,
but nobody of the
Microsoft Rerpoting Service Team has reply !!!
I think this is a very important issue, that can KILL the reportin services
system on a
Serious Real World company application.
Thanks.
Cesar Augusto Flavio De Min.
MCSDEven 30 seconds for HTML is very slow. PDF definitely is much much slower.
Everything is done in RAM. 1 GB of RAM is pretty minimal. Is your data on
this server as well or just RS? Can you add more RAM to it. Perhaps bring it
up to 2 Gig. Also, an 80 page report while not huge is most likely taking
time due to complexity. You could try splitting it up into multiple reports.
I don't know if RS 2005 has improved performance of PDF rendering or not.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Cesar Augusto Flavio De Min" <cdemin_news@.yahoo.com> wrote in message
news:emEEYAO7FHA.2012@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I have a matrix report that produce 79 pages on the HTML browser in 30
> seconds, but
> if I try to export the report in a PDF format it take more than 1 our !!!
> The system configuration is:
> IBM Server with 2 Pentium Xeon of 2.4 Ghz
> 1 Gb of RAM
> Fast network HD
> Windows 2003 Server SP1 (SBS)
> SQL Server 2000 SP4
> Rerpoting Services SP2
> Do you have any idea about this problem ?
> I've saw there are some old messages about this problem on this newsgroup,
> but nobody of the
> Microsoft Rerpoting Service Team has reply !!!
> I think this is a very important issue, that can KILL the reportin
> services system on a
> Serious Real World company application.
> Thanks.
> Cesar Augusto Flavio De Min.
> MCSD
>

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?
>> >
>>

Friday, March 30, 2012

PDF-Export Format not readable for non-windows users

PDF to RDL conversion

Wednesday, March 28, 2012

PDF rendering: Characters overlap in Verdana

PDF Rendering from an ASP page

PDF rendering bug in SP2

PDF rendering bug in SP2

PDF Rendering

PDF Properties

pdf instead of html as default output format

Monday, March 26, 2012

PDF Format Issues

PDF format - Garbled Data

PDF FORMAT

PDF file is not in right format

PDF expport and printing problem

PDF Exporting problem

PDF Export Very SLOW ! MS Rerporting Services TEAM Where Are you ??

PDF Export Prompts for Authentication

Passing result sets

Blog Archive

About Me