Batch Printing

Hi,

I have to print bank statements for several thousand accounts. I'll have to design a statement template and connect it to my SQL Server database. What tool(s) can I use for this? I can use Reporting Services but I'm not sure if I can use it to print several reports based on an account range in batch mode. Any pointers and suggestions will be highly appreciated.

Thanks.

Umar.

Reporting Services, custom Visual Studio application, Access -even Microsoft Word or Excel 'could' work.

|||See this http://www.sql-server-performance.com/sm_sql_2005_reporting.asp for direct client printing.

Batch Printing

Has anyone been able to automatically print via reporting services? I have
subscriptions set up that produce PDF files, but I have to go in and manually
print them. There's gotta be a better way.> Has anyone been able to automatically print via reporting services? I have
> subscriptions set up that produce PDF files, but I have to go in and
> manually
> print them. There's gotta be a better way.
I took a long and serious look at this problem and didn't come up with any
snappy solution.
Problems you are facing are mainly the following:
1) Delivering the PDFs to a specific folder, either by manually printing
from the client, or by some automatically scheduled job.
This one I solved with SSIS (Integration Services), which is watching a
"printing command table" in my SQL database, and invoking the report(s)
based on the info from new lines in the table.
Then using a Script task in SSIS, you can invoke the report from SSRS and
get a raw PDF back which SSIS then writes to a PDF file.
2) A PDF printing utility that can be invoked through the command line.
Acrobat reader does NOT handle this from the command line. Some versions of
Acrobat reader are said to handle it via an undocumented commandline switch,
but I found this to be Acrobat version dependent and gave up.
Found a PDF Printing utility from VeryPDF.COM where you can buy a single
server commandline utility for $199
3) Some kind of watching mecanism for the PDF folder which invokes the
PDFPrinting program.
This can be done which ever way you find suitable. It can even be done by
batch file programming, which I did for starters in my implementation.
All in all, a really cumbersome way of delivering reports directly to
printer from a product called "Reporting Services", but it works!
Regards,
Palli

Batch Printing

Hi All
I have a customer report that I need to automatically print at the end of
each month. What is the best way to programmatically print the report? Is
it also possible to specify the customers so that the report gets printed for
say all customers with a transaction in the last 30 days?
ThanksHi David,
Try adding a subscription to a file system for a report which prints all
statements and then have a windows scheduled job which pick up the PDF and
automatically print it. There are a number of windows script files which will
print all PDF's in a directory.
"David" wrote:
> Hi All
> I have a customer report that I need to automatically print at the end of
> each month. What is the best way to programmatically print the report? Is
> it also possible to specify the customers so that the report gets printed for
> say all customers with a transaction in the last 30 days?
> Thanks|||I've set up subscriptions but I have to go into the server and manually print
the PDF files. I'm being told by my vendor that I have to purchase a
supplemental program that costs 13K in order to print them automatically.
Isn't there an easier way?
"Jeremy Bentvelzen" wrote:
> Hi David,
> Try adding a subscription to a file system for a report which prints all
> statements and then have a windows scheduled job which pick up the PDF and
> automatically print it. There are a number of windows script files which will
> print all PDF's in a directory.
> "David" wrote:
> > Hi All
> >
> > I have a customer report that I need to automatically print at the end of
> > each month. What is the best way to programmatically print the report? Is
> > it also possible to specify the customers so that the report gets printed for
> > say all customers with a transaction in the last 30 days?
> >
> > Thanks