Passing result sets: render

Showing posts with label render. Show all posts

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 bug

We are trying to publish a group of financial reports using SQL Server
Reporting Services. We have hit a snag when we try to render the reports in
PDF format. The leading spaces of each line are stripped in the output
file. For example:

Department 10.7240 - ICU

Expenses SubDepartment
-- -
1,200 100
454 150

Becomes:

Department 10.7240 - ICU

Expenses SubDepartment
-- -
1,200 100
454 150

Does anyone know a solution for this problem? By the way, we did upgrade to SP2.
That did not correct the problem.

This blog entry (actually the comments for the entry) discusses same. Long story short, the PDF extension strips leading spaces in this version of SSRS, and there is no workaround :(

http://blogs.msdn.com/bimusings/archive/2005/06/15/429607.aspx

It sounds like you are "artificially" adding these spaces to make things line up. Can you re-position the textboxes which show the values and/or use the alignment settings to make the same thing happen?

|||

Thanks for the information. Actually we are moving a fully formatted report from an old DEC Alpha system to .pdf files. Currently this is done manually. It is a process that involves cutting and pasting hundreds of pages of the original report into output for individual departments. The SSRS report consists of a single text box to hold the lines of the source report. That is why we have leading spaces.

We are able to do all the breakout of individual sections using SQL Server, but It looks like we will have to find another product to do the final conversion from text to .pdf. Actually, tiff files come out great, but they are huge and slow.

Thanks again for the good information.

PDF Rendering - Page break with images

Hi,
I have a main page which has subreports, images and tables. in Preview i can
see the reports with proper page breaks, but when i render it to pdf, the
image and table in the main page is moving to another page, actually only 3
pages has to be printed in pdf but it is printing to 10 pages.
any suggestions please.
Thanks and regards,
AnithaI got the solution, i need to put all the lables and data in a Table to
display it in one page.
"Anitha Naidu" wrote:
> Hi,
> I have a main page which has subreports, images and tables. in Preview i can
> see the reports with proper page breaks, but when i render it to pdf, the
> image and table in the main page is moving to another page, actually only 3
> pages has to be printed in pdf but it is printing to 10 pages.
> any suggestions please.
> Thanks and regards,
> Anitha
>|||Try placing everything inside a rectangle control.
Place a rectangle in a blank area of the body.
Cut the controls including tables you want to contain, select the
rectangle, then paste the controls back in. Align things the way you
want inside the rectangle. This is the best way to restrict things in
RS. It may not work, but it's worth a try.
Cheers
Chris
Anitha Naidu wrote:
> I got the solution, i need to put all the lables and data in a Table
> to display it in one page.
>
> "Anitha Naidu" wrote:
> > Hi,
> >
> > I have a main page which has subreports, images and tables. in
> > Preview i can see the reports with proper page breaks, but when i
> > render it to pdf, the image and table in the main page is moving to
> > another page, actually only 3 pages has to be printed in pdf but it
> > is printing to 10 pages.
> >
> > any suggestions please.
> >
> > Thanks and regards,
> > Anitha
> >

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 Render Problem

Hello,
Below is the code I have written using SOAP API, VB.Net and ASP.net, so that
user can download the report onto their local drive. everything works fine
except when they open the file it gives errors ' There was an error opening
this document. The file is damaged and could not be repaired'. Please let me
know what is wrong with this code.
Thanks
_sReportLocation = "/BAOS Reporting/DashBoardReport/RepoDashBoard"
_S_DEVICE_INFO = "<DeviceInfo><Toolbar>False</Toolbar><HTMLFragment>true</HTMLFragment></DeviceInfo>"
_bResults = rs.Render(_sReportLocation, "PDF", Nothing,
_S_DEVICE_INFO, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing,
Nothing, Nothing)
Response.Clear()
Response.ContentType = "application/pdf"
If _sMimeType <> "text/html" Then
Response.AddHeader("Content-Disposition", "attachment;
filename=" & "BarChart.pdf")
End If
Response.BinaryWrite(_bResults)
--
Raj ChandraDoes it work on some computers but not all? This may sound kind of silly,
but we have seen similar problems with Adobe before.
Try deleting all of temp internet files on the client computer and running
the report. Its worked for us in the past when the report runs fine on one
computer but not the next.
"Raj Chandra" wrote:
> Hello,
>
> Below is the code I have written using SOAP API, VB.Net and ASP.net, so that
> user can download the report onto their local drive. everything works fine
> except when they open the file it gives errors ' There was an error opening
> this document. The file is damaged and could not be repaired'. Please let me
> know what is wrong with this code.
> Thanks
> _sReportLocation = "/BAOS Reporting/DashBoardReport/RepoDashBoard"
> _S_DEVICE_INFO => "<DeviceInfo><Toolbar>False</Toolbar><HTMLFragment>true</HTMLFragment></DeviceInfo>"
> _bResults = rs.Render(_sReportLocation, "PDF", Nothing,
> _S_DEVICE_INFO, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing,
> Nothing, Nothing)
> Response.Clear()
> Response.ContentType = "application/pdf"
> If _sMimeType <> "text/html" Then
> Response.AddHeader("Content-Disposition", "attachment;
> filename=" & "BarChart.pdf")
> End If
> Response.BinaryWrite(_bResults)
> --
> Raj Chandra|||Hi Pinolian, thanks for the response.
I tried on a different machine it did not work and I also tried after
deleting temp files same result.
"Pinolian" wrote:
> Does it work on some computers but not all? This may sound kind of silly,
> but we have seen similar problems with Adobe before.
> Try deleting all of temp internet files on the client computer and running
> the report. Its worked for us in the past when the report runs fine on one
> computer but not the next.
>
> "Raj Chandra" wrote:
> > Hello,
> >
> >
> > Below is the code I have written using SOAP API, VB.Net and ASP.net, so that
> > user can download the report onto their local drive. everything works fine
> > except when they open the file it gives errors ' There was an error opening
> > this document. The file is damaged and could not be repaired'. Please let me
> > know what is wrong with this code.
> >
> > Thanks
> >
> > _sReportLocation = "/BAOS Reporting/DashBoardReport/RepoDashBoard"
> > _S_DEVICE_INFO => > "<DeviceInfo><Toolbar>False</Toolbar><HTMLFragment>true</HTMLFragment></DeviceInfo>"
> >
> > _bResults = rs.Render(_sReportLocation, "PDF", Nothing,
> > _S_DEVICE_INFO, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing,
> > Nothing, Nothing)
> >
> > Response.Clear()
> > Response.ContentType = "application/pdf"
> >
> > If _sMimeType <> "text/html" Then
> > Response.AddHeader("Content-Disposition", "attachment;
> > filename=" & "BarChart.pdf")
> > End If
> > Response.BinaryWrite(_bResults)
> > --
> > Raj Chandra|||Have you installed Reporting Services Service Pack 1?
"Raj Chandra" wrote:
> Hi Pinolian, thanks for the response.
> I tried on a different machine it did not work and I also tried after
> deleting temp files same result.
>
> "Pinolian" wrote:
> >
> > Does it work on some computers but not all? This may sound kind of silly,
> > but we have seen similar problems with Adobe before.
> >
> > Try deleting all of temp internet files on the client computer and running
> > the report. Its worked for us in the past when the report runs fine on one
> > computer but not the next.
> >
> >
> > "Raj Chandra" wrote:
> >
> > > Hello,
> > >
> > >
> > > Below is the code I have written using SOAP API, VB.Net and ASP.net, so that
> > > user can download the report onto their local drive. everything works fine
> > > except when they open the file it gives errors ' There was an error opening
> > > this document. The file is damaged and could not be repaired'. Please let me
> > > know what is wrong with this code.
> > >
> > > Thanks
> > >
> > > _sReportLocation = "/BAOS Reporting/DashBoardReport/RepoDashBoard"
> > > _S_DEVICE_INFO => > > "<DeviceInfo><Toolbar>False</Toolbar><HTMLFragment>true</HTMLFragment></DeviceInfo>"
> > >
> > > _bResults = rs.Render(_sReportLocation, "PDF", Nothing,
> > > _S_DEVICE_INFO, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing,
> > > Nothing, Nothing)
> > >
> > > Response.Clear()
> > > Response.ContentType = "application/pdf"
> > >
> > > If _sMimeType <> "text/html" Then
> > > Response.AddHeader("Content-Disposition", "attachment;
> > > filename=" & "BarChart.pdf")
> > > End If
> > > Response.BinaryWrite(_bResults)
> > > --
> > > Raj Chandra|||Yes, I have RS SP1 installed. XL file works fine I am trouble only with PDF
files.
"Kevin Weir" wrote:
> Have you installed Reporting Services Service Pack 1?
>
> "Raj Chandra" wrote:
> > Hi Pinolian, thanks for the response.
> >
> > I tried on a different machine it did not work and I also tried after
> > deleting temp files same result.
> >
> >
> > "Pinolian" wrote:
> >
> > >
> > > Does it work on some computers but not all? This may sound kind of silly,
> > > but we have seen similar problems with Adobe before.
> > >
> > > Try deleting all of temp internet files on the client computer and running
> > > the report. Its worked for us in the past when the report runs fine on one
> > > computer but not the next.
> > >
> > >
> > > "Raj Chandra" wrote:
> > >
> > > > Hello,
> > > >
> > > >
> > > > Below is the code I have written using SOAP API, VB.Net and ASP.net, so that
> > > > user can download the report onto their local drive. everything works fine
> > > > except when they open the file it gives errors ' There was an error opening
> > > > this document. The file is damaged and could not be repaired'. Please let me
> > > > know what is wrong with this code.
> > > >
> > > > Thanks
> > > >
> > > > _sReportLocation = "/BAOS Reporting/DashBoardReport/RepoDashBoard"
> > > > _S_DEVICE_INFO => > > > "<DeviceInfo><Toolbar>False</Toolbar><HTMLFragment>true</HTMLFragment></DeviceInfo>"
> > > >
> > > > _bResults = rs.Render(_sReportLocation, "PDF", Nothing,
> > > > _S_DEVICE_INFO, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing,
> > > > Nothing, Nothing)
> > > >
> > > > Response.Clear()
> > > > Response.ContentType = "application/pdf"
> > > >
> > > > If _sMimeType <> "text/html" Then
> > > > Response.AddHeader("Content-Disposition", "attachment;
> > > > filename=" & "BarChart.pdf")
> > > > End If
> > > > Response.BinaryWrite(_bResults)
> > > > --
> > > > Raj Chandra

PDF Render performance with SP1

Hi,
We have been working with some lrge PDF reports (200-400 pages) and have been anxiously awaiting
SP1 because of performance problems we have been having.
Our initial tests show that the performance is better: Given about 3000 records from SQL Server,
we generated a 272 page report.
Pre SP1: 4 minutes 35 seconds
With SP: 2 minutes 5 second.
So it is just over twice as fast. I also noticed that it is consuming less memory (roughly down
from 700MB to 400MB)
We still would like to get the performance much better and I'm looking for help to understand the
process and what we can do. In the past, running this report in MS Access and using ActivePDF took
10-20 seconds to generate the same report. Why is there such a disparity?
The SQL Query is taking 1-2 seconds at most, then all of the time is spent in aspnet_wp - all CPU,
negligible disk I/O. How do you suggest we identify the time spent?
Are there any tricks to making the report more efficient so that the PDF render time is better? Do
you have some favorite performance counters to watch to better isolate this?
We are trying to convert to using RS exclusively for our reports, but this performance may prevent
us from doing so - any help would be appreciated!
Thanks to all,
JamiIn general, the rules around RDL are much more complex than that of Access.
So much of the time may be in processing, not rendering. What is the time
for XML? Also, what type of data regions are you using (list, table,
matrix?).
Nonetheless, we will continue to work on both performance and size for
future releases.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jami Bradley" <jbradley@.isa-og.com> wrote in message
news:vv3pd0hd8qupdap37f9e5rqn5c6pupi63k@.4ax.com...
> Hi,
> We have been working with some lrge PDF reports (200-400 pages) and have
> been anxiously awaiting
> SP1 because of performance problems we have been having.
> Our initial tests show that the performance is better: Given about 3000
> records from SQL Server,
> we generated a 272 page report.
> Pre SP1: 4 minutes 35 seconds
> With SP: 2 minutes 5 second.
> So it is just over twice as fast. I also noticed that it is consuming
> less memory (roughly down
> from 700MB to 400MB)
> We still would like to get the performance much better and I'm looking for
> help to understand the
> process and what we can do. In the past, running this report in MS Access
> and using ActivePDF took
> 10-20 seconds to generate the same report. Why is there such a disparity?
> The SQL Query is taking 1-2 seconds at most, then all of the time is spent
> in aspnet_wp - all CPU,
> negligible disk I/O. How do you suggest we identify the time spent?
> Are there any tricks to making the report more efficient so that the PDF
> render time is better? Do
> you have some favorite performance counters to watch to better isolate
> this?
> We are trying to convert to using RS exclusively for our reports, but this
> performance may prevent
> us from doing so - any help would be appreciated!
> Thanks to all,
> Jami
>|||We timed the XML output and it was just over 2 *seconds*. Our report is a list with sublists.
If you have any tips that may avoid performance issues with our reports, please let us know.
Thanks!
Jami
On Sat, 26 Jun 2004 00:25:50 -0700, "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote:
>In general, the rules around RDL are much more complex than that of Access.
>So much of the time may be in processing, not rendering. What is the time
>for XML? Also, what type of data regions are you using (list, table,
>matrix?).
>Nonetheless, we will continue to work on both performance and size for
>future releases.|||Well, XML is much easier than PDF. One thing that you should probably look
at is converting some of your report to tables instead of lists. Tables can
sometimes be faster to render.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jami Bradley" <jbradley@.isa-og.com> wrote in message
news:cfc0e0ld0j45b4tbl6ic32tvskcod2ff3t@.4ax.com...
> We timed the XML output and it was just over 2 *seconds*. Our report is a
> list with sublists.
> If you have any tips that may avoid performance issues with our reports,
> please let us know.
> Thanks!
> Jami
> On Sat, 26 Jun 2004 00:25:50 -0700, "Brian Welcker [MSFT]"
> <bwelcker@.online.microsoft.com> wrote:
>>In general, the rules around RDL are much more complex than that of
>>Access.
>>So much of the time may be in processing, not rendering. What is the time
>>for XML? Also, what type of data regions are you using (list, table,
>>matrix?).
>>Nonetheless, we will continue to work on both performance and size for
>>future releases.
>|||We have been doing some testing with one of our reports and found a few interesting things. Here
is the basic information on what we did and how it affected the PDF size and PDF render
performance. All of the reports we ran were dominated by PDF render (checked in the execution
log). We were unable to get adequate performance from this report, so we solved this with a
different product, but I hope the information is useful to others.
All of these tests were using Report Manager - the processing time is the time for 'View Report' to
preview in IE, the PDF render time is the time to export to PDF from Report Manager.
A. Baseline Report (original form, desired report format):
10-15 seconds processing, 5:27 in PDF render, 508 pages, 10.6MB
B. Removed grouping and sub-report:
11 seconds processing, 2:10 in PDF render, 508 pages, 10.2MB
C. B with all details line drawing removed, and no logo (now a plain text report):
9 seconds processing, 1:00 in PDF render, 402 pages, 2.6MB
D. C with no line drawing in page header, avoiding overlapping text:
11 seconds processing, 52 in PDF render, 402 pages, 2.01MB
E. D with two fields removed (fairly complex nested iif expressions):
8 seconds processing, 46 in PDF render, 402 pages, 1.92MB
Items C, D, E had slightly different queries which reduced the row count from about 4500 to about
4000. Too bad I saw this late! I retested E with the proper row count to get the following
results:
E2. Corrected where clause to get all the rows:
9 seconds processing, 1:15 in PDF render, 451 pages, 2.16MB
So the conclusions? Grouping is dominating the time to get this report rendered (our grouping
simply puts a header line between groups). Line drawing makes the PDF significantly larger - this
is not too surpising, but other products seem to do this much more efficiently.
Good luck,
Jami
On Mon, 28 Jun 2004 22:43:17 -0700, "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote:
>Well, XML is much easier than PDF. One thing that you should probably look
>at is converting some of your report to tables instead of lists. Tables can
>sometimes be faster to render.

PDF render

Using RS/SQL 2000.
Is there a way to make the rendering of a report in PDF form any faster?
Currently takes about 40 mins for 10,000 pages. Only solution i can think of
is throw more hardware at it.
Thanks,
SPOOn Mon, 19 Dec 2005 06:01:02 -0800, iamspo wrote:
> Using RS/SQL 2000.
> Is there a way to make the rendering of a report in PDF form any faster?
> Currently takes about 40 mins for 10,000 pages. Only solution i can think of
> is throw more hardware at it.
> Thanks,
> SPO
I'd agree - throw more hardware at it, but I have to ask what everyone else
is probably thinking...
10,000 pages? What are you generating? Could anyone possibly look through
(or print!) a PDF containing that many pages?|||> 10,000 pages? What are you generating? Could anyone possibly look
> through
> (or print!) a PDF containing that many pages?
I don't see how or why.sql

PDF output problem for checkbox like "Ticks" displayed in reports

Hi All,
we created a report that should render some "checked items" (like the ticks
in a checkbox) to indicate the given answers for multiple chooice questions
from a questionaire.
Displaying the tick is done by using a unicode character from the font "MS
Mincho". When we render the report in report viewer, all seems to be fine,
but when rendered to a pdf it goes wrong; the "tick" is replaced with a
question mark.
We can't find any specific unicode/pdf related settings for RS. Any clues.
Many thanks in advance,
TimHi tvds,
I have exactly the same problem, did you find any solution?
Thanks,
Markus
"tvds" wrote:
> Hi All,
> we created a report that should render some "checked items" (like the ticks
> in a checkbox) to indicate the given answers for multiple chooice questions
> from a questionaire.
> Displaying the tick is done by using a unicode character from the font "MS
> Mincho". When we render the report in report viewer, all seems to be fine,
> but when rendered to a pdf it goes wrong; the "tick" is replaced with a
> question mark.
> We can't find any specific unicode/pdf related settings for RS. Any clues.
> Many thanks in advance,
> Tim
>sql

PDF Not begin handled by FireFox

When I use the Webservice Render method for a PDF, the PDF shows perfectly
in IE but in FireFox it dumps the text of the pdf instead of rendering it...
Any ideas?
Tim Philomeno
tphilomeno@.sparling.comWhat does your FireFox do when you open other PDFs?
--
Floyd
"Tim Philomeno" <tphilomeno@.sparling.com> wrote in message
news:OvsscidnFHA.2472@.tk2msftngp13.phx.gbl...
> When I use the Webservice Render method for a PDF, the PDF shows perfectly
> in IE but in FireFox it dumps the text of the pdf instead of rendering
> it...
> Any ideas?
> Tim Philomeno
> tphilomeno@.sparling.com
>|||If I open a PDF from a local drive or the internet, it works perfectly...
Tim
"Floyd Burger" <mrlements@.community.nospam> wrote in message
news:%23exPxUenFHA.708@.TK2MSFTNGP09.phx.gbl...
> What does your FireFox do when you open other PDFs?
> --
> Floyd
> "Tim Philomeno" <tphilomeno@.sparling.com> wrote in message
> news:OvsscidnFHA.2472@.tk2msftngp13.phx.gbl...
>> When I use the Webservice Render method for a PDF, the PDF shows
>> perfectly in IE but in FireFox it dumps the text of the pdf instead of
>> rendering it...
>> Any ideas?
>> Tim Philomeno
>> tphilomeno@.sparling.com
>|||It could be that FireFox is observing the file extension to determine that
it needs to pass the file to Acrobat vs. the mime type.
"Tim Philomeno" <tphilomeno@.sparling.com> wrote in message
news:OvsscidnFHA.2472@.tk2msftngp13.phx.gbl...
> When I use the Webservice Render method for a PDF, the PDF shows perfectly
> in IE but in FireFox it dumps the text of the pdf instead of rendering
it...
> Any ideas?
> Tim Philomeno
> tphilomeno@.sparling.com
>sql

PDF has a extra page

Some tips please on PDF rendering.
I have an invoice form report that should be one page in length, but when I
render to PDF I get a 2nd page with header & footer but nothing in the
middle. How do I stop this happening?
brian smithIn VS, under report properties, are your page dimensions set to the proper height and width? Based on those values, is the width of your page in the layout view actually fit that?
I had a similar problem with one of my reports - turned out my margins were larger than I had thought. Shrinking down the report body by about a quarter of an inch solved it.
HTH
- T|||Make sure that your report is set up as follows:
(Report.PageWidth - Report.LeftMargin - Report.Right Margin) >= Body.Width
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Brian Smith" <bsmith@.nospam.leazesdotcom> wrote in message
news:%23nxXmxEZEHA.2844@.TK2MSFTNGP12.phx.gbl...
> Some tips please on PDF rendering.
> I have an invoice form report that should be one page in length, but when
I
> render to PDF I get a 2nd page with header & footer but nothing in the
> middle. How do I stop this happening?
> brian smith
>|||Thanks - I'll try it later.
brian
"Bruce Johnson [MSFT]" <brucejoh@.online.microsoft.com> wrote in message
news:%23Er1vhFZEHA.3596@.tk2msftngp13.phx.gbl...
> Make sure that your report is set up as follows:
> (Report.PageWidth - Report.LeftMargin - Report.Right Margin) >= Body.Width
>
> --
> Bruce Johnson [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Brian Smith" <bsmith@.nospam.leazesdotcom> wrote in message
> news:%23nxXmxEZEHA.2844@.TK2MSFTNGP12.phx.gbl...
> > Some tips please on PDF rendering.
> > I have an invoice form report that should be one page in length, but
when
> I
> > render to PDF I get a 2nd page with header & footer but nothing in the
> > middle. How do I stop this happening?
> >
> > brian smith
> >
> >
>|||Worked fine. Thanks very much.
brian
"Bruce Johnson [MSFT]" <brucejoh@.online.microsoft.com> wrote in message
news:%23Er1vhFZEHA.3596@.tk2msftngp13.phx.gbl...
> Make sure that your report is set up as follows:
> (Report.PageWidth - Report.LeftMargin - Report.Right Margin) >= Body.Width
>
> --
> Bruce Johnson [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Brian Smith" <bsmith@.nospam.leazesdotcom> wrote in message
> news:%23nxXmxEZEHA.2844@.TK2MSFTNGP12.phx.gbl...
> > Some tips please on PDF rendering.
> > I have an invoice form report that should be one page in length, but
when
> I
> > render to PDF I get a 2nd page with header & footer but nothing in the
> > middle. How do I stop this happening?
> >
> > brian smith
> >
> >
>

Monday, March 26, 2012

PDF Export Causes 100 % CPU - MS Response appreciated

I have a 100 page report that I render as PDF and then show in an
IFrame from a C# Ascx user control. It takes about 3 minutes to
render if ONE person is rendering the report. The CPU goes to about
50 %. If TWO people attempt to render the report, the CPU goes to
100% and the reports don't render (at least after 11 minutes).
If I render to HTML, it takes about 15 seconds although HTML Rendering
is not an option in this application.
This is running on a server with 1 GIG of memory Xeon 2.38 processor.
I've installed Service Pack 1 (although it blasted through the install
REALLY FAST so I have my doubts).
I had thought that SP1 was supposed to improve PDF rendering. Is
there something I can program to improve performance?
This issue, if not resolvable, makes RS unusable for this application
which is not an option I'm pleased with.
Thanks in Advance for the Reply
Timothy Heuer
heuert@.comcast.netSP1 does contain some improvement for PDF rendering. We are continuing to
improve it for the next release. If you can send the repro (RDL and data),
we will investigate to see what is causing the problem in your particular
scenario.
Fang Wang (MSFT)
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"teem60004" <teem60004@.hotmail.com> wrote in message
news:66823058.0407230846.6c7b89c5@.posting.google.com...
> I have a 100 page report that I render as PDF and then show in an
> IFrame from a C# Ascx user control. It takes about 3 minutes to
> render if ONE person is rendering the report. The CPU goes to about
> 50 %. If TWO people attempt to render the report, the CPU goes to
> 100% and the reports don't render (at least after 11 minutes).
> If I render to HTML, it takes about 15 seconds although HTML Rendering
> is not an option in this application.
> This is running on a server with 1 GIG of memory Xeon 2.38 processor.
> I've installed Service Pack 1 (although it blasted through the install
> REALLY FAST so I have my doubts).
> I had thought that SP1 was supposed to improve PDF rendering. Is
> there something I can program to improve performance?
> This issue, if not resolvable, makes RS unusable for this application
> which is not an option I'm pleased with.
> Thanks in Advance for the Reply
>
> Timothy Heuer
> heuert@.comcast.net

Friday, March 23, 2012

PDF and Merge Cell Border Style Issue

Problem: I have borders that are hidden (Border Style=None) that appear ok in HTML but when Render in PDF they appear when they should not. Basically I am using a few columns like TABS in one Major Column in my report in combination with Merge Cells.

In Sql2000 -> There is no problem in the HTML or PDF rendering.

In Sql2005SP1 -> The problem occurs in two forms:

a) Problem Only Shows up in the PDF Creation call in our ASPX in IIS

b) Problem occurs in both the ASPX call and the Reporting Services Report Upload (Export to PDF)

Is there a fix to this issue or work around?

Solution

1) Reset All Border Styles and Border Colors to Vanilla (I mean every cell)

2) Redo your Border Styles etc but be careful -> It kinda like chess

This is due to that Sql2000 and Sql2005 handles the narly RDL Rendering conflicts differently.

PDF and attribute

I have reporting service 2005 report, Through Render method, populating PDF
file. Is there anyway, we can set PDF attrubute file to prevent user to
modify?
with Readyonly attribute, user can change the property of a file?
any othereway, we can make PDF can not be modifed using Editor?
in short, make the PDF readyonly.On Dec 10, 2:20 pm, Kalyan <Kal...@.discussions.microsoft.com> wrote:
> I have reporting service 2005 report, Through Render method, populating PDF
> file. Is there anyway, we can set PDF attrubute file to prevent user to
> modify?
> with Readyonly attribute, user can change the property of a file?
> any othereway, we can make PDF can not be modifed using Editor?
> in short, make the PDF readyonly.
Normally, if a user has a PDF creator software, it is hard to keep
them from modifying the PDF file; however, to set the attributes to
read only, you could try something like this in a custom ASP.NET
application.
http://www.java2s.com/Tutorial/VB/0240__Stream-File/SetfileattributesHiddenReadOnly.htm
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

Friday, March 9, 2012

Password protection on subscription-based Excel reports

I know RS doesn't offer this now.
I'm trying to figure out a workaround.
I need to:
-run a report on a schedule
-render it to excel
-password protect it
-email it
Subscriptions would be fine if it weren't for the password issue.
I've got DotNet code create the reprot and render it as an Excel
spreadsheet.
I've got code to password-protect the spreadsheet.
I want code to control the above code - to run at a certain time and
then deliver it via email. But it doesn't look like the Subscriptions
object will do this. Subscriptions appears to create the report and
deliver it, but not allow intervention for something like password
protection.My suggestion is that you use a script outside of Reporting Services to send
the mail. You can use CDO or .NET web mail. YOu can then schedule this using
Windows scheduler.
Try using the following code in a VB Console Application (you need to add a
reference of System.Web.dll to your project):
Imports System.Web.Mail
Module Module1
Dim oMail As MailMessage = New MailMessage
Sub Main()
oMail.From = "user@.mydomain.com"
oMail.To = "administrator@.classroom.com"
oMail.Subject = "Sending Using Web Mail"
oMail.BodyFormat = MailFormat.Text
oMail.Body = "Password protected file."
Dim myfile As String = "c:\Myfile.xls"
Dim oAttachment As MailAttachment = New MailAttachment(myfile)
oMail.Attachments.Add(oAttachment)
SmtpMail.SmtpServer = "10.1.1.200"
SmtpMail.Send(oMail)
oMail = Nothing
oAttachment = Nothing
End Sub
End Module
HTH
Charles Kangai, MCT, MCDBA
"Jay" wrote:
> I know RS doesn't offer this now.
> I'm trying to figure out a workaround.
> I need to:
> -run a report on a schedule
> -render it to excel
> -password protect it
> -email it
> Subscriptions would be fine if it weren't for the password issue.
> I've got DotNet code create the reprot and render it as an Excel
> spreadsheet.
> I've got code to password-protect the spreadsheet.
> I want code to control the above code - to run at a certain time and
> then deliver it via email. But it doesn't look like the Subscriptions
> object will do this. Subscriptions appears to create the report and
> deliver it, but not allow intervention for something like password
> protection.
>|||The best solution here is to create a custom delivery extension.
--
Peter Blackburn
Windows Server Systems - SQL Server MVP
Hitchhiker's Guide to SQL Server 2000 Reporting Services
http://www.sqlreportingservices.net
"Jay" <jaytaylor_it@.hotmail.com> wrote in message
news:a737af3c.0411291503.60317abc@.posting.google.com...
>I know RS doesn't offer this now.
> I'm trying to figure out a workaround.
> I need to:
> -run a report on a schedule
> -render it to excel
> -password protect it
> -email it
> Subscriptions would be fine if it weren't for the password issue.
> I've got DotNet code create the reprot and render it as an Excel
> spreadsheet.
> I've got code to password-protect the spreadsheet.
> I want code to control the above code - to run at a certain time and
> then deliver it via email. But it doesn't look like the Subscriptions
> object will do this. Subscriptions appears to create the report and
> deliver it, but not allow intervention for something like password
> protection.|||Thanks. This looks like the way to go. I think I"ll have to go outside RS. I
don't think a delivery extension can handle this.
"Charles Kangai" wrote:
> My suggestion is that you use a script outside of Reporting Services to send
> the mail. You can use CDO or .NET web mail. YOu can then schedule this using
> Windows scheduler.
> Try using the following code in a VB Console Application (you need to add a
> reference of System.Web.dll to your project):
> Imports System.Web.Mail
> Module Module1
> Dim oMail As MailMessage = New MailMessage
> Sub Main()
> oMail.From = "user@.mydomain.com"
> oMail.To = "administrator@.classroom.com"
> oMail.Subject = "Sending Using Web Mail"
> oMail.BodyFormat = MailFormat.Text
> oMail.Body = "Password protected file."
> Dim myfile As String = "c:\Myfile.xls"
> Dim oAttachment As MailAttachment = New MailAttachment(myfile)
> oMail.Attachments.Add(oAttachment)
> SmtpMail.SmtpServer = "10.1.1.200"
> SmtpMail.Send(oMail)
> oMail = Nothing
> oAttachment = Nothing
> End Sub
> End Module
>
> HTH
> Charles Kangai, MCT, MCDBA
>
> "Jay" wrote:
> > I know RS doesn't offer this now.
> >
> > I'm trying to figure out a workaround.
> >
> > I need to:
> >
> > -run a report on a schedule
> > -render it to excel
> > -password protect it
> > -email it
> >
> > Subscriptions would be fine if it weren't for the password issue.
> >
> > I've got DotNet code create the reprot and render it as an Excel
> > spreadsheet.
> > I've got code to password-protect the spreadsheet.
> >
> > I want code to control the above code - to run at a certain time and
> > then deliver it via email. But it doesn't look like the Subscriptions
> > object will do this. Subscriptions appears to create the report and
> > deliver it, but not allow intervention for something like password
> > protection.
> >|||Thanks. I don't get it, though - it looks like whatever custom delivery
extension I'd create, I'd still need to use RS's CreateSubscription method.
How woud I be able to insert password protection into the process when the
subscription kicks off?
"Peter Blackburn (www.sqlreportingservice" wrote:
> The best solution here is to create a custom delivery extension.
> --
> Peter Blackburn
> Windows Server Systems - SQL Server MVP
> Hitchhiker's Guide to SQL Server 2000 Reporting Services
> http://www.sqlreportingservices.net
>
> "Jay" <jaytaylor_it@.hotmail.com> wrote in message
> news:a737af3c.0411291503.60317abc@.posting.google.com...
> >I know RS doesn't offer this now.
> >
> > I'm trying to figure out a workaround.
> >
> > I need to:
> >
> > -run a report on a schedule
> > -render it to excel
> > -password protect it
> > -email it
> >
> > Subscriptions would be fine if it weren't for the password issue.
> >
> > I've got DotNet code create the reprot and render it as an Excel
> > spreadsheet.
> > I've got code to password-protect the spreadsheet.
> >
> > I want code to control the above code - to run at a certain time and
> > then deliver it via email. But it doesn't look like the Subscriptions
> > object will do this. Subscriptions appears to create the report and
> > deliver it, but not allow intervention for something like password
> > protection.
>
>

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 bug

PDF Rendering - Page break with images

PDF Rendering

PDF Render Problem

PDF Render performance with SP1

PDF render

PDF output problem for checkbox like "Ticks" displayed in reports

PDF Not begin handled by FireFox

PDF has a extra page

Monday, March 26, 2012

PDF Export Causes 100 % CPU - MS Response appreciated

Friday, March 23, 2012

PDF and Merge Cell Border Style Issue

PDF and attribute

Friday, March 9, 2012

Password protection on subscription-based Excel reports

Passing result sets

Blog Archive

About Me