<div>
Thank you ValentinoV for your valuable suggestion and we are planning to change document generation process.
</div>


Thank you ValentinoV for your valuable suggestion and we are planning to change document generation process.

<div>
Glad to have been of help, good luck with the project!
</div>


Glad to have been of help, good luck with the project!

<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
I need to create a link on &nbsp;SSRS report and when clicked opens a separate PDF/docx file.These PDF/docx files already exist and are generated by third party tool using C# in Silverlight application and we are inserting &nbsp;these docx/pdf files into sql server database table.<br />
<br />
Ex:<br />
Fields for the doc table<br />
<br />
ID &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;int<br />
NAME1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;varchar(50)<br />
NAME2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;varchar(50)<br />
NAME3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;varchar(50)<br />
Report Type &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; varchar(50)<br />
Report Doc &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;varbinary(max)<br />
<br />
Please let me know the steps involved from SSRS perspective and How can I generate document (doc/pdf ) back from binary data ?<br />
<br />
Thanks in advance
</div>
</div>


Hi Experts,

I need to create a link on  SSRS report and when clicked opens a separate PDF/docx file.These PDF/docx files already exist and are generated by third party tool using C# in Silverlight application and we are inserting  these docx/pdf files into sql server database table.

Ex:
Fields for the doc table

ID                                      int
NAME1                              varchar(50)
NAME2                              varchar(50)
NAME3                              varchar(50)
Report Type                       varchar(50)
Report Doc                        varbinary(max)

Please let me know the steps involved from SSRS perspective and How can I generate document (doc/pdf ) back from binary data ?

Thanks in advance

Link to open PDF file from SSRS Report

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.