Hello,
I'm looking for an example on how to programmatically render a report to pdf in C#. I don't want to use a url with the rs:Format=pdf querystring. Any help would be much appreciated!!
Hello,
Have a look at this doc page:
http://msdn2.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswebservice.rsexecutionservice2005.reportexecutionservice.render.aspx
There is a full example of how to render reports programmatically using the Render method.
-Chris
|||Hi Chris,
Thanks for your response. I took a look at the link you gave me and now I'm getting the following error:
There was an error opening this document. The file is damaged and cannot be repaired.
Here is the code I'm using:
localhost.ReportingService rs = new localhost.ReportingService();
rs.Credentials = System.Net.CredentialCache.DefaultCredentials;
byte[] ResultStream;
string[] StreamIdentifiers;
string OptionalParam = null;
string deviceInfo = "<DeviceInfo>" +
" <OutputFormat>PDF</OutputFormat>" +
" <PageWidth>8.5in</PageWidth>" +
" <PageHeight>11in</PageHeight>" +
" <MarginTop>0.5in</MarginTop>" +
" <MarginLeft>0.5in</MarginLeft>" +
" <MarginRight>0.5in</MarginRight>" +
" <MarginBottom>0.5in</MarginBottom>" +
"</DeviceInfo>";
string mimetype;
string encoding;
string historyid = null;
localhost.ParameterValue[] optionalParams = new localhost.ParameterValue[1];
optionalParams[0] = new localhost.ParameterValue();
optionalParams[0].Name = "applicantid";
optionalParams[0].Value = "10";
localhost.Warning[] optionalWarnings = null;
ResultStream = rs.Render("/employmentapplication/printableemploymentapplication",
"pdf",
historyid,
deviceInfo,
optionalParams,
null,
null,
out encoding,
out mimetype,
out optionalParams,
out optionalWarnings,
out StreamIdentifiers);
Response.BinaryWrite(ResultStream);
No matter which report I try to open, I get the same error. Any help is greatly appreciated!!!
Thanks!!
Daniel
|||You get that error when you attempt to open the document?
It could be that there is some extraneous stuff being written to the HTTP stream to which you do your BinaryWrite. I suggest writing "ResultStream" to a file to isolate where corruption, if any, may be occurring.
Also, the OutputFormat value in DeviceInfo is not necessary when rendering to PDF since you're specifying the render format in the Render method call.
-Chris
|||There shouldn't be any extra bytes in the response stream so you shouldn't worry about that. Make sure that you are actually closing the BinaryWriter. Many of the CLR streams buffer internally, so if they are not closed completely then there can be problems where all of the data is not being written.|||
Hi John -
Thanks for you response. How do I close Response.BinaryWriter? Do you have an example of programmatically rendering a report to pdf that I can look at? Thanks again for all your help!!!
|||From the RS side of the things, you are doing things correctly. As Chris pointed out, I would look into making sure that you are properly handling the Response stream. If you are writing any other data to it, then you will run into problems.
You should be able to call .Flush() on the stream to make sure the contents are completely written out.
-John
|||I was running into the same issue today... calling Flush() and Close() on the response object fixed my issues.
--Andy
|||Hello,
I have successfully implemented the sample referenced above with a VB.NET console app. I would like to build a CLR stored procedure that implements the same code, programmatically generating a PDF report and outputting it to a file. I'm running into permissions issues.
Anybody had any luck calling the Reporting Services Web Service API from inside a CLR stored procedure?
Ken
|||Renskemo, you might want to take this question over to the following forum: http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=86&SiteID=1
