code behind لل crystal report viewer

قد يفي\ك هذا الكود

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using CrystalDecisions.Shared;
using CrystalDecisions.CrystalReports.Engine;
using System.Data.SqlClient;
using System.Configuration;

       try
        {
            ReportDocument crRep = new ReportDocument();
            crRep.Load(Server.MapPath("Report_File_Name.rpt"));

            SqlConnectionStringBuilder csbDb = new SqlConnectionStringBuilder(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString());
            Tables crTables;
            TableLogOnInfo crTableLogOnInfo;
            ConnectionInfo crConnectionInfo = new ConnectionInfo();
            crConnectionInfo.ServerName = csbDb.DataSource.ToString();
            crConnectionInfo.DatabaseName = csbDb.InitialCatalog.ToString();
            crConnectionInfo.UserID = csbDb.UserID.ToString();
            crConnectionInfo.Password = csbDb.Password.ToString();
            crTables = crRep.Database.Tables;
            foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in crTables)
            {
                string x = crTable.Name;
                crTableLogOnInfo = crTable.LogOnInfo;
                crTableLogOnInfo.ConnectionInfo = crConnectionInfo;
                crTable.ApplyLogOnInfo(crTableLogOnInfo);
            }

                crRep.SetParameterValue("@pnSocialGovernorateCode", Session["Report_Parameter1"].ToString());

                crRep.SetParameterValue("@pnSocialDepartCode",Session["Report_Parameter2"].ToString());

            // Export
            ExportOptions oExportOptions = new ExportOptions();
            oExportOptions.ExportFormatType = CrystalDecisions.Shared.ExportFormatType.PortableDocFormat;

            crRep.ExportToHttpResponse(oExportOptions, Response, false, "export");

            Response.ClearContent();
            Response.ClearHeaders();
            Response.ContentType = "text/richtext";
            Response.Flush();
            Response.Close();

            crRep.Close();
            crRep.Dispose();
        }
        catch (Exception EX) { Label1.Text = EX.Message.ToString(); }
    }

تم نقل الموضوع لمنتدي Crystal Reports

==========

اتمني ان يفيدك هذا الرابط

تمرير الباراميترات لتقارير الكريستال ريبورت