ReportViewer rptExcel = new ReportViewer();
        private void fnDataIni()
        {
            this.rptExcel.LocalReport.ReportEmbeddedResource = "RDLCInExcel.LinqRpt.rdlc";
            Excel.Range range = this.Range["B4", "J22"];
            this.Controls.AddControl(this.rptExcel, range, "rptInExcel");

            NorthwindDataContext ctx = new NorthwindDataContext();
            var result = from c in ctx.Customers
                         select c.Country;
            foreach (string list in result.Distinct<string>().ToList<string>())
            {
                this.comCountry.Items.Add(list);
            }
        }

        private void fnBuildDataSource(string v_strCountry)
        {
            NorthwindDataContext ctx = new NorthwindDataContext();
            var datasource = from c in ctx.sp_LinqTest(v_strCountry)
                             orderby c.CustomerID
                             select c;

            ReportParameter rpCountry = new ReportParameter("p_Country", v_strCountry);
            this.rptExcel.LocalReport.SetParameters(new ReportParameter[] { rpCountry });
            this.rptExcel.LocalReport.DataSources.Add(new ReportDataSource("sp_LinqTestResult", datasource.ToList()));
            this.rptExcel.RefreshReport();
        }

        private void Sheet1_Startup(object sender, System.EventArgs e)
        {
            this.fnDataIni();
            this.fnBuildDataSource(this.comCountry.Text);
        }

        private void Sheet1_Shutdown(object sender, System.EventArgs e)
        {
        }

        #region VSTO Designer generated code

        /// <summary>
        /// Required method for Designer support - do not modify
        /// the contents of this method with the code editor.
        /// </summary>
        private void InternalStartup()
        {
            this.comCountry.SelectedIndexChanged += new System.EventHandler(this.comCountry_SelectedIndexChanged);
            this.Startup += new System.EventHandler(this.Sheet1_Startup);
            this.Shutdown += new System.EventHandler(this.Sheet1_Shutdown);

        }

        #endregion

        private void comCountry_SelectedIndexChanged(object sender, EventArgs e)
        {
            this.rptExcel.LocalReport.DataSources.Clear();
            this.fnBuildDataSource(this.comCountry.Text);
        }