private void CreateReportFile(string argument)
        {
            SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["MSSQLConnection"].ConnectionString);
            SqlDataAdapter da = new SqlDataAdapter();
            string cmdText = "select * from QuarterlyCheckReportsHeader where Id = @ReportId";
            SqlCommand SelectCommand = new SqlCommand(cmdText, connection);
            SelectCommand.CommandType = CommandType.Text;
            SelectCommand.CommandTimeout = int.MaxValue;
            SqlParameter tvpParam = SelectCommand.Parameters.AddWithValue("ReportId", argument);
            tvpParam.SqlDbType = SqlDbType.Int;
            da.SelectCommand = SelectCommand;
            System.Data.DataSet ds = new System.Data.DataSet();
            connection.Open();
            da.Fill(ds);

            System.Data.DataTable param_dt = new System.Data.DataTable();
            param_dt.Columns.Add("Id", System.Type.GetType("System.Int32"));
            param_dt.Columns.Add("DateReport", System.Type.GetType("System.DateTime"));
            param_dt.Columns.Add("N1", System.Type.GetType("System.String"));
            param_dt.Columns.Add("N2", System.Type.GetType("System.String"));
            param_dt.Columns.Add("N3", System.Type.GetType("System.String"));
            param_dt.Columns.Add("N4", System.Type.GetType("System.String"));
            param_dt.Columns.Add("N5", System.Type.GetType("System.String"));
            param_dt.Columns.Add("N6", System.Type.GetType("System.String"));
            param_dt.Columns.Add("N7", System.Type.GetType("System.String"));
            param_dt.Columns.Add("N8", System.Type.GetType("System.String"));
            param_dt.Columns.Add("N9", System.Type.GetType("System.String"));
            param_dt.Columns.Add("N10", System.Type.GetType("System.String"));
            param_dt.Columns.Add("N11", System.Type.GetType("System.String"));
            param_dt.Columns.Add("N12", System.Type.GetType("System.String"));
            param_dt.Columns.Add("N13", System.Type.GetType("System.String"));
            param_dt.Columns.Add("N14", System.Type.GetType("System.String"));
            param_dt.Columns.Add("N15", System.Type.GetType("System.String"));
            param_dt.Columns.Add("N16", System.Type.GetType("System.String"));
            param_dt.Columns.Add("Id_Load", System.Type.GetType("System.String"));
            param_dt.Columns.Add("Id_PROMU", System.Type.GetType("System.String"));
            param_dt.Columns.Add("Id_MVK", System.Type.GetType("System.String"));

            System.Data.DataRow dr = null;
            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                dr = param_dt.NewRow();
                dr.ItemArray = ds.Tables[0].Rows[i].ItemArray;
                param_dt.Rows.Add(dr);
            }

            connection.Close();

            rvView.Reset();
            rvView.ProcessingMode = ProcessingMode.Local;
            rvView.LocalReport.DataSources.Clear();
            rvView.LocalReport.ReportPath = @"Reports\Report.rdlc";
            rvView.LocalReport.SubreportProcessing += new SubreportProcessingEventHandler(SubreportProcessingEventHandler);

            ReportDataSource datasource = new ReportDataSource("DataSet", param_dt as System.Data.DataTable);
            datasource.Name = "DataSet1";
            datasource.Value = param_dt;
            rvView.LocalReport.DataSources.Add(datasource);
            ReportParameter p1 = new ReportParameter("ReportParameter1", argument);
            rvView.LocalReport.SetParameters(p1);
            byte[] reportBytes = rvView.LocalReport.Render("Excel");

            string sRootFileName = "Отчет о результатах проведения квартальной проверки - ";
            string sFileName = "~/" + sRootFileName + DateTime.Now.ToString("dd.MM.yyyy") + ".xls";
            sFileName = System.Environment.MachineName == "INTCONTROL-P" ? sFileName.Replace(@"~/", @"C:\Windows\Temp\") : Server.MapPath(sFileName);  // INTCONTROL-P
            using (FileStream stream = File.OpenWrite(sFileName)) /*Server.MapPath(sFileName)*/
                stream.Write(reportBytes, 0, reportBytes.Length);

            // открыть файл и изменить область печати.
            Microsoft.Office.Interop.Excel.Application ExcelObj = null;
            Microsoft.Office.Interop.Excel.Workbooks Workbooks = null;
            Microsoft.Office.Interop.Excel.Worksheet Worksheet = null;
            Microsoft.Office.Interop.Excel.Workbook Workbook = null;
            Microsoft.Office.Interop.Excel.Sheets Sheets = null;

            try
            {
                ExcelObj = new Microsoft.Office.Interop.Excel.Application();
                Workbooks = ExcelObj.Workbooks;
                ExcelObj.DisplayAlerts = false;
                ExcelObj.Visible = false; // <-для отладки поставить в visible
                string FileName = System.Environment.MachineName == "INTCONTROL-P" ? sFileName.Replace(@"~/", @"C:\Windows\Temp\") : sFileName;

                Workbook = Workbooks.Open(FileName, 0, false, 5, "", "", true, XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);
                Sheets = Workbook.Worksheets;
                Worksheet = (Worksheet)Sheets.get_Item(1);

                Worksheet.Columns["A:A"].ColumnWidth = 5.29;
                Worksheet.Columns["B:B"].ColumnWidth = 5;
                Worksheet.Columns["C:C"].ColumnWidth = 8.43;
                Worksheet.Columns["D:D"].ColumnWidth = 12.71;
                Worksheet.Columns["E:E"].ColumnWidth = 27.29;
                Worksheet.Columns["F:F"].ColumnWidth = 7;
                Worksheet.Columns["G:G"].ColumnWidth = 7.43;
                Worksheet.Columns["H:H"].ColumnWidth = 7;
                Worksheet.Columns["I:I"].ColumnWidth = 7.86;
                Worksheet.Columns["J:J"].ColumnWidth = 7;
                Worksheet.Columns["K:K"].ColumnWidth = 7;
                Worksheet.Rows["1:1"].RowHeight = 15.75;
                Worksheet.Rows["2:2"].RowHeight = 48;
                Worksheet.Rows["3:3"].RowHeight = 15;
                Worksheet.Rows["4:4"].RowHeight = 15.75;
                Worksheet.Rows["5:5"].RowHeight = 15;
                Worksheet.Rows["6:6"].RowHeight = 15.75;
                Worksheet.Rows["7:7"].RowHeight = 30;
                Worksheet.Rows["8:8"].RowHeight = 42.75;
                Worksheet.Rows["9:9"].RowHeight = 43.5;
                Worksheet.Rows["10:10"].RowHeight = 15;
                Worksheet.Rows["11:11"].RowHeight = 15;
                Worksheet.Rows["12:12"].RowHeight = 29.25;
                Worksheet.Rows["13:13"].RowHeight = 28.5;
                Worksheet.Rows["14:14"].RowHeight = 28.5;
                Worksheet.Rows["15:15"].RowHeight = 15;
                Worksheet.Rows["16:16"].RowHeight = 15.75;
                Worksheet.Rows["17:17"].RowHeight = 30.75;
                Worksheet.Rows["18:18"].RowHeight = 34.5;
                Worksheet.Rows["19:19"].RowHeight = 34.5;
                Worksheet.Rows["20:20"].RowHeight = 28.25;
                Worksheet.Rows["21:21"].RowHeight = 28.25;
                Worksheet.Rows["22:22"].RowHeight = 34.5;
                Worksheet.Rows["23:23"].RowHeight = 28.25;
                Worksheet.Rows["24:24"].RowHeight = 28.25;
                Worksheet.Rows["25:25"].RowHeight = 15;
                Worksheet.Rows["26:26"].RowHeight = 15.75;
                Worksheet.Rows["27:27"].RowHeight = 30.75;
                Worksheet.Rows["28:28"].RowHeight = 15;
                Worksheet.Rows["29:29"].RowHeight = 15.75;
                Worksheet.Rows["30:30"].RowHeight = 55.5;
                Worksheet.Rows["31:31"].RowHeight = 44.25;
                Worksheet.Rows["32:32"].RowHeight = 15;
                Worksheet.Rows["33:33"].RowHeight = 15.75;
                Worksheet.Rows["34:34"].RowHeight = 43.5;
                Worksheet.Rows["35:35"].RowHeight = 15;
                Worksheet.Rows["36:36"].RowHeight = 15;
                Worksheet.Rows["37:37"].RowHeight = 15.75;
                Worksheet.Rows["38:38"].RowHeight = 15;
 
                Worksheet.Range["B1:K1"].Font.Bold = true;
                Worksheet.Range["B2:K2"].Font.Bold = true;
                Worksheet.Range["B4"].Font.Bold = true;
                Worksheet.Range["B6"].Font.Bold = true;
                Worksheet.Range["B11"].Font.Bold = true;
                Worksheet.Range["B16"].Font.Bold = true;
                Worksheet.Range["F17:G17"].Font.Bold = true;
                Worksheet.Range["H17:I17"].Font.Bold = true;
                Worksheet.Range["J17:K17"].Font.Bold = true;
                Worksheet.Range["B19:E19"].Font.Bold = true;
                Worksheet.Range["F18:K19"].Font.Bold = true;
                Worksheet.Range["F19:K19"].Font.Bold = true;
                Worksheet.Range["B22:K22"].Font.Bold = true;
                Worksheet.Range["B26"].Font.Bold = true;
                Worksheet.Range["B29"].Font.Bold = true;
                Worksheet.Range["B33"].Font.Bold = true;
                Worksheet.Range["B37"].Font.Bold = true;

                // убираем границы ячеек и отрисовываем границы там, где нам надо
                ExcelObj.Cells.Select();
                ClearCellsBorders(ExcelObj);
                PlaceBottomBorders(Worksheet.Range["B17:K17"], ExcelObj);
                PlaceBottomBorders(Worksheet.Range["B18:K18"], ExcelObj);
                PlaceBottomBorders(Worksheet.Range["B19:K19"], ExcelObj);
                PlaceBottomBorders(Worksheet.Range["B20:K20"], ExcelObj);
                PlaceBottomBorders(Worksheet.Range["B21:K21"], ExcelObj);
                PlaceBottomBorders(Worksheet.Range["B22:K22"], ExcelObj);
                PlaceBottomBorders(Worksheet.Range["B23:K23"], ExcelObj);
                PlaceBottomBorders(Worksheet.Range["B24:K24"], ExcelObj);

                Sheets[1].Select();
                ExcelObj.ActiveWindow.View = XlWindowView.xlPageBreakPreview;
                Worksheet = (Worksheet)ExcelObj.ActiveSheet;
                Worksheet.VPageBreaks[1].DragOff(XlDirection.xlToRight, 1);
                Worksheet.HPageBreaks[1].DragOff(XlDirection.xlDown, 1);
                ExcelObj.ActiveWindow.Zoom = 100;

                Sheets[2].Select();
                ExcelObj.ActiveWindow.View = XlWindowView.xlPageBreakPreview;
                Worksheet = (Worksheet)ExcelObj.ActiveSheet;
                Worksheet.Rows["1:1"].RowHeight = 15.75;
                Worksheet.Rows["2:2"].RowHeight = 15;
                Worksheet.Rows["3:3"].RowHeight = 15;
                Worksheet.Rows["4:4"].RowHeight = 15;
                Worksheet.Rows["5:5"].RowHeight = 15;
                Worksheet.Rows["6:6"].RowHeight = 15;
                Worksheet.Rows["7:7"].RowHeight = 28.5;
 
                Worksheet.Columns["A:A"].ColumnWidth = 12.57;
                Worksheet.Columns["B:B"].ColumnWidth = 11;
                Worksheet.Columns["C:C"].ColumnWidth = 40;
                Worksheet.Columns["D:D"].ColumnWidth = 12;
                Worksheet.Columns["E:E"].ColumnWidth = 40;
                Worksheet.Columns["F:F"].ColumnWidth = 8.43;
                Worksheet.Columns["G:G"].ColumnWidth = 8.43;
                Worksheet.Columns["H:H"].ColumnWidth = 10.29;
                Worksheet.Columns["I:I"].ColumnWidth = 40;
                Worksheet.Columns["J:J"].ColumnWidth = 14.57;
                Worksheet.Columns["K:K"].ColumnWidth = 18;
 
                Worksheet.VPageBreaks[1].DragOff(XlDirection.xlToRight, 1);
                ExcelObj.ActiveWindow.Zoom = 100;

                Worksheet.Range["A1:K6"].Select();
                ClearCellsBorders(ExcelObj);

                Worksheet.PageSetup.Zoom = false;
                Worksheet.PageSetup.Orientation = XlPageOrientation.xlLandscape;
                Worksheet.PageSetup.FitToPagesWide = 1;
                Worksheet.PageSetup.FitToPagesTall = 1;

                Worksheet.Range["A1:K1"].Select();
                Sheets[1].Select();
                Worksheet = (Worksheet)ExcelObj.ActiveSheet;
                Worksheet.Range["A1"].Select();
                Workbook.Save();
            }
            finally
            {
                Workbook.Close(0);
                ExcelObj.Quit();
                Marshal.ReleaseComObject(Sheets);
                Marshal.ReleaseComObject(Worksheet);
                Marshal.ReleaseComObject(Workbooks);
                Marshal.ReleaseComObject(Workbook);
                Marshal.ReleaseComObject(ExcelObj);
 
                Workbooks = null;
                Workbook = null;
                Sheets = null;
                Worksheet = null;
                ExcelObj = null;
            }

            string FilePathForDelete = System.Environment.MachineName == "INTCONTROL-P" ? sFileName.Replace(@"~/", @"C:\Windows\Temp\") : sFileName;
            try
            {
                FileInfo file = new FileInfo(FilePathForDelete);
                Response.Clear();
                Response.AddHeader("Content-Disposition", "attachment; filename=" + Server.UrlPathEncode(file.Name));
                Response.AddHeader("Content-Length", file.Length.ToString());
                Response.ContentType = "application/zip";
                Response.WriteFile(file.FullName);
                Response.Flush();
                Response.End();
            }
            finally
            {
                File.Delete(FilePathForDelete);
            }
        }