can to hold a pdf in sql field ? (i.e like bmp as binary)

Hi,
I understand you can hold and image in a sql server field as a binary file.
Can this same process be used to hold an actuall PDF file in a field ? (i.e
as opposed to a link).
note: i would like to display the pdf doc via and asp page.
Thanks for any advice
Scott
It is binary data, so you can hold anything you like in the column. If you don't have a PDF
displayer that can display based on data in a table, you would have to materialize the data to a
file and then use that file in your pdf displayer.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"scott" <nospam@.yahoo.com> wrote in message news:%2375LjvhsFHA.3180@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I understand you can hold and image in a sql server field as a binary file. Can this same process
> be used to hold an actuall PDF file in a field ? (i.e as opposed to a link).
> note: i would like to display the pdf doc via and asp page.
> Thanks for any advice
> Scott
>
|||Hi
A PDF would need to be an image data type. It is in effect is a binary data
type.
You need to write code using Getchunk and Appendchunk.
http://support.microsoft.com/default...b;en-us;194975
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"scott" wrote:

> Hi,
> I understand you can hold and image in a sql server field as a binary file.
> Can this same process be used to hold an actuall PDF file in a field ? (i.e
> as opposed to a link).
> note: i would like to display the pdf doc via and asp page.
> Thanks for any advice
> Scott
>
>
|||thanks
scott

can to hold a pdf in sql field ? (i.e like bmp as binary)

Hi,
I understand you can hold and image in a sql server field as a binary file.
Can this same process be used to hold an actuall PDF file in a field ? (i.e
as opposed to a link).
note: i would like to display the pdf doc via and asp page.
Thanks for any advice
ScottIt is binary data, so you can hold anything you like in the column. If you don't have a PDF
displayer that can display based on data in a table, you would have to materialize the data to a
file and then use that file in your pdf displayer.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"scott" <nospam@.yahoo.com> wrote in message news:%2375LjvhsFHA.3180@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I understand you can hold and image in a sql server field as a binary file. Can this same process
> be used to hold an actuall PDF file in a field ? (i.e as opposed to a link).
> note: i would like to display the pdf doc via and asp page.
> Thanks for any advice
> Scott
>|||Hi
A PDF would need to be an image data type. It is in effect is a binary data
type.
You need to write code using Getchunk and Appendchunk.
http://support.microsoft.com/default.aspx?scid=kb;en-us;194975
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"scott" wrote:
> Hi,
> I understand you can hold and image in a sql server field as a binary file.
> Can this same process be used to hold an actuall PDF file in a field ? (i.e
> as opposed to a link).
> note: i would like to display the pdf doc via and asp page.
> Thanks for any advice
> Scott
>
>|||thanks
scott

can to hold a pdf in sql field ? (i.e like bmp as binary)

Hi,
I understand you can hold and image in a sql server field as a binary file.
Can this same process be used to hold an actuall PDF file in a field ? (i.e
as opposed to a link).
note: i would like to display the pdf doc via and asp page.
Thanks for any advice
ScottIt is binary data, so you can hold anything you like in the column. If you d
on't have a PDF
displayer that can display based on data in a table, you would have to mater
ialize the data to a
file and then use that file in your pdf displayer.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"scott" <nospam@.yahoo.com> wrote in message news:%2375LjvhsFHA.3180@.TK2MSFTNGP10.phx.gbl...[
vbcol=seagreen]
> Hi,
> I understand you can hold and image in a sql server field as a binary file
. Can this same process
> be used to hold an actuall PDF file in a field ? (i.e as opposed to a lin
k).
> note: i would like to display the pdf doc via and asp page.
> Thanks for any advice
> Scott
>[/vbcol]|||Hi
A PDF would need to be an image data type. It is in effect is a binary data
type.
You need to write code using Getchunk and Appendchunk.
http://support.microsoft.com/defaul...kb;en-us;194975
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"scott" wrote:

> Hi,
> I understand you can hold and image in a sql server field as a binary file
.
> Can this same process be used to hold an actuall PDF file in a field ? (i
.e
> as opposed to a link).
> note: i would like to display the pdf doc via and asp page.
> Thanks for any advice
> Scott
>
>|||thanks
scott

Can this be done in the reporting services (SQL 2005)

Based on the data in the SQL server table (Customers address table) I
want to print letters (with individual customers address) as a pdf
file?
This is similar to Form Letters in Word document and use mail merge but
my requirements is letters needed as a pdf file and the whole process
should be an automated scheduled task?I thing that you would be better served looking at using Word, form letters,
and getting a PDF print driver. And of course, you can automate Word on a
scheduled basis using either VBA or VB/C# .NET code.
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"c_shah" <shah.chirag@.netzero.net> wrote in message
news:1165090517.937723.144090@.16g2000cwy.googlegroups.com...
> Based on the data in the SQL server table (Customers address table) I
> want to print letters (with individual customers address) as a pdf
> file?
> This is similar to Form Letters in Word document and use mail merge but
> my requirements is letters needed as a pdf file and the whole process
> should be an automated scheduled task?
>|||Thank you.

Can ReportViewer save report to another format?

Now Report Viewer can save report to xml and pdf format.

Can it save report to another format? e.g word, text

This depends on availability of renderers.
Currently no, in future versions - yes, likely

|||

yes it's possible, however you have to write your own report renderer. Please read this link http://msdn.microsoft.com/msdnmag/issues/05/02/CustomRenderers/ for more info.