Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Render SQL Report as PDF

Posted on 2007-08-08
7
Medium Priority
?
821 Views
Last Modified: 2013-12-17
I have developed a SQL Report and would like to have it render as a PDF rather than using the SQL Reporting control.  From my reading this is built into SQL Reporting but none of the stuff I have read says how to actually do it.  I am calling the report from ASP.NET and will be passing some dynamic parameters to the report (once I figure that out).  How do I get it to render as a PDF?
0
Comment
Question by:SkipFire
  • 4
  • 3
7 Comments
 
LVL 4

Expert Comment

by:Nazermohideeen
ID: 19655936
There are PDF API for that, which is the proper way to export to PDF.

But a easier way is to create to create a Crystal report and export that report to PDF. You can do that using .net code itself, so the user will not even realise that you used crystal reports.

NM
0
 
LVL 4

Author Comment

by:SkipFire
ID: 19655981
Crystal is not an option and I would never use it anyway.  The initial preference was Active Reports but the client prefers that we use SQL Reporting.

I knew there was an interface to create the PDF, but I don't know any specifics of what the API is or how to do it.
0
 
LVL 4

Expert Comment

by:Nazermohideeen
ID: 19656134
http://www.primopdf.com/primopdf_api.aspx

what is the reason for you to avoid crystal reports anyway?

NM
0
Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

 
LVL 4

Expert Comment

by:Nazermohideeen
ID: 19656152
U can try these as well.

http://www.bullzip.com/products/pdf/info.php

It is like printing to a printer..... but the output would be a PDF file.

NM
0
 
LVL 4

Author Comment

by:SkipFire
ID: 19656300
I never use Crystal because of the licensing costs, they are rather prohibitive for most of my customers.

Printing to a printer is not an option, this needs to render to the client as a PDF.  This functionality is available internal to SQL Reporting, I just don't know how to access and control it.
0
 
LVL 4

Accepted Solution

by:
Nazermohideeen earned 1500 total points
ID: 19656383
0
 
LVL 4

Author Comment

by:SkipFire
ID: 19661126
The only problem is that everything comes out collapsed.  I did decide to show the user the SQL report viewer and managed to convince them that it is the better way to go so now I don't even need the PDF output.
0

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex. A simple solution to parsing a customized CSV fi…
Simulator games are perfect for generating sample realistic data streams, especially for learning data analysis. It is even useful for demoing offerings such as Azure stream analytics, PowerBI etc.
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question