Solved

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

Posted on 2013-05-30
4
1,973 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

ASP.Net to Oracle Connectivity Recently I had to develop an ASP.NET application connecting to an Oracle database.As I am doing it first time ,I had to solve several problems. This article will help to such developers  to develop an ASP.NET client…
A quick way to get a menu to work on our website, is using the Menu control and assign it to a web.sitemap using SiteMapDataSource. Example of web.sitemap file: (CODE) Sample code to add to the page menu: (CODE) Running the application, we wi…

739 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