public void showsales(string datefrom, string dateto, string user, DataGridView dvg)
{
CTU_BARCODE_READER.REPORT.DataSet1 ds = new CTU_BARCODE_READER.REPORT.DataSet1();
DataTable dt = ds.Tables["Sales"];
txtsalesdatefrom = (TextObject)s.ReportDefinition.Sections["PageHeaderSection2"].ReportObjects["datefrom"];
txtsalesdateto = (TextObject)s.ReportDefinition.Sections["PageHeaderSection2"].ReportObjects["dateto"];
txtuser = (TextObject)s.ReportDefinition.Sections["PageHeaderSection3"].ReportObjects["txtuser"];
txtsalesdatefrom.Text = datefrom;
txtsalesdateto.Text = dateto;
txtuser.Text = user;
DataRow r;
int i = 0;
for (i = 0; i < dvg.Rows.Count; i++)
{
r = dt.NewRow();
r["Date"] = dvg.Rows[i].Cells[0].Value.ToString();
r["Description"] = dvg.Rows[i].Cells[3].Value.ToString();
r["Amount"] = dvg.Rows[i].Cells[2].Value.ToString();
dt.Rows.Add(r);
}
s.SetDataSource(ds.Tables[2]);
cr.ReportSource = s;
cr.Refresh();
f.ShowDialog();
}
public Report1(string korisnik)
{
this.korisnik = korisnik;
InitializeComponent();
CrystalReportViewer reportViewer = new CrystalReportViewer();
this.Controls.Add(reportViewer);
reportViewer.Dock = DockStyle.Fill;
if (korisnik == "iznajmljivanje")
{
var rpt = new ReportDocument();
string reportPath = @"../../../IzvjestajIznajmljivanje.rpt";
rpt.Load(reportPath);
reportViewer.ReportSource = rpt;
reportViewer.Refresh();
}
else if (korisnik == "blagajnik")
{
var rpt2 = new ReportDocument();
string reportPath2 = @"../../../FinansijskiIzvjestaj.rpt";
rpt2.Load(reportPath2);
reportViewer.ReportSource = rpt2;
reportViewer.Refresh();
}
else if (korisnik == "Knjige")
{
var rpt3 = new ReportDocument();
string reportPath3 = @"../../../PregledKnjiga.rpt";
rpt3.Load(reportPath3);
reportViewer.ReportSource = rpt3;
reportViewer.Refresh();
}
else if (korisnik == "blagajnikIzvjestaj")
{
var rpt4 = new ReportDocument();
string reportPath4 = @"../../../rptNaplataClanarine.rpt";
rpt4.Load(reportPath4);
reportViewer.ReportSource = rpt4;
reportViewer.Refresh();
}
}
private void LoadReport()
{
ReportDocument cryRpt = new ReportDocument();
cryRpt.Load(Application.StartupPath + "\\Reports\\TopMeters.rpt");
CrystalReportViewer.ReportSource = cryRpt;
CrystalReportViewer.Refresh();
}
private void btnPrintReport_Click(object sender, EventArgs e)
{
try
{
DataTable data = (DataTable)(gridReportList.DataSource);
DataTable headerTable = new DataTable("Customers");
DataColumn dtColumn;
DataRow myDataRow;
dtColumn = new DataColumn();
dtColumn.DataType = typeof(String);
dtColumn.ColumnName = "COMPANY_NAME";
headerTable.Columns.Add(dtColumn);
dtColumn = new DataColumn();
dtColumn.DataType = typeof(String);
dtColumn.ColumnName = "USER_PRINT";
headerTable.Columns.Add(dtColumn);
myDataRow = headerTable.NewRow();
myDataRow["COMPANY_NAME"] = "BIG Visitor Management";
myDataRow["USER_PRINT"] = LOGIN;
headerTable.Rows.Add(myDataRow);
ReportDocument rpt = new ReportDocument();
string path = System.Reflection.Assembly.GetExecutingAssembly().Location;
var appPath = Application.StartupPath + "\\" + "VisitorListReport.rpt";
rpt.Load(appPath);
rpt.Database.Tables[0].SetDataSource(data);
rpt.Database.Tables[1].SetDataSource(headerTable);
using (Form form = new Form())
{
CrystalReportViewer tempViewer = new CrystalReportViewer();
tempViewer.ActiveViewIndex = -1;
tempViewer.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
tempViewer.Dock = System.Windows.Forms.DockStyle.Fill;
tempViewer.Name = "tempViewer";
tempViewer.SelectionFormula = "";
tempViewer.TabIndex = 0;
tempViewer.ViewTimeSelectionFormula = "";
tempViewer.ReportSource = rpt;
tempViewer.AutoSize = true;
tempViewer.Refresh();
form.Controls.Add(tempViewer);
form.Size = this.Size;
form.StartPosition = FormStartPosition.CenterParent;
form.ShowDialog();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public override void Window_Loaded(object sender, RoutedEventArgs e)
{
this.WindowState = WindowState.Maximized;
if (articleList != null)
{
dt = GlobalFunctions.ListToDataTable(articleList);
}
if (crystalReportViewer == null || reportDocument == null)
{
return;
}
crystalReportViewer.Refresh();
reportDocument.Refresh();
reportDocument.SetDataSource(dt);
SetParameterValues();
crystalReportViewer.ReportSource = reportDocument;
crystalReportViewer.Refresh();
reportDocument.Refresh();
}
public Report(string korisnik)
{
this.korisnik = korisnik;
InitializeComponent();
CrystalReportViewer reportViewer = new CrystalReportViewer();
this.Controls.Add(reportViewer);
reportViewer.Dock = DockStyle.Fill;
if (korisnik == "iznajmljivanje")
{
var rpt = new ReportDocument();
string reportPath = @"C:\Users\vladimir.klisura\Desktop\IzvjestajIznajmljivanje.rpt";
rpt.Load(reportPath);
reportViewer.ReportSource = rpt;
reportViewer.Refresh();
}
else if (korisnik == "blagajnik")
{
var rpt2 = new ReportDocument();
string reportPath2 = @"C:\Users\vladimir.klisura\Desktop\FinansijskiIzvjestaj.rpt";
rpt2.Load(reportPath2);
reportViewer.ReportSource = rpt2;
reportViewer.Refresh();
}
else if (korisnik == "Knjige")
{
var rpt3 = new ReportDocument();
string reportPath3 = @"C:\Users\vladimir.klisura\Desktop\PregledKnjiga.rpt";
rpt3.Load(reportPath3);
reportViewer.ReportSource = rpt3;
reportViewer.Refresh();
}
}
public tstfrm1()
{
InitializeComponent();
ReportDocument rptDoc = new ReportDocument();
rptDoc.Load(@"C:\CrystalReport1.rpt");
CrystalReportViewer crystalReportViewer1 = new CrystalReportViewer();
crystalReportViewer1.ReportSource = rptDoc;
crystalReportViewer1.Refresh();
this.Controls.Add(crystalReportViewer1);
crystalReportViewer1.Dock = DockStyle.Fill;
}
public void ShowHDNoView(int ma)
{
DataTable dt = new DataTable();
if (ma == 0)
// DataSet ds = new DataSet();
dt = tXuat.GetDataHD(maHD);
else dt = tXuat.GetDataHD(ma);
// ds.Tables.Add(dt);
rptHD rpt = new rptHD();
rpt.SetDataSource(dt);
CrystalReportViewer rptview = new CrystalReportViewer();
rptview.ReportSource = rpt;
rptview.Refresh();
rptview.PrintReport();
}
public tstfrm1()
{
InitializeComponent();
ReportDocument rptDoc = new ReportDocument();
rptDoc.Load(@"C:\CrystalReport1.rpt");
/*If you have a datasource, link it like below*/
//rptDoc.SetDataSource(dataset.Tables["tripsheet"]);
CrystalReportViewer crystalReportViewer1 = new CrystalReportViewer();
crystalReportViewer1.ReportSource = rptDoc;
crystalReportViewer1.Refresh();
this.Controls.Add(crystalReportViewer1);
crystalReportViewer1.Dock = DockStyle.Fill;
}
public void ShowHDNoView(int ma)
{
DataTable dt = new DataTable();
if (ma == 0)
{
// DataSet ds = new DataSet();
dt = tXuat.GetDataHD(maHD);
}
else
{
dt = tXuat.GetDataHD(ma);
}
// ds.Tables.Add(dt);
rptHD rpt = new rptHD();
rpt.SetDataSource(dt);
CrystalReportViewer rptview = new CrystalReportViewer();
rptview.ReportSource = rpt;
rptview.Refresh();
rptview.PrintReport();
}
private void btnPrintMonth_Click(object sender, EventArgs e)
{
var timeNow = DateTime.Now;
var firstDayOfMonth = new DateTime(timeNow.Year, timeNow.Month, 1);
var lastDayOfMonth = firstDayOfMonth.AddMonths(1).AddDays(-1);
var filter = new VisitorFilter()
{
DATE_FROM = ChangeTime(firstDayOfMonth, 0, 0, 0, 1),
DATE_TO = ChangeTime(lastDayOfMonth, 23, 59, 59, 59),
};
_container.Filter = filter;
_container = _service.GetVisitorForReport(_container);
if (_container.ResultObj.Count > 0)
{
List <CustomVisitor> listData = (List <CustomVisitor>)_container.ResultObj;
DataTable dt = ConvertToDataTable(listData);
DataTable headerTable = new DataTable("Customers");
DataColumn dtColumn;
DataRow myDataRow;
dtColumn = new DataColumn();
dtColumn.DataType = typeof(String);
dtColumn.ColumnName = "COMPANY_NAME";
headerTable.Columns.Add(dtColumn);
dtColumn = new DataColumn();
dtColumn.DataType = typeof(String);
dtColumn.ColumnName = "USER_PRINT";
headerTable.Columns.Add(dtColumn);
myDataRow = headerTable.NewRow();
myDataRow["COMPANY_NAME"] = "BIG Visitor Management";
myDataRow["USER_PRINT"] = LOGIN;
headerTable.Rows.Add(myDataRow);
ReportDocument rpt = new ReportDocument();
string path = System.Reflection.Assembly.GetExecutingAssembly().Location;
var appPath = Application.StartupPath + "\\" + "VisitorListReport.rpt";
rpt.Load(appPath);
rpt.Database.Tables[0].SetDataSource(dt);
rpt.Database.Tables[1].SetDataSource(headerTable);
using (Form form = new Form())
{
CrystalReportViewer tempViewer = new CrystalReportViewer();
tempViewer.ActiveViewIndex = -1;
tempViewer.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
tempViewer.Dock = System.Windows.Forms.DockStyle.Fill;
tempViewer.Name = "tempViewer";
tempViewer.SelectionFormula = "";
tempViewer.TabIndex = 0;
tempViewer.ViewTimeSelectionFormula = "";
tempViewer.ReportSource = rpt;
tempViewer.AutoSize = true;
tempViewer.Refresh();
form.Controls.Add(tempViewer);
form.Size = this.Size;
form.StartPosition = FormStartPosition.CenterParent;
form.ShowDialog();
}
}
SetDataSourceHeader(gridReportList, ListHeader(), _container.ResultObj);
}
private void MostrarNotaTerminacion(string numeroPedido)
{
crystalReportViewer1.ReportSource = GenerarNotaTerminacion(numeroPedido);
crystalReportViewer1.Refresh();
}
public void ShowReport(CrystalReportViewer rptView, DataSet ds, int tblIndex, string path,
string sSelectionFormula, ArrayList lstParam = null, ArrayList paramName = null)
{
//CrystalDecisions.CrystalReports.Engine.ReportDocument obj = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
int pCount;
ParameterFields paramFields = new ParameterFields();
try
{
objReport = new ReportDocument();
objReport.Load(Application.StartupPath + "\\Report\\RptBom.Rpt");
TableLogOnInfos crtableLogoninfos = new TableLogOnInfos();
TableLogOnInfo crtableLogoninfo = new TableLogOnInfo();
ConnectionInfo crConnectionInfo = new ConnectionInfo();
Tables CrTables;
crConnectionInfo.ServerName = path;
crConnectionInfo.DatabaseName = path;
crConnectionInfo.UserID = "";
crConnectionInfo.Password = "";
CrTables = objReport.Database.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
}
if (lstParam != null)
{
pCount = lstParam.Count;
for (int i = 0; i < pCount; i++)
{
ParameterField paramField = new ParameterField();
ParameterDiscreteValue discreteVal = new ParameterDiscreteValue();
paramField.ParameterFieldName = paramName[i].ToString();
// Set the discrete value and pass it to the parameter
discreteVal.Value = lstParam[i].ToString();
paramField.CurrentValues.Add(discreteVal);
// Add parameter to the parameter fields collection.
paramFields.Add(paramField);
}
}
if (sSelectionFormula.Length > 0)
{
objReport.RecordSelectionFormula = sSelectionFormula;
}
rptView.ReportSource = null;
rptView.ParameterFieldInfo = paramFields;
rptView.ReuseParameterValuesOnRefresh = true;
rptView.ReportSource = objReport;
for (int i = 0; i < rptView.LogOnInfo.Count; i++)
{
rptView.LogOnInfo[i].ConnectionInfo = crConnectionInfo;
}
rptView.Refresh();
rptView.Show();
//objReport.Database.Dispose();
//objReport.Dispose();
//objReport.Close();
}
catch (Exception ex)
{
throw new Exception(ex.Message.ToString());
}
finally
{
//objReport.Database.Dispose();
//objReport.Dispose();
//objReport.Close();
//paramFields = null;
}
}
private void rbtn7_Click(object sender, EventArgs e)
{
rpnl4.Visible = true;
rpnl3.Visible = false;
DateTime x = DateTime.Now;
String date = x.ToString("yyyy-MM-dd");
//String date = "2014-11-02";
String cm = "";
if (type.CompareTo("all") == 0)
{
cm = "SELECT * FROM [pizza].[dbo].[order] where date = '" + date + "'; ";
}
else if (type.CompareTo("takeaway") == 0)
{
cm = "SELECT * FROM [pizza].[dbo].[order] where date = '" + date + "' and ordtype = '" + type + "'; ";
}
else if (type.CompareTo("dine") == 0)
{
cm = "SELECT * FROM [pizza].[dbo].[order] where date = '" + date + "' and ordtype = '" + type + "'; ";
}
else if (type.CompareTo("delivery") == 0)
{
cm = "SELECT * FROM [pizza].[dbo].[order] where date = '" + date + "' and ordtype = '" + type + "'; ";
}
else if (type.CompareTo("category") == 0)
{
cm = "SELECT * FROM [pizza].[dbo].[order] where date = '" + date + "' and itemcateg = '" + rcmb1.SelectedItem.ToString() + "'; ";
}
else if (type == "item")
{
String selitem = rcmb1.SelectedItem.ToString();
int siz = 0;
if (selitem.Contains(" 8"))
{
siz = 8;
selitem = selitem.Replace(" 8", "");
cm = "SELECT * FROM [pizza].[dbo].[order] where date = '" + date + "' and itemname = '" + selitem + "' and itemsize = " + siz + "; ";
}
else if (selitem.Contains(" 12"))
{
siz = 12;
selitem = selitem.Replace(" 12", "");
cm = "SELECT * FROM [pizza].[dbo].[order] where date = '" + date + "' and itemname = '" + selitem + "' and itemsize = " + siz + "; ";
}
else
{
cm = "SELECT * FROM [pizza].[dbo].[order] where date = '" + date + "' and itemname = '" + selitem + "'; ";
}
}
SqlCommand cmd = new SqlCommand(cm, con);
con.Open();
//MessageBox.Show(cm);
SqlDataAdapter ad = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
ad.Fill(dt);
todayreport obj = new todayreport();
obj.SetDataSource(dt);
crystalReportViewer1.ReportSource = obj;
crystalReportViewer1.Size = new Size(2000, 2000);
crystalReportViewer1.Refresh();
rpnl4.Controls.Add(crystalReportViewer1);
con.Close();
}
private void MostrarFormaPedido(string clavePedido)
{
crystalReportViewer1.ReportSource = ManejadorContabilidad.GenerarFormaPedido(clavePedido);
crystalReportViewer1.Refresh();
}
