Click here to Skip to main content
15,920,111 members
Home / Discussions / C#
   

C#

 
QuestionHow to print an SSRS Report in PDF Format from my asp.net page Pin
Vinay Meka11-Dec-12 18:04
Vinay Meka11-Dec-12 18:04 
Hi guys.,
I had an grid view where i had placed an link button to print an report.In this button click event i need to call the SSRS report and need to get the output as pdf file.
I had used this below code,the code is running fine,but i'm unable to see the prompt to open/save pdf file.Plz reply ASAP.


C#
protected void btnAuthenticateAndPrint_Click(object sender, EventArgs args)
    {
        try
        {
            
            //Getting Values from grid
            LinkButton lb = (LinkButton)sender;
            GridViewRow row = (GridViewRow)lb.NamingContainer;
            Label lbOrderID = row.FindControl("lbOrderID") as Label;
            int OrderId = Convert.ToInt32(lbOrderID.Text);
            da = new SqlDataAdapter("Get_PODetails", con);
            da.SelectCommand.CommandType = CommandType.StoredProcedure;
            da.SelectCommand.Parameters.AddWithValue("@MPDI_ID", OrderId);
            ds = new DataSet();
            da.Fill(ds, "PO");
            if (ds.Tables["PO"].Rows.Count > 0)
            {
                lblPOId.Text=ds.Tables["PO"].Rows[0]["MPDI_ID"].ToString();
                lblVendid.Text = ds.Tables["PO"].Rows[0]["MVDI_ID"].ToString();
                lblBranch.Text = ds.Tables["PO"].Rows[0]["MBRI_ID"].ToString();
                lblDate.Text = Convert.ToDateTime(ds.Tables["PO"].Rows[0]["MPDI_Date"]).ToString("dd-MM-yyyy");
            }
 
            //SSRS Report Print
            rs = new RSWebService.ReportingService2005();
            rsExec = new REWebService.ReportExecutionService();
            rs.Credentials = System.Net.CredentialCache.DefaultCredentials;
            rsExec.Credentials = System.Net.CredentialCache.DefaultCredentials;
            rs.Url = "http://localhost/ReportServer/ReportService2005.asmx";
            rsExec.Url = "http://localhost/ReportServer/ReportExecution2005.asmx";
            byte[] Sendresults = null;
            byte[] bytes = null;
            string historyID = null;
            string deviceInfo = @"<DeviceInfo><Toolbar>False</Toolbar></DeviceInfo>";
            string format = "PDF";
            string encoding = null;
            string mimeType = null;
            string extension = null;
            REWebService.Warning[] warnings = null;
            string[] streamIDs = null;
            string _reportName = @"/FIMO GOF Assets Reports/PURCHASE ORDER";
            REWebService.ExecutionInfo ei = rsExec.LoadReport(_reportName, historyID);
            REWebService.ParameterValue[] parameters = new REWebService.ParameterValue[4];
            parameters[0] = new REWebService.ParameterValue();
            parameters[0].Name = "MVDI_ID";
            parameters[0].Value = lblVendid.Text;
            parameters[1] = new REWebService.ParameterValue();
            parameters[1].Name = "MBRI_ID";
            parameters[1].Value = lblBranch.Text;
            parameters[2] = new REWebService.ParameterValue();
            parameters[2].Name = "MPDI_Date";
            parameters[2].Value = lblDate.Text;
            parameters[3] = new REWebService.ParameterValue();
            parameters[3].Name = "ReportParameter1";
            parameters[3].Value = lblPOId.Text;
            rsExec.SetExecutionParameters(parameters, "en-us");
            Sendresults = rsExec.Render(format, deviceInfo, out extension, out encoding, out mimeType, out warnings, out streamIDs);
            MemoryStream ms = new MemoryStream(Sendresults);
 

            //To create a PDF
if (format == "PDF")
            {
                Response.ContentType = "application/pdf";
                Response.AddHeader("Content-disposition", "inline;filename=output.pdf");
                Response.AddHeader("Content-Length", Sendresults.Length.ToString());
            }
            Response.OutputStream.Write(Sendresults, 0, Sendresults.Length);
            Response.OutputStream.Flush();
            Response.OutputStream.Close();
 
        }
        catch(Exception Ex)
        {
            throw Ex;
        }
    }

AnswerRe: How to print an SSRS Report in PDF Format from my asp.net page Pin
Richard Deeming12-Dec-12 1:42
mveRichard Deeming12-Dec-12 1:42 
Questionadd labels to an image at different zoom levels Pin
vr99999999911-Dec-12 18:03
vr99999999911-Dec-12 18:03 
AnswerRe: add labels to an image at different zoom levels Pin
Pete O'Hanlon11-Dec-12 20:17
mvePete O'Hanlon11-Dec-12 20:17 
GeneralRe: add labels to an image at different zoom levels Pin
vr99999999911-Dec-12 20:28
vr99999999911-Dec-12 20:28 
GeneralRe: add labels to an image at different zoom levels Pin
Pete O'Hanlon11-Dec-12 20:34
mvePete O'Hanlon11-Dec-12 20:34 
GeneralRe: add labels to an image at different zoom levels Pin
vr99999999911-Dec-12 20:41
vr99999999911-Dec-12 20:41 
Questionhello friend :) Pin
youshy11-Dec-12 7:38
youshy11-Dec-12 7:38 
AnswerRe: hello friend :) Pin
fjdiewornncalwe11-Dec-12 8:03
professionalfjdiewornncalwe11-Dec-12 8:03 
GeneralRe: hello friend :) Pin
youshy11-Dec-12 8:48
youshy11-Dec-12 8:48 
SuggestionRe: hello friend :) Pin
youshy11-Dec-12 9:07
youshy11-Dec-12 9:07 
AnswerRe: hello friend :) Pin
fjdiewornncalwe11-Dec-12 10:34
professionalfjdiewornncalwe11-Dec-12 10:34 
AnswerRe: hello friend :) Pin
Pete O'Hanlon11-Dec-12 8:22
mvePete O'Hanlon11-Dec-12 8:22 
GeneralRe: hello friend :) Pin
youshy11-Dec-12 9:12
youshy11-Dec-12 9:12 
GeneralMessage Removed Pin
12-Dec-12 2:50
professionalN_tro_P12-Dec-12 2:50 
GeneralRe: hello friend :) Pin
Pete O'Hanlon12-Dec-12 2:53
mvePete O'Hanlon12-Dec-12 2:53 
QuestionBest way to do this? Pin
SledgeHammer0111-Dec-12 4:55
SledgeHammer0111-Dec-12 4:55 
AnswerRe: Best way to do this? Pin
Gerry Schmitz11-Dec-12 12:28
mveGerry Schmitz11-Dec-12 12:28 
GeneralRe: Best way to do this? Pin
SledgeHammer0111-Dec-12 13:21
SledgeHammer0111-Dec-12 13:21 
GeneralRe: Best way to do this? Pin
Gerry Schmitz11-Dec-12 14:05
mveGerry Schmitz11-Dec-12 14:05 
GeneralRe: Best way to do this? Pin
SledgeHammer0111-Dec-12 14:25
SledgeHammer0111-Dec-12 14:25 
Questiondevelop code project functionality(view forums/questions) in codeproject like steps View Pin
Firoz(Pappu)11-Dec-12 3:40
Firoz(Pappu)11-Dec-12 3:40 
AnswerRe: develop code project functionality(view forums/questions) in codeproject like steps View Pin
Richard MacCutchan11-Dec-12 5:00
mveRichard MacCutchan11-Dec-12 5:00 
GeneralRe: develop code project functionality(view forums/questions) in codeproject like steps View Pin
Firoz(Pappu)11-Dec-12 5:37
Firoz(Pappu)11-Dec-12 5:37 
GeneralRe: develop code project functionality(view forums/questions) in codeproject like steps View Pin
Pete O'Hanlon11-Dec-12 6:01
mvePete O'Hanlon11-Dec-12 6:01 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.