Solved

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

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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

User art_snob (http://www.experts-exchange.com/M_6114203.html) encountered strange behavior of Android Web browser on his Mobile Web site. It took a while to find the true cause. It happens so, that the Android Web browser (at least up to OS ver. 2.…
It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

785 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