sql reporting services - batch pdf generation

Question

sql reporting services - batch pdf generation

omhoge

SSCertifiable

Points: 5416
More actions
November 8, 2004 at 8:30 am

#162795

Hey gang,
Any one know a way to dynamically and automacially batch generate a mass of pdf files using reporting services?
Investigating options for PDF generation in an app that uses SQL Server 2000.
Much appreciated!
Skål - jh

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

WILLIAM MITCHELL SSChampion Points: 13766 More actions · Answer 1

Here is a portion of C# code that I use to create a PDF in the user's temp directory. The string rsReport is the name of the report I'm about to process, and I also use that for the file name. . .

ReportingService _rs = new ReportingService();

_rs.Credentials = System.Net.CredentialCache.DefaultCredentials;

string sOutputPath = Environment.GetEnvironmentVariable("TEMP");

string encoding;

string mimeType;

ParameterValue[] parametersUsed;

Warning[] warnings;

string[] streamIds;

//render the report

byte[] data;

data = _rs.Render("/" + rsReport, "PDF", null, null, parameters, null,

null, out encoding, out mimeType, out parametersUsed, out warnings,

out streamIds);

//create a file stream to write the output

string fileName = sOutputPath + "\\" + rsReport + ".PDF";

// delete if previous file exists -

// workaround if Acrobat hung & left a corrupted PDF

try

{

File.Delete(fileName);

}

catch

{

}

FileStream fs = new FileStream(fileName, FileMode.OpenOrCreate);

BinaryWriter writer = new BinaryWriter(fs);

writer.Write(data, 0, data.Length);

writer.Close();

fs.Close();

Vivi SSC-Addicted Points: 457 More actions · Answer 2

Vivi

SSC-Addicted

Points: 457

November 9, 2004 at 8:32 am

#529464

You can also try Data Driven Subscription.

omhoge SSCertifiable Points: 5416 More actions · Answer 3

omhoge

SSCertifiable

Points: 5416

November 9, 2004 at 1:43 pm

#529510

Great, thanks you 2. Will try it out!

Skål - jh

omhoge SSCertifiable Points: 5416 More actions · Answer 4

Also found this third party soft ware independent of Reporting Services.

pretty cool I thought

http://www.dynamicpdf.com/

Skål - jh

Jörn Fandrey SSC Veteran Points: 248 More actions · Answer 5

See a recent article here about the "rs" Tool. It describes your task for Excel files but should also be possible with PDF.

Re

Jörn

Jörn Fandrey SSC Veteran Points: 248 More actions · Answer 6

Sorry forgor the URL:

http://www.sqlservercentral.com/articles/articlesexternal.asp?articleid=1681

Re

Jörn