Solved

How to Programatically render sql .rdlc report to pdf format?

Posted on 2013-05-30
4
1,907 Views
Last Modified: 2013-06-15
Hi,
I developed .Net 3.5 web application using VS 2010. I have Sql client report(.rdlc) in the application.
How to  programatically render sql .rdlc report to pdf format?

Thanks
0
Comment
Question by:KavyaVS
  • 2
4 Comments
 
LVL 37

Assisted Solution

by:ValentinoV
ValentinoV earned 333 total points
ID: 39209988
That should be possible by consuming the ReportingExecutionService web service and then calling the Render method with the appropriate format specified.

Have a look at the examples (and function description) here, it should give you an idea: ReportExecutionService.Render Method
0
 
LVL 21

Accepted Solution

by:
Alpesh Patel earned 167 total points
ID: 39210268
rViewer.ServerReport.ReportPath = "reportPath";
            rViewer.ServerReport.ReportServerUrl = "reportserverurl";
            rViewer.ServerReport.ReportServerCredentials.NetworkCredentials = "credential;";
            rViewer.ServerReport.SetParameters();

            rViewer.ServerReport.Render("Pdf", null, out mimeType,
                    out encoding, out filenameExtension, out streamids, out warnings);
0
 
LVL 37

Assisted Solution

by:ValentinoV
ValentinoV earned 333 total points
ID: 39210320
Using the ReportViewer is indeed also an option. See here for a more complete example: ServerReport.Render Method (String, String, out String, out String, out String, out String[], out Warning[])
0
 

Author Closing Comment

by:KavyaVS
ID: 39249833
Thanks.
0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Written by Valentino Vranken. Introduction: The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source.  The data…
Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

757 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now