Solved

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

Posted on 2013-05-30
4
1,918 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How to LOAD up a .NET Framework website with data? 2 39
Cannot upload files above 1mb IIS7 11 39
LINQ - C# to VB convertion 12 46
Turn on intranet settings 1 36
Today is the age of broadband.  More and more people are going this route determined to experience the web and it’s multitude of services as quickly and painlessly as possible. Coupled with the move to broadband, people are experiencing the web via …
Hi, I have heard from my friends that it’s not possible to create Label Printing report using SSRS. I am amazed after hearing this words not possible in SSRS. I googled lot and found that it is possible to some of people know about the Report Bui…
This is a video that shows how the OnPage alerts system integrates into ConnectWise, how a trigger is set, how a page is sent via the trigger, and how the SENT, DELIVERED, READ & REPLIED receipts get entered into the internal tab of the ConnectWise …
A company’s greatest vulnerability is their email. CEO fraud, ransomware and spear phishing attacks are the no1 threat to a company’s security. Cybercrime is responsible for the largest loss of money to companies today with losses projected to r…

929 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