all groups > sql server reporting services > march 2005 >
You're in the

sql server reporting services

group:

Generating a PostScript file from an SQL Server 2000 table


Generating a PostScript file from an SQL Server 2000 table Satish Chandrasekar
3/21/2005 9:57:02 PM
sql server reporting services:
Hi,
I need to know how to generate a PostScript file from data stored in an
SQL Server 2000 table.

This is part of my college project which requires me to generate bank
statements for customers in the form of PS files which have to be converted
to PDF files later.

Thanks,
Satish.









































































































































Re: Generating a PostScript file from an SQL Server 2000 table Andy Webb
3/22/2005 12:41:58 AM
You have to generate raw postscript? Perhaps with a DTS job. Otherwise
it's just a matter of getting the recordset you care about and looping
through it as you output postscript.

Postscript is a bit tedious, but not complicated to produce. I'm sure the
simpler it is the easier the pdf conversion will be.

"Satish Chandrasekar" <yourdisplayname@discussions.microsoft.com> wrote in
message news:1A1E7C2A-D2C6-436F-B085-AC02F506AF74@microsoft.com...
[quoted text, click to view]

Re: Generating a PostScript file from an SQL Server 2000 table Satish Chandrasekar
3/22/2005 4:09:01 AM
Hi,
Thanks for the reply. You are correct. We use DTS to map the data (in
the form of a .csv file) into the SQL Server 2000 table. We have written a
T-SQL stored procedure to perform some basic operations on the data and then
store the calculated values in another table. It is from this table that we
need to generate the PS file and then the PDF file.
We need to know the step by step procedure for generating this PS file.
Can you help us?

Thanks,
Satish.

[quoted text, click to view]
AddThis Social Bookmark Button