private void Print_Load(object sender, EventArgs e)
{
this.Visible = false;
dsPrint ds = new dsPrint();
DataRow dataRow = reportDataSet.Rows[0];
DataRow dr = ds.DTPrint.NewRow();
dr["BarCode"] = dataRow["BarCode"];
dr["Mode"] = dataRow["Mode"];
dr["TestNo"] = dataRow["TestNo"];
for (int i = 0; i < cMain.DataShow; i++)
{
dr[string.Format("Data{0}", i + 1)] = dataRow[string.Format("Data{0}", i + 1)];
dr[string.Format("DataUp{0}", i + 1)] = dataRow[string.Format("DataUp{0}", i + 1)];
dr[string.Format("DataDown{0}", i + 1)] = dataRow[string.Format("DataDown{0}", i + 1)];
}
ds.DTPrint.Rows.Add(dr);
CrystalReport1 cr1 = new CrystalReport1();
cr1.SetDataSource(ds);
crystalReportViewer1.ReportSource = cr1;
//crystalReportViewer1.PrintReport();
cr1.PrintToPrinter(1, true, 0, 0);
this.Close();
}
private void UserControl_Loaded(object sender, RoutedEventArgs e)
{
obj = new CrystalReport1();
//obj.Load(@"CrystalReport1.rpt");
//obj.SetDatabaseLogon("sa", "09107809998=");
//Report.ViewerCore.ReportSource = obj;
getReport();
}
private void lastmonth_Click(object sender, EventArgs e)
{
CrystalReport1 reporte = new CrystalReport1();
reporte.SetParameterValue("@Fecha1", DateTime.Today.AddDays(-30).ToString("MM/dd/yyyy"));
reporte.SetParameterValue("@Fecha2", DateTime.Today.ToString("MM/dd/yyyy"));
crystalReportViewer1.ReportSource = reporte;
}
private void thismonth_Click(object sender, EventArgs e)
{
CrystalReport1 reporte = new CrystalReport1();
reporte.SetParameterValue("@Fecha1", new DateTime(DateTime.Today.Year, DateTime.Today.Month, 1).ToString("MM/dd/yyyy"));
reporte.SetParameterValue("@Fecha2", DateTime.Today.ToString("MM/dd/yyyy"));
crystalReportViewer1.ReportSource = reporte;
}
private void frmReportDoanhThuSanPham_Load(object sender, EventArgs e)
{
CrystalReport1 cry = new CrystalReport1();
DataTable table = new DataTable();
table = SanPham_BUS.getDoanhThuLoaiSP();
cry.SetDataSource(table);
crystalReportViewer1.ReportSource = cry;
}
private void comboBox2_SelectionChangeCommitted(object sender, EventArgs e)//filtrado de jugadores
{
Reortes servicios = new Reortes();
Jugadores datos = servicios.FiltrarJugadores(Convert.ToInt32(comboBox2.SelectedValue));
CrystalReport1 report = new CrystalReport1();
report.SetDataSource(datos);
crystalReportViewer1.ReportSource = report;
}
private void frmReportes_Load(object sender, EventArgs e) // cargar reporte al iniciar
{
comboLiga();
CrystalReport1 rep = new CrystalReport1();
rep.SetDataSource(reportes.CargarArticulos());
crystalReportViewer1.ReportSource = rep;
}
private void frmReport_Load(object sender, EventArgs e)
{
CrystalReport1 rep = new CrystalReport1();
rep.SetDatabaseLogon("sa", "sa2012");
crystalReportViewer1.ReportSource = rep;
crystalReportViewer1.Refresh();
rep.SetParameterValue("MaHDB", _maHD);
}
private void Anadir_Click(object sender, RoutedEventArgs e)
{
CrystalReport1 cr = new CrystalReport1();
ReportDocument cryRpt = new ReportDocument();
cryRpt.Load("CrystalReport1.rpt");
cr.Refresh();
}
private void Form2_Load(object sender, EventArgs e)
{
RST_DBDataContext db = new RST_DBDataContext();
var d = (from s in db.TblSpareParts
select new { s.SPartName, s.SPartCode, s.ModelID, s.SPartLocation, s.SPartActive, newPartSalePrice = s.SPartSalePrice == null ? 0 : s.SPartSalePrice }).ToArray();
CrystalReport1 c = new CrystalReport1();
c.SetDataSource(d);
crystalReportViewer1.ReportSource = c;
}
private void Rapor3_Load(object sender, EventArgs e)
{
SqlDataAdapter adtr = new SqlDataAdapter("select * from peryapis", con);
adtr.Fill(tablo);
CrystalReport1 rapor3 = new CrystalReport1();
rapor3.SetDataSource(tablo);
crystalReportViewer1.ReportSource = rapor3;
}
private void button1_Click(object sender, EventArgs e)
{
CrystalReport1 reporte = new CrystalReport1();
reporte.SetParameterValue("@Fecha1", Fecha1.Value.ToString("MM/dd/yyyy"));
reporte.SetParameterValue("@Fecha2", Fecha2.Value.ToString("MM/dd/yyyy"));
crystalReportViewer1.ReportSource = reporte;
Fecha1.Enabled = false;
Fecha2.Enabled = false;
button1.Enabled = false;
}
private void Rapor5_Load(object sender, EventArgs e)
{
tablo.Clear();
SqlDataAdapter adtr = new SqlDataAdapter("select * from peryasyer", con);
adtr.Fill(tablo);
CrystalReport1 rapor5 = new CrystalReport1();
rapor5.SetDataSource(tablo);
crystalReportViewer1.ReportSource = rapor5;
}
public ActionResult PrintReport()
{
CrystalReport1 rp = new CrystalReport1();
//Response.Buffer = false;
//Response.ClearContent();
//Response.ClearHeaders();
//rp.SetDatabaseLogon("Diem", "", "DESKTOP-HA2TCUF", "CoffeeShopDB", false);
Stream stream = rp.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
stream.Seek(0, SeekOrigin.Begin);
return(File(stream, "application/pdf", "CustomerList.pdf"));
}
private void Pruab()
{
DataSet dataSet = Consulta.Articulo_DataSet();
CrystalReport1 crystalReport1 = new CrystalReport1();
crystalReport1.SetDataSource(dataSet);
FormReporteVenta formReporteVenta = new FormReporteVenta();
formReporteVenta.VistaPrevia(crystalReport1);
formReporteVenta.ShowDialog();
}
private void Rapor_Load(object sender, EventArgs e)
{
tablo.Clear();
SqlDataAdapter adtr = new SqlDataAdapter("select * from aldigi_is", bag);
adtr.Fill(tablo);
CrystalReport1 rapor = new CrystalReport1();
rapor.SetDataSource(tablo);
crystalReportViewer1.ReportSource = rapor;
}
public ActionResult GenerateReport1()
{
DB50Entities db = new DB50Entities();
var c = db.Report1();
CrystalReport1 r = new CrystalReport1();
r.Load();
Stream s = r.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
return(File(s, "application/pdf"));
}
public ReporteClientes()
{
InitializeComponent();
CrystalReport1 cr = new CrystalReport1();
cr.SetDataSource(Controlador.getControlador().obtenerListaClientes());
cr.SetDatabaseLogon("user", "user");
crystalReportViewer1.ReportSource = cr;
crystalReportViewer1.Refresh();
crystalReportViewer1.Show();
}
private string GenerateReceipt(int Paymentid)
{
try
{
CrystalReport1 cr = new CrystalReport1();
//this.printDialog1.Document = this.printDocument1;
//string PrinterName = this.printDocument1.PrinterSettings.PrinterName;
// System.Drawing.Printing.PrinterSettings settings = new PrinterSettings();
string Printer = GetDefaultPrinterName();
//int i=0;
//foreach (string Printer_loopVariable in System.Drawing.Printing.PrinterSettings.InstalledPrinters)
//{
// if (i == 1)
// {
// Printer = Printer_loopVariable;
// }
// i = i + 1;
//}
//return Printer;
// if (Printer == "Error1")
// {
// return "Error1d";
// }
// else
// {
//cr.PrintOptions.PrinterName = @"\\192.168.102.81\Send To OneNote 2007";
cr.PrintOptions.PrinterName = "Thermal";
//}
// System.Drawing.Printing.PrinterSettings oPS = new System.Drawing.Printing.PrinterSettings();
//cr.PrintOptions.PrinterName = oPS.PrinterName;
payment_Prop paymentprop = new payment_Prop();
paymentprop.PaymentID = Paymentid;
payment_bal paymentbal = new payment_bal();
DataTable dt = paymentbal.PaymentSelect(paymentprop);
cr.SetDataSource(dt);
TextObject txt = (TextObject)cr.Section3.ReportObjects["txtAmtInWords"];
string AmtinWords = retWord(Convert.ToInt32(Math.Round(Convert.ToDouble(dt.Rows[0]["amount"].ToString()), 0).ToString()));
txt.Text = AmtinWords;
cr.PrintToPrinter(1, true, 1, 1);
string s = cr.PrintOptions.PrinterName.ToString();
return(s);
}
catch (Exception ex)
{
return(ex.Message);
}
}
private void FrmReporteEtiqueta_Load(object sender, EventArgs e)
{
//DataTable datos = new DataTable("CodigoDeBarra");
//datos.Columns.Add("Nombre", typeof(int));
//datos.Columns.Add("CodigoBarra", typeof(string));
//datos.Rows.Add(codigoBarra);
CrystalReport1 barra = new CrystalReport1();
barra.SetParameterValue(0, codigoBarra);
//reporte.Load("");
//reporte.SetDataSource(datos);
rvImprimirEtiqueta.ReportSource = barra;
}
private void InvoiceUI_Load(object sender, EventArgs e)
{
try
{
CrystalReport1 objRpt = new CrystalReport1();
objRpt.SetDataSource(aTempOrder);
crystalReportViewer1.ReportSource = objRpt;
crystalReportViewer1.Refresh();
}
catch (Exception exception)
{
MessageBox.Show(exception.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void CreateReport(string id)
{
string KH = (String)id;
string KHID = KH.Substring(2);
var results = (from sup1 in data.Inf_Customers
join sup2 in data.Inf_Repair on sup1.Customer_Id equals sup2.Customer_Id
join sup3 in data.Detail_Inf_Repair on sup2.Repair_Id equals sup3.Repair_Id
where sup1.Customer_Id == "KH" + KHID
select new { sup1.Customer_Name, sup1.Customer_Phone, sup2.Detail_Inf_Repair.Repair_Id, sup2.Staff_Id });
CrystalReport1 rp = new CrystalReport1();
rp.SetDataSource(results);
crystalReportViewer1.ReportSource = rp;
}
private void Reporte_Load(object sender, EventArgs e)
{
AccesoDatos datos = new AccesoDatos("Data Source = MARCOS; Initial Catalog = bd_utn_programacion; Integrated Security = True");
CrystalReport1 rpt = new CrystalReport1();
string sql;
DataTable dt = new DataTable();
sql = "select d.legajo, p.nombre, p.apellido, td.descripcion, p.num_documento, p.telefono, d.fecha_alta from docentes d join personas p on d.id_persona=p.id_persona join tipos_documentos td on td.id_tipo_doc=p.id_tipo_doc";
dt = datos.consultar(sql);
rpt.SetDataSource(dt);
crystalReportViewer1.ReportSource = rpt;
crystalReportViewer1.Refresh();
crystalReportViewer1.Show();
}
private void RaportForm_Load(object sender, EventArgs e)
{
CrystalReport1 cr = new CrystalReport1();
string sql = " SELECT * FROM RaportView WHERE DataTimpI BETWEEN '" + datastart + "'AND '" + datasfarsit + "'";
DataSet ds = new DataSet();
SqlDataAdapter adapter = new SqlDataAdapter(sql, con);
adapter.Fill(ds, "RaportView1");
cr.SetDataSource(ds.Tables["RaportView1"]);
crystalReportViewer1.ReportSource = cr;
crystalReportViewer1.Refresh();
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
CrystalReport1 rpt = new CrystalReport1();
//login
rpt.SetDatabaseLogon("proyekpcs", "proyekpcs");
ParameterDiscreteValue paramKode = new ParameterDiscreteValue();
paramKode.Value = kodeht;
rpt.SetParameterValue("kodehtrans", paramKode);
//sambungkan ke crystal report
invoice.ViewerCore.ReportSource = rpt;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Member m = (Member)Session["User"];
CrystalReport1 cr1 = new CrystalReport1();
if (m.MemberRole == 1)
{
cr1.SetDataSource(getDataForMember());
}
else if (m.MemberRole == 2)
{
cr1.SetDataSource(getDataForAdmin());
}
CrystalReportViewer1.ReportSource = cr1;
}
}
private void Button1_Click(System.Object sender, System.EventArgs e)
{
DataSet1 ds = new DataSet1();
DataRow dr = null;
dr = ds.Tables[0].NewRow();
string value = "Line 1: This is new line from DVC" + Constants.vbCrLf + "Line 2:" + Constants.vbCrLf + "Line 3:";
dr[0] = value;
ds.Tables[0].Rows.Add(dr);
ds.Tables[0].AcceptChanges();
Form2 f = new Form2();
CrystalReport1 crpt = new CrystalReport1();
crpt.SetDataSource(ds);
f.CrystalReportViewer1.ReportSource = crpt;
f.ShowDialog();
}
protected void Page_Load(object sender, EventArgs e)
{
CrystalReportViewer1.ToolPanelView = CrystalDecisions.Web.ToolPanelViewType.None;
CrystalReport1 crystalReport = new CrystalReport1();
if (Request["page"] != null && Request["page"].ToString() == "page1")
{
crystalReport.SetDataSource(SampleData.Persons.Where(r => r.PersonName.StartsWith("廖")));
}
else
{
crystalReport.SetDataSource(SampleData.Persons.Where(r => r.PersonAddress.Contains("台中市")));
}
CrystalReportViewer1.ReportSource = crystalReport;
CrystalReportViewer1.RefreshReport();
}
private void Sales_SubView_Load(object sender, EventArgs e)
{
string salesid = CodeGenerator.getLastInsertId("sales", "sales_id");
Database db = new Database();
db.openConnection();
SqlConnection conn = db.getConnection();
SqlDataAdapter sda = new SqlDataAdapter("select distinct * from sales s ,salescustomer cs,sales_items si where s.cus_id=cs.cus_id AND s.sales_id=si.sales_id AND s.sales_id ='" + salesid + "'", conn);
DataSet dst = new DataSet();
sda.Fill(dst, "sales");
CrystalReport1 cryrpt = new CrystalReport1();
cryrpt.SetDataSource(dst);
crystalReportViewer1.ReportSource = cryrpt;
db.getConnection().Close();
}
void getype()
{
SqlConnection con = new SqlConnection();
con.ConnectionString = @"Data Source=MICHAEL-PC\SQLEXPRESS;Initial Catalog=Test;Integrated Security=True";
con.Open();
string sql = "SELECT * FROM BeginningInventory";
SqlDataAdapter dscmd = new SqlDataAdapter(sql, con);
DataSet ds = new DataSet();
dscmd.Fill(ds, "BeginningInventory");
con.Close();
CrystalReport1 objRpt = new CrystalReport1();
objRpt.SetDataSource(ds.Tables["BeginningInventory"]);
crystalReportViewer1.ReportSource = objRpt;
crystalReportViewer1.Refresh();
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["user"] != null)
{
User us = (User)Session["user"];
if (us.RoleID == 1)
{
CrystalReport1 report = new CrystalReport1();
LoadReport(report);
TransactionReportViewer.ReportSource = report;
}
else
{
Response.Redirect("Home.aspx");
}
}
else
{
Response.Redirect("Home.aspx");
}
}
