private void ExecuteSPData() { //dsGLTrialC ds = new dsGLTrialC(); SqlConnection Con = new SqlConnection(clsGVar.ConString1); SqlCommand cmd = new SqlCommand(); //DataSet ds = null; SqlDataAdapter adapter; //Table Getting //SqlConnection ConLogo = new SqlConnection(clsGVar.ConString1); //SqlCommand cmdLogo = new SqlCommand("Select ID, Name, Photo From Photos where id=16", ConLogo); //SqlCommand com = new SqlCommand(flstField, con); //DataSet ds = null; //SqlDataAdapter adapterLogo; try { Con.Open(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = fStoreProcName; string[] aryField = flstField.Split(','); string[] aryType = flstType.Split(','); string[] aryValue = flstValue.Split(','); for (int i = 0; i < aryField.Length; i++) { switch (int.Parse(aryType[i])) { //sqlDBType.Int case 8: { cmd.Parameters.Add(aryField[i], SqlDbType.Int).Value = int.Parse(aryValue[i]); break; } //sqlDBType.DateTime case 4: { cmd.Parameters.Add(aryField[i], SqlDbType.DateTime).Value = DateTime.Parse(aryValue[i]); break; } //sqlDBType.Text case 18: { cmd.Parameters.Add(aryField[i], SqlDbType.Text).Value = aryValue[i]; break; } default: break; } } //DateTime = 4, //Decimal = 5, //Float = 6, //Image = 7, //Int = 8, //Money = 9, //NChar = 10, //NText = 11, //NVarChar = 12, //Real = 13, //UniqueIdentifier = 14, //SmallDateTime = 15, //SmallInt = 16, //SmallMoney = 17, //Text = 18, //cmd.Parameters.Add("@Co_ID", SqlDbType.Int).Value = 1; //cmd.Parameters.Add("@ToDate", SqlDbType.Text).Value = fToDate; //"2013-01-01"; cmd.Connection = Con; adapter = new SqlDataAdapter(cmd); //adapter.TableMappings.Add("Table", "Table"); adapter.Fill(fDs); // int cCount = fDs.Tables[1].Rows.Count; // Table 1 is used as table 0 is already present at the time of design of DataSet. //CrGLTrial rpt1 = new CrGLTrial(); // Instiantiate a report //CrBira01 rpt1 = new CrBira01(); // Instiantiate a report //rpt1.SetDataSource(ds.Tables[1]); frpt1.DataDefinition.FormulaFields["CoName"].Text = "'" + clsGVar.CoTitle1 + "'"; frpt1.DataDefinition.FormulaFields["RptTitle"].Text = "'" + fRptTitle + "'"; frpt1.DataDefinition.FormulaFields["AppUserName"].Text = "'" + clsGVar.AppUserTitle + "'"; frpt1.DataDefinition.FormulaFields["fromdate"].Text = "'" + fp + "'"; frpt1.DataDefinition.FormulaFields["ToDate"].Text = "'" + fp_2 + "'"; //frpt1.SetDataSource(fDs.Tables[1]); //frpt1.OpenSubreport("CrImage").SetDataSource(fDs.Tables[2]); // crystalReportViewer1.ToolPanelView = CrystalDecisions.Windows.Forms.ToolPanelViewType.None; crystalReportViewer1.Width = 900; crystalReportViewer1.Height = 300; // //---------------------*********** //dsPhoto ds = new dsPhoto(); //cmdLogo.Connection = ConLogo; //adapterLogo = new SqlDataAdapter(cmdLogo); //ConLogo.Open(); //SqlDataAdapter adapterLogo = new SqlDataAdapter(); //adapterLogo.SelectCommand = cmdLogo; //adapter.TableMappings.Add("table", fTableName); //adapterLogo.TableMappings.Add("table", "abctablename"); // Actual table has nothing to do with DataSet. // //adapterLogo.Fill(ds); // //---------------**************** //CrLogo rptLogo = new CrLogo(); //rptLogo.SetDataSource(ds.Tables["Photos"]); //frpt1.OpenSubreport("CrImages.rpt").SetDataSource(ds.Tables["Photos"]); //frpt1.OpenSubreport("CrBira01.rpt").SetDataSource(dsPhoto.Tables["Photos"]); //customerReport.OpenSubreport("MainSubReport.rpt").SetDataSource(dsSubReportResult.Tables["MainTableSubReportRecord"]); ; //frpt1.SetDataSource(fDs.Tables[1]); //frpt1.OpenSubreport("CrLogo.rpt").SetDataSource(fDs.Tables[2]); //frpt1.OpenSubreport("CrReceiptSub.rpt").SetDataSource(fDs.Tables[1]); //frpt1.OpenSubreport("CrPaymentSub.rpt").SetDataSource(fDs.Tables[2]); frpt1.OpenSubreport("CrMfgClose.rpt").SetDataSource(fDs.Tables[1]); frpt1.OpenSubreport("CrMfgCloseHeader.rpt").SetDataSource(fDs.Tables[1]); frpt1.OpenSubreport("CrLogo.rpt").SetDataSource(fDs.Tables[2]); frpt1.OpenSubreport("CrMfgSumSubWOOpn.rpt").SetDataSource(fDs.Tables[3]); frpt1.OpenSubreport("CrStockSumSub.rpt").SetDataSource(fDs.Tables[4]); crystalReportViewer1.ReportSource = frpt1; //crystalReportViewer1.ReportSource = rptLogo; crystalReportViewer1.Refresh(); //adapterLogo.Dispose(); //cmdLogo.Dispose(); //ConLogo.Close(); } catch (Exception ex) { throw new Exception(ex.Message); } }
public ActionResult GenerateReport(string empresa,string entidade) { ClientesDataSet dt = imprimirPdf(empresa,entidade); ReportClass objReport = new ReportClass(); objReport.FileName = Server.MapPath("/Content/Reports/ExtratoPendentes.rpt"); objReport.Load(); //objReport.SetDataSource(dt); objReport.SetDataSource(dt.Tables["Pendentes"]); objReport.Database.Tables["Pendentes"].SetDataSource(dt.Tables["Pendentes"]); objReport.Database.Tables["Clientes"].SetDataSource(dt.Tables["Clientes"]); objReport.Subreports["ContasBancarias"].SetDataSource(dt.Tables["Banco"]); objReport.OpenSubreport("Pendentes").SetDataSource(dt.Tables["Pendentes"]); objReport.DataDefinition.FormulaFields["NomeEmpresa"].Text = "'" + "Accsys" + "'"; objReport.DataDefinition.FormulaFields["MoradaEmpresa"].Text = "'" + "Maputo" + "'"; objReport.DataDefinition.FormulaFields["LocalidadeEmpresa"].Text = "'" + "Maputo" + "'"; objReport.DataDefinition.FormulaFields["TelefoneEmpresa"].Text = "'+ " + "+258" + "'"; objReport.DataDefinition.FormulaFields["NuitEmpresa"].Text = "' Nuit : " + "123456" + "'"; objReport.DataDefinition.FormulaFields["EmailEmpresa"].Text = "'" + "*****@*****.**" + "'"; //objReport.DataDefinition.FormulaFields["Ao_Cuidado_de"].Text = "' " + objectoContacto.Titulo + " " + objectoContacto.PrimeiroNome + " " + objectoContacto.UltimoNome + "'"; Stream stream = objReport.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); return File(stream, "application/pdf"); }