How to print an SSRS Report in PDF Format from my asp.net page

[Vinay Meka]

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.

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

[Lost User]

Don't crosspost, choose one forum and stick to it.

One of these days I'm going to think of a really clever signature.