private void RptCetakKwitansi_Load(object sender, EventArgs e)
{
string strPath = Application.StartupPath + @"\Form\Report\Kwitansi\RptKwitansi.rpt";
// Object for load report.
ReportDocument rpt = new ReportDocument();
rpt.Load(strPath);
//Set Parameter
ParameterFields pfields = new ParameterFields();
ParameterField pfield = new ParameterField();
ParameterDiscreteValue disValue = new ParameterDiscreteValue();
pfield.Name = "spell";
disValue.Value = spell;
pfield.CurrentValues.Add(disValue);
pfields.Add(pfield);
pfield = new ParameterField();
pfield.Name = "price";
disValue = new ParameterDiscreteValue();
disValue.Value = harga;
pfield.CurrentValues.Add(disValue);
pfields.Add(pfield);
pfield = new ParameterField();
pfield.Name = "keterangan";
disValue = new ParameterDiscreteValue();
disValue.Value = ket;
pfield.CurrentValues.Add(disValue);
pfields.Add(pfield);
crystalReportViewer1.ParameterFieldInfo = pfields;
crystalReportViewer1.ReportSource = rpt;
crystalReportViewer1.Refresh();
}
private void InitializeReport()
{
ReportDocument REPORT_DOC = new ReportDocument();
REPORT_DOC = new RptSummaryMonthlySOIPilferageByLocation();
DataBaseLogIn(REPORT_DOC);
ParameterField prmDateFrom = new ParameterField();
ParameterField prmDateTo = new ParameterField();
ParameterFields prmList = new ParameterFields();
prmDateFrom.ParameterFieldName = "@DateFrom";
prmDateTo.ParameterFieldName = "@DateTo";
ParameterDiscreteValue prmDateFromValue = new ParameterDiscreteValue();
ParameterDiscreteValue prmDateToValue = new ParameterDiscreteValue();
prmDateFromValue.Value = Request.QueryString["DateFrom"];
prmDateToValue.Value = Request.QueryString["DateTo"];
prmDateFrom.CurrentValues.Add(prmDateFromValue);
prmDateTo.CurrentValues.Add(prmDateToValue);
prmList.Add(prmDateFrom);
prmList.Add(prmDateTo);
this.SummaryOfMonthlyPilferageByLocation.ParameterFieldInfo = prmList;
SummaryOfMonthlyPilferageByLocation.ReportSource = REPORT_DOC;
}
public void setParameters(ReportDocument Rpt)
{
if (HttpContext.Current.Request.QueryString["StartDate"] != null && HttpContext.Current.Request.QueryString["EndDate"] != null)
{
ParameterFields paramFields = new ParameterFields();
ParameterField StartDay, EndDay;
ParameterDiscreteValue dcStartDay, dcEndDay;
StartDay = new ParameterField();
StartDay.ParameterFieldName = "@FromDate";
dcStartDay = new ParameterDiscreteValue();
dcStartDay.Value = Request.QueryString["StartDate"].ToString();
EndDay = new ParameterField();
EndDay.ParameterFieldName = "@ToDate";
dcEndDay = new ParameterDiscreteValue();
dcEndDay.Value = Request.QueryString["EndDate"].ToString();
StartDay.CurrentValues.Add(dcStartDay);
EndDay.CurrentValues.Add(dcEndDay);
paramFields.Add(StartDay);
paramFields.Add(EndDay);
AdminActivityCRViewer.ParameterFieldInfo = paramFields;
AdminActivityCRViewer.ReportSource = Rpt;
AdminActivityCRViewer.DataBind();
}
}
public void InitializeReport()
{
ReportDocument PullOutSummaryPerCustomer;
PullOutSummaryPerCustomer = new PullOutSummaryPerOutletRpt();
DataBaseLogIn(PullOutSummaryPerCustomer);
ParameterField prmCustomerNumber = new ParameterField();
ParameterField prmDateFrom = new ParameterField();
ParameterField prmDateTo = new ParameterField();
ParameterFields prmList = new ParameterFields();
prmCustomerNumber.ParameterFieldName = "customer_number";
prmDateFrom.ParameterFieldName = "date_from";
prmDateTo.ParameterFieldName = "date_to";
ParameterDiscreteValue prmCustomerNumberValue = new ParameterDiscreteValue();
ParameterDiscreteValue prmDateFromValue = new ParameterDiscreteValue();
ParameterDiscreteValue prmDateToValue = new ParameterDiscreteValue();
prmCustomerNumberValue.Value = Request.QueryString["CustomerNumber"];
prmDateFromValue.Value = Request.QueryString["DateFrom"];
prmDateToValue.Value = Request.QueryString["DateTo"];
prmCustomerNumber.CurrentValues.Add(prmCustomerNumberValue);
prmDateFrom.CurrentValues.Add(prmDateFromValue);
prmDateTo.CurrentValues.Add(prmDateToValue);
prmList.Add(prmCustomerNumber);
prmList.Add(prmDateFrom);
prmList.Add(prmDateTo);
this.crViewerMonthlyPullOutSummaryPerCustomer.ParameterFieldInfo = prmList;
crViewerMonthlyPullOutSummaryPerCustomer.ReportSource = PullOutSummaryPerCustomer;
}
public void setParameters(ReportDocument Rpt)
{
ParameterFields paramFields = new ParameterFields();
if (HttpContext.Current.Request.QueryString["MailingId"] != null && HttpContext.Current.Request.QueryString["MailingId"] != string.Empty)
{
ParameterField MailingId = new ParameterField();
MailingId.ParameterFieldName = "@CampaignId";
ParameterDiscreteValue dcMailingId = new ParameterDiscreteValue();
dcMailingId.Value = Convert.ToInt32(Request.QueryString["MailingId"].ToString());
MailingId.CurrentValues.Add(dcMailingId);
paramFields.Add(MailingId);
}
else
{
ParameterField CampId = new ParameterField();
CampId.ParameterFieldName = "@AssignedCampaignID";
ParameterDiscreteValue dcCampId = new ParameterDiscreteValue();
dcCampId.Value = Convert.ToInt32(Request.QueryString["CampId"].ToString());
CampId.CurrentValues.Add(dcCampId);
paramFields.Add(CampId);
}
CrystalReportViewer1.ParameterFieldInfo = paramFields;
CrystalReportViewer1.ReportSource = Rpt;
CrystalReportViewer1.DataBind();
}
private void Reporte_de_Historial_de_pedidos_Load(object sender, EventArgs e)
{
//Diseño de la ventana
this.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(237)))), ((int)(((byte)(228)))), ((int)(((byte)(196)))));
this.Icon = global::Sistema_Shajobe.Properties.Resources.Pedidos_ICO;
//REPORTE CRISTAL REPORT
//PRIMER PARAMETRO
ReportDocument reporte = new ReportDocument();
ParameterField parametro = new ParameterField();
ParameterFields parametros = new ParameterFields();
ParameterDiscreteValue discretos = new ParameterDiscreteValue();
parametro.Name = "@Apartir";
discretos.Value = Convert.ToDateTime(_Apartir);
parametro.CurrentValues.Add(discretos);
parametros.Add(parametro);
//SEGUNDO PARAMETRO
ParameterField parametro1 = new ParameterField();
ParameterDiscreteValue discretos1 = new ParameterDiscreteValue();
parametro1.Name = "@Hasta";
discretos1.Value = Convert.ToDateTime(_Hasta);
parametro1.CurrentValues.Add(discretos1);
parametros.Add(parametro1);
crystalReportViewer1.ParameterFieldInfo = parametros;
crystalReportViewer1.ReportSource = RHistorialPedidos1;
}
public PrintSI(string Supplier, string city, string kapal, string date)
{
InitializeComponent();
reportDocument = new ReportDocument();
paramFields = new ParameterFields();
paramField = new ParameterField();
paramField.Name = "supplier";
paramDiscreteValue = new ParameterDiscreteValue();
paramDiscreteValue.Value = Supplier;
paramField.CurrentValues.Add(paramDiscreteValue);
paramFields.Add(paramField);
paramField = new ParameterField();
paramField.Name = "kapal";
paramDiscreteValue = new ParameterDiscreteValue();
paramDiscreteValue.Value = kapal;
paramField.CurrentValues.Add(paramDiscreteValue);
paramFields.Add(paramField);
paramField = new ParameterField();
paramField.Name = "tujuan";
paramDiscreteValue = new ParameterDiscreteValue();
paramDiscreteValue.Value = city;
paramField.CurrentValues.Add(paramDiscreteValue);
paramFields.Add(paramField);
paramField = new ParameterField();
paramField.Name = "ATD";
paramDiscreteValue = new ParameterDiscreteValue();
paramDiscreteValue.Value = date;
paramField.CurrentValues.Add(paramDiscreteValue);
paramFields.Add(paramField);
crystalReportViewer1.ParameterFieldInfo = paramFields;
}
public void InitializeReport()
{
ReportDocument PullOutConsolidated;
PullOutConsolidated = new PullOutConsolidatedMonthly();
DataBaseLogIn(PullOutConsolidated);
ParameterField prmDateFrom = new ParameterField();
ParameterField prmDateTo = new ParameterField();
ParameterFields prmList = new ParameterFields();
prmDateFrom.ParameterFieldName = "date_from";
prmDateTo.ParameterFieldName = "date_to";
ParameterDiscreteValue prmDateFromValue = new ParameterDiscreteValue();
ParameterDiscreteValue prmDateToValue = new ParameterDiscreteValue();
prmDateFromValue.Value = Request.QueryString["DateFrom"];
prmDateToValue.Value = Request.QueryString["DateTo"];
prmDateFrom.CurrentValues.Add(prmDateFromValue);
prmDateTo.CurrentValues.Add(prmDateToValue);
prmList.Add(prmDateFrom);
prmList.Add(prmDateTo);
this.crViewerMonthlyConsolidatedReport.ParameterFieldInfo = prmList;
crViewerMonthlyConsolidatedReport.ReportSource = PullOutConsolidated;
}
private void crystalReportViewer1_Load(object sender, EventArgs e)
{
DataSet ds = new DataSet();
ds = GetDs();
if (UserSecurity.HavingPrivilege(User.cur_user, "SPOOLWAREHOUSEUSERS"))
{
NestProjectMaterialRpt pmrpt = new NestProjectMaterialRpt();
pmrpt.SetDataSource(ds);
crystalReportViewer1.ReportSource = pmrpt;
}
else
{
ProjectMaterialRpt pmrpt = new ProjectMaterialRpt();
pmrpt.SetDataSource(ds);
crystalReportViewer1.ReportSource = pmrpt;
}
//crystalReportViewer1.DisplayGroupTree = false;
ParameterFields paramFields = new ParameterFields();
ParameterField paramField1 = new ParameterField();
ParameterDiscreteValue discreteVal = new ParameterDiscreteValue();
// 第一个参数是具有多个值的离散参数。设置参数字段的名称，它必须和报表中的参数相符。
paramField1.ParameterFieldName = "kickoffdate";
// 设置离散值并将其传递给该参数。
discreteVal.Value = User .KickOffDate ;
paramField1.CurrentValues.Add(discreteVal);
// 将该参数添加到参数字段集合。
paramFields.Add(paramField1);
ParameterField paramField2 = new ParameterField();
ParameterDiscreteValue discreteVal2 = new ParameterDiscreteValue();
paramField2.ParameterFieldName = "TotalBaseLength";
discreteVal2.Value = User.TotalBaseLength;
paramField2.CurrentValues.Add(discreteVal2);
paramFields.Add(paramField2);
ParameterField paramField5 = new ParameterField();
ParameterDiscreteValue discreteVal5 = new ParameterDiscreteValue();
paramField5.ParameterFieldName = "kickoffdateStart";
discreteVal5.Value = User.KickOffDate_start;
paramField5.CurrentValues.Add(discreteVal5);
paramFields.Add(paramField5);
ParameterField paramField6 = new ParameterField();
ParameterDiscreteValue discreteVal6 = new ParameterDiscreteValue();
paramField6.ParameterFieldName = "kickoffdateEnd";
discreteVal6.Value = User.KickOffDate_end;
paramField6.CurrentValues.Add(discreteVal6);
paramFields.Add(paramField6);
ParameterField paramField7 = new ParameterField();
ParameterDiscreteValue discreteVal7 = new ParameterDiscreteValue();
paramField7.ParameterFieldName = "TotalWeight";
discreteVal7.Value = User.PipeBaseTotalWeight;
paramField7.CurrentValues.Add(discreteVal7);
paramFields.Add(paramField7);
crystalReportViewer1.ParameterFieldInfo = paramFields;
}
private void NestingDetailViewer_Load(object sender, EventArgs e)
{
DataSet ds = new DataSet();
ds = GetDs();
if (UserSecurity.HavingPrivilege(User.cur_user, "SPOOLWAREHOUSEUSERS"))
{
NestingPipeRpt pmrpt = new NestingPipeRpt();
pmrpt.SetDataSource(ds);
NestingDetailViewer.ReportSource = pmrpt;
}
ParameterFields paramFields = new ParameterFields();
ParameterField paramField1 = new ParameterField();
ParameterDiscreteValue discreteVal = new ParameterDiscreteValue();
paramField1.ParameterFieldName = "kickoffdate";
discreteVal.Value = User.KickOffDate;
paramField1.CurrentValues.Add(discreteVal);
paramFields.Add(paramField1);
ParameterField paramField2 = new ParameterField();
ParameterDiscreteValue discreteVa2 = new ParameterDiscreteValue();
paramField2.ParameterFieldName = "Margin";
discreteVa2.Value = User.Margin;
paramField2.CurrentValues.Add(discreteVa2);
paramFields.Add(paramField2);
ParameterField paramField3 = new ParameterField();
ParameterDiscreteValue discreteVal3 = new ParameterDiscreteValue();
paramField3.ParameterFieldName = "TotalBaseLength";
discreteVal3.Value = User.TotalBaseLength;
paramField3.CurrentValues.Add(discreteVal3);
paramFields.Add(paramField3);
ParameterField paramField4 = new ParameterField();
ParameterDiscreteValue discreteVal4 = new ParameterDiscreteValue();
paramField4.ParameterFieldName = "PipeRatio";
discreteVal4.Value = User.PipeRatio;
paramField4.CurrentValues.Add(discreteVal4);
paramFields.Add(paramField4);
ParameterField paramField5 = new ParameterField();
ParameterDiscreteValue discreteVal5 = new ParameterDiscreteValue();
paramField5.ParameterFieldName = "kickoffdateStart";
discreteVal5.Value = User.KickOffDate_start;
paramField5.CurrentValues.Add(discreteVal5);
paramFields.Add(paramField5);
ParameterField paramField6 = new ParameterField();
ParameterDiscreteValue discreteVal6= new ParameterDiscreteValue();
paramField6.ParameterFieldName = "kickoffdateEnd";
discreteVal6.Value = User.KickOffDate_end;
paramField6.CurrentValues.Add(discreteVal6);
paramFields.Add(paramField6);
NestingDetailViewer.ParameterFieldInfo = paramFields;
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (!IsPostBack)
{
if (Request.QueryString["InvoiceID"] != null)
{
ReportDocument reportDocument = new ReportDocument();
ParameterField paramField = new ParameterField();
ParameterFields paramFields = new ParameterFields();
ParameterDiscreteValue paramDiscreteValue = new ParameterDiscreteValue();
paramField.Name = "@InvoiceId";
paramDiscreteValue.Value = Convert.ToInt32(Request.QueryString["InvoiceID"]);
paramField.CurrentValues.Add(paramDiscreteValue);
paramFields.Add(paramField);
paramFields.Add(paramField);
CrystalReportViewer1.ParameterFieldInfo = paramFields;
string reportPath = Server.MapPath("~/Admin/Invoice/crInvoice.rpt");
reportDocument.Load(reportPath);
//reportDocument.SetParameterValue("@InvoiceId", 1770);
CrystalReportViewer1.ReportSource = reportDocument;
CrystalReportViewer1.ToolPanelView = CrystalDecisions.Web.ToolPanelViewType.None;
Session["ReportDocument"] = reportDocument;
int InvoiceId = Convert.ToInt32(Request.QueryString["InvoiceID"]);
ClientScript.RegisterStartupScript(this.GetType(), "newWindow", String.Format("<script>window.open('{0}');</script>", "Annexure.aspx?InvoiceID=" + InvoiceId));
//string strPopupAnnexure = "<script language='javascript' ID='script2'>"
// // Passing intId to popup window.
//+ "window.open('Annexure.aspx?InvoiceID=" + HttpUtility.UrlEncode(InvoiceId.ToString())
//+ "','new window', 'top=90, left=200, width=768, height=1024, dependant=no, location=0, alwaysRaised=no, menubar=no, resizeable=no, scrollbars=n, toolbar=no, status=no, center=yes')"
//+ "</script>";
//ScriptManager.RegisterStartupScript((Page)HttpContext.Current.Handler, typeof(Page), "Script2", strPopupAnnexure, false);
}
else
{
string msg = "Session Expired.";
}
}
else
{
if (Session["ReportDocument"] != null)
{
ReportDocument doc = (ReportDocument)Session["ReportDocument"];
CrystalReportViewer1.ReportSource = doc;
}
}
}
catch (Exception ex)
{
string error = ex.Message.ToString();
}
}
protected void btnppf_Click(object sender, EventArgs e)
{
string s, m, w;
DateTime frd, td;
CultureInfo cf = new CultureInfo("hi-IN");
frd = Convert.ToDateTime(txtfd.Text, cf);
td = Convert.ToDateTime(txttd.Text, cf);
w = txtwc.Text;
m = txtsc.Text;
//s = "{{CDOSU.SOC}= '" + m + "' and {CR.WCC}='" + w + "'} and {{cr.regdt}>=#" + frd + "# and {cr.regdt}<=#" + td + "#}";
s = "{CDOSU.SOC}= '" + m + "' and {CR.WCC}='" + w + "' and {CR.REGDT}>=#" + frd + "# and {CR.REGDT}<=#" + td + "#";
ParameterField pf = new ParameterField();
ParameterFields param = new ParameterFields();
ParameterDiscreteValue df = new ParameterDiscreteValue();
pf.ParameterFieldName = "statuscd";
df.Value = m;
pf.CurrentValues.Add(df);
param.Add(pf);
ParameterField pf1 = new ParameterField();
ParameterDiscreteValue fd = new ParameterDiscreteValue();
pf1.ParameterFieldName = "wardcode";
fd.Value = w;
pf1.CurrentValues.Add(fd);
param.Add(pf1);
ParameterField pf2 = new ParameterField();
ParameterDiscreteValue df1 = new ParameterDiscreteValue();
pf2.ParameterFieldName = "From";
df1.Value = frd;
pf2.CurrentValues.Add(df1);
param.Add(pf2);
ParameterField pf3 = new ParameterField();
ParameterDiscreteValue df2 = new ParameterDiscreteValue();
pf3.ParameterFieldName = "To";
df2.Value = td;
pf3.CurrentValues.Add(df2);
param.Add(pf3);
ReportDocument rpt = new ReportDocument();
rpt.Load(Server.MapPath("statusWise.rpt"));
rpt.FileName=Server.MapPath("statusWise.rpt");
CrystalReportViewer1.ParameterFieldInfo = param;
CrystalReportViewer1.ReportSource = rpt;
CrystalReportViewer1.DisplayGroupTree = false;
CrystalReportViewer1.DisplayToolbar = false;
CrystalReportViewer1.SelectionFormula = s;
rpt.SetDatabaseLogon("scott", "tiger", "ora9i", "");
CrystalReportViewer1.DataBind();
}
private void crystalReportViewer1_Load(object sender, EventArgs e)
{
reportDataBind();
ParameterFields paramFields = new ParameterFields();
ParameterField paramField1 = new ParameterField();
ParameterDiscreteValue discreteVal1 = new ParameterDiscreteValue();
paramField1.ParameterFieldName = "drawingno";
discreteVal1.Value = drawingno;
paramField1.CurrentValues.Add(discreteVal1);
paramFields.Add(paramField1);
ParameterField paramField2 = new ParameterField();
ParameterDiscreteValue discreteVal2 = new ParameterDiscreteValue();
paramField2.ParameterFieldName = "blockno";
discreteVal2.Value = blockno;
paramField2.CurrentValues.Add(discreteVal2);
paramFields.Add(paramField2);
ParameterField paramField3 = new ParameterField();
ParameterDiscreteValue discreteVal3 = new ParameterDiscreteValue();
paramField3.ParameterFieldName = "project";
discreteVal3.Value = project;
paramField3.CurrentValues.Add(discreteVal3);
paramFields.Add(paramField3);
crystalReportViewer1.ParameterFieldInfo = paramFields;
}
private void InitializeReport()
{
ReportDocument REPORT_DOC = new ReportDocument();
REPORT_DOC = new RptSummaryMonthlyPilferageDeptStores();
DataBaseLogIn(REPORT_DOC);
ParameterField prmBrand = new ParameterField();
ParameterField prmDateFrom = new ParameterField();
ParameterField prmDateTo = new ParameterField();
ParameterFields prmList = new ParameterFields();
prmBrand.ParameterFieldName = "@BRAND_NAME";
prmDateFrom.ParameterFieldName = "@DATE_FROM";
prmDateTo.ParameterFieldName = "@DATE_TO";
ParameterDiscreteValue prmBrandValue = new ParameterDiscreteValue();
ParameterDiscreteValue prmDateFromValue = new ParameterDiscreteValue();
ParameterDiscreteValue prmDateToValue = new ParameterDiscreteValue();
prmBrandValue.Value = Request.QueryString["Brand"];
prmDateFromValue.Value = Request.QueryString["DateFrom"];
prmDateToValue.Value = Request.QueryString["DateTo"];
prmBrand.CurrentValues.Add(prmBrandValue);
prmDateFrom.CurrentValues.Add(prmDateFromValue);
prmDateTo.CurrentValues.Add(prmDateToValue);
prmList.Add(prmBrand);
prmList.Add(prmDateFrom);
prmList.Add(prmDateTo);
this.SummaryOfMonthlyPilferagePerDepartmentStores.ParameterFieldInfo = prmList;
SummaryOfMonthlyPilferagePerDepartmentStores.ReportSource = REPORT_DOC;
}
public void InitializeReport()
{
ReportDocument PullOutSummaryPerBrand = new ReportDocument();
switch(Request.QueryString["CustomerType"])
{
case "PROVINCIAL":
PullOutSummaryPerBrand = new PullOutSummaryPerBrandPROVRpt();
break;
case "BOUTIQUE":
PullOutSummaryPerBrand = new PullOutSummaryPerBrandBTQRpt();
break;
case "DEPARTMENT STORE":
PullOutSummaryPerBrand = new PullOutSummaryPerBrandDEPTSTORERpt();
break;
}
DataBaseLogIn(PullOutSummaryPerBrand);
ParameterField prmBrand = new ParameterField();
ParameterField prmDateFrom = new ParameterField();
ParameterField prmDateTo = new ParameterField();
ParameterFields prmList = new ParameterFields();
prmBrand.ParameterFieldName = "brand";
prmDateFrom.ParameterFieldName = "date_from";
prmDateTo.ParameterFieldName = "date_to";
ParameterDiscreteValue prmBrandValue = new ParameterDiscreteValue();
ParameterDiscreteValue prmDateFromValue = new ParameterDiscreteValue();
ParameterDiscreteValue prmDateToValue = new ParameterDiscreteValue();
prmBrandValue.Value = Request.QueryString["Brand"];
prmDateFromValue.Value = Request.QueryString["DateFrom"];
prmDateToValue.Value = Request.QueryString["DateTo"];
prmBrand.CurrentValues.Add(prmBrandValue);
prmDateFrom.CurrentValues.Add(prmDateFromValue);
prmDateTo.CurrentValues.Add(prmDateToValue);
prmList.Add(prmBrand);
prmList.Add(prmDateFrom);
prmList.Add(prmDateTo);
this.crViewerPullOutSummaryPerBrand.ParameterFieldInfo = prmList;
crViewerPullOutSummaryPerBrand.ReportSource = PullOutSummaryPerBrand;
}
private void btnSearch_Click(object sender, EventArgs e)
{
if (lblGroupName.Text != "")
{
string ConnectionString = ConfigurationManager.ConnectionStrings["ConString"].ConnectionString;
using (SqlConnection sqlCon = new SqlConnection(ConnectionString))
try
{
DebitCredit_ReportNew reportDocument = new DebitCredit_ReportNew();
ParameterField paramField = new ParameterField();
ParameterFields paramFields = new ParameterFields();
ParameterDiscreteValue paramDiscreteValue = new ParameterDiscreteValue();
paramField.Name = "@GroupId";
paramDiscreteValue.Value = cbgroupNames.SelectedValue.ToString();
paramField.CurrentValues.Add(paramDiscreteValue);
paramFields.Add(paramField);
paramFields.Add(paramField);
DebitandCreditcrystalReport.ParameterFieldInfo = paramFields;
//string reportPath = Server.MapPath("~/Memberwisrrptfile.rpt");
reportDocument.Load("~/DebitCredit_ReportNew.rpt");
//reportDocument.Load(@"D:\New folder\Loanapp11sep\10092015 Loan\Loan-25-07-2015\source\LoanApplication\LoanApplication\Memberwisrrptfile.rpt");
reportDocument.SetParameterValue("@GroupId", cbgroupNames.SelectedValue.ToString());
DebitandCreditcrystalReport.ReportSource = reportDocument;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
finally
{
}
}
else
{
MessageBox.Show("Please Select Group For Search");
}
}
private void btnSearch_Click(object sender, EventArgs e)
{
string ConnectionString = ConfigurationManager.ConnectionStrings["ConString"].ConnectionString;
using (SqlConnection sqlCon = new SqlConnection(ConnectionString))
try
{
DailyTransactionRpt reportDocument = new DailyTransactionRpt();
ParameterField paramField = new ParameterField();
ParameterFields paramFields = new ParameterFields();
ParameterDiscreteValue paramDiscreteValue = new ParameterDiscreteValue();
paramField.Name = "@BcDate";
paramField.Name = "@DueDate";
paramDiscreteValue.Value = dtpfromdate.Text;
paramDiscreteValue.Value = dtpTodate.Text;
paramField.CurrentValues.Add(paramDiscreteValue);
paramFields.Add(paramField);
paramFields.Add(paramField);
crystalReportViewer1.ParameterFieldInfo = paramFields;
//string reportPath = Server.MapPath("~/Memberwisrrptfile.rpt");
reportDocument.Load("~/DailyTransactionRpt.rpt");
//reportDocument.Load(@"D:\New folder\Loanapp11sep\10092015 Loan\Loan-25-07-2015\source\LoanApplication\LoanApplication\Memberwisrrptfile.rpt");
reportDocument.SetParameterValue("@BcDate", dtpfromdate.Text);
reportDocument.SetParameterValue("@DueDate", dtpTodate.Text);
crystalReportViewer1.ReportSource = reportDocument;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
finally
{
}
}
private void button1_Click(object sender, EventArgs e)
{
ReportViewer f2 = new ReportViewer();
ParameterField paramField = new ParameterField();
//creating an object of ParameterFields class
ParameterFields paramFields = new ParameterFields();
//creating an object of ParameterDiscreteValue class
ParameterDiscreteValue paramDiscreteValue = new ParameterDiscreteValue();
//set the parameter field name
paramField.Name = "particulars";
//set the parameter value
paramDiscreteValue.Value = comboBox1.Text;
//add the parameter value in the ParameterField object
paramField.CurrentValues.Add(paramDiscreteValue);
//add the parameter in the ParameterFields object
paramFields.Add(paramField);
//set the parameterfield information in the crystal report
TableLogOnInfos reportLogonInfos = new TableLogOnInfos();
TableLogOnInfo reportLogonInfo = new TableLogOnInfo();
ConnectionInfo reportConInfo = new ConnectionInfo();
Tables tables = default(Tables);
// Table table = default(Table);
var with1 = reportConInfo;
with1.ServerName = "tcp:KyotoServer,49172";
with1.DatabaseName = "BankReconciliationDB";
with1.UserID = "sa";
with1.Password = "******";
ParticularsPaymentStatementCrystalReport cr = new ParticularsPaymentStatementCrystalReport();
tables = cr.Database.Tables;
foreach (Table table in tables)
{
reportLogonInfo = table.LogOnInfo;
reportLogonInfo.ConnectionInfo = reportConInfo;
table.ApplyLogOnInfo(reportLogonInfo);
}
f2.crystalReportViewer1.ParameterFieldInfo = paramFields;
f2.crystalReportViewer1.ReportSource = cr;
this.Visible = false;
f2.ShowDialog();
this.Visible = true;
}
private void GetLandscape()
{
ParameterField paramField1 = new ParameterField();
//creating an object of ParameterFields class
ParameterFields paramFields1 = new ParameterFields();
//creating an object of ParameterDiscreteValue class
ParameterDiscreteValue paramDiscreteValue1 = new ParameterDiscreteValue();
//set the parameter field name
paramField1.Name = "BatchId";
//set the parameter value
paramDiscreteValue1.Value = batchIdCombobox.Text;
//add the parameter value in the ParameterField object
paramField1.CurrentValues.Add(paramDiscreteValue1);
//add the parameter in the ParameterFields object
paramFields1.Add(paramField1);
ReportViewer f2 = new ReportViewer();
TableLogOnInfos reportLogonInfos = new TableLogOnInfos();
TableLogOnInfo reportLogonInfo = new TableLogOnInfo();
ConnectionInfo reportConInfo = new ConnectionInfo();
Tables tables = default(Tables);
// Table table = default(Table);
var with1 = reportConInfo;
with1.ServerName = "tcp:KyotoServer,49172";
with1.DatabaseName = "PhoneBookDBKD22";
with1.UserID = "sa";
with1.Password = "******";
BatchReportUnSuccessfull cr = new BatchReportUnSuccessfull();
tables = cr.Database.Tables;
foreach (Table table in tables)
{
reportLogonInfo = table.LogOnInfo;
reportLogonInfo.ConnectionInfo = reportConInfo;
table.ApplyLogOnInfo(reportLogonInfo);
}
f2.crystalReportViewer1.ParameterFieldInfo = paramFields1;
f2.crystalReportViewer1.ReportSource = cr;
this.Visible = false;
f2.ShowDialog();
this.Visible = true;
}
public void InitializeReportByOutletWithDateRange(string TransitStatus)
{
DataTable DeliveryReceiptsByOutLet = new DataTable();
ReportDocument rptDoc;
ParameterField paramReportTitle = new ParameterField();
ParameterField prmDateRange = new ParameterField();
ParameterFields prmList = new ParameterFields();
paramReportTitle.ParameterFieldName = "ReportTitle";
prmDateRange.ParameterFieldName = "DateRange";
ParameterDiscreteValue prmReportTitleValue = new ParameterDiscreteValue();
ParameterDiscreteValue prmDateRangeValue = new ParameterDiscreteValue();
prmDateRangeValue.Value = "DATE FROM: " + DateTime.Parse(hfDateFrom.Value).ToString("MMMM dd, yyyy") + " TO " +
DateTime.Parse(hfDateTo.Value).ToString("MMMM dd, yyyy");
DeliveryReceiptsByOutLet = DManager.GetAllTransitDeliveryReceiptsByOutletWithDateRange(hfTransitStatus.Value, hfOutletName.Value, DateTime.Parse(hfDateFrom.Value), DateTime.Parse(hfDateTo.Value));
if (hfTransitStatus.Value == "In Transit")
{
prmReportTitleValue.Value = "In-Transit Delivery Receipts by Outlet";
rptDoc = new ReportDocuments.InTransitDeliveryReceiptsByBrand();
}
else
{
prmReportTitleValue.Value = "Confirmed Delivery Receipts by Outlet";
rptDoc = new ReportDocuments.RptTransitDeliveryReceiptsByOutlet();
}
paramReportTitle.CurrentValues.Add(prmReportTitleValue);
prmDateRange.CurrentValues.Add(prmDateRangeValue);
prmList.Add(paramReportTitle);
prmList.Add(prmDateRange);
rptDoc.SetDataSource(DeliveryReceiptsByOutLet);
crViewerAdjustmentMemo.ParameterFieldInfo = prmList;
crViewerAdjustmentMemo.ReportSource = rptDoc;
}
//PHUOCNC Sửa lại cho tổng quát hơn
//FieldName = Caption + index
public static ParameterFields CalcParameters(string[] Captions)
{
//Không được thay đổi vì Template Report mình dùng những Field có tên là vậy
string Caption = "Caption";
int MAX_COL = 15;
ParameterFields paramFields = new ParameterFields();
ParameterField paramField = null;
ParameterDiscreteValue paramValue = null;
for (int i = 0; i < Captions.Length; i++)
{
paramValue = new ParameterDiscreteValue();
paramValue.Description = "Caption" + i;
paramValue.Value = Captions[i];
paramField = HelpCrystalReport.CreateParameter(Caption + i, Captions[i]);
paramField.CurrentValues.Add(paramValue);
paramFields.Add(paramField);
//paramFields.Add(HelpCrystalReport.CreateParameter(Caption + i, Captions[i]));
}
for (int i = Captions.Length; i < MAX_COL; i++)
{
paramValue = new ParameterDiscreteValue();
paramValue.Description = "Caption" + i;
paramValue.Value = "";
paramField = HelpCrystalReport.CreateParameter(Caption + i, "");
paramField.CurrentValues.Add(paramValue);
paramFields.Add(paramField);
//paramFields.Add(HelpCrystalReport.CreateParameter(Caption + i, ""));
}
//Set value for first parameter
return paramFields;
}
public void InitializeReport()
{
ReportDocument DetailedReportperOutlet;
DetailedReportperOutlet = new PullOutDetailedPerOutletRpt();
int CustomerNumber = int.Parse(Request.QueryString["CustomerNumber"]);
DateTime DateFrom = DateTime.Parse(Request.QueryString["DateFrom"]);
DateTime DateTo = DateTime.Parse(Request.QueryString["DateTo"]);
DataBaseLogIn(DetailedReportperOutlet);
ParameterField prmCustomerNumber = new ParameterField();
ParameterField prmDateFrom = new ParameterField();
ParameterField prmDateTo = new ParameterField();
ParameterFields prmList = new ParameterFields();
prmCustomerNumber.ParameterFieldName = "customer_number";
prmDateFrom.ParameterFieldName = "date_from";
prmDateTo.ParameterFieldName = "date_to";
ParameterDiscreteValue prmCustNoValue = new ParameterDiscreteValue();
ParameterDiscreteValue prmDateFromValue = new ParameterDiscreteValue();
ParameterDiscreteValue prmDateToValue = new ParameterDiscreteValue();
prmCustNoValue.Value = Request.QueryString["CustomerNumber"];
prmDateFromValue.Value = Request.QueryString["DateFrom"];
prmDateToValue.Value = Request.QueryString["DateTo"];
prmCustomerNumber.CurrentValues.Add(prmCustNoValue);
prmDateFrom.CurrentValues.Add(prmDateFromValue);
prmDateTo.CurrentValues.Add(prmDateToValue);
prmList.Add(prmCustomerNumber);
prmList.Add(prmDateFrom);
prmList.Add(prmDateTo);
crViewerDetailedReportPerOutlet.ParameterFieldInfo = prmList;
crViewerDetailedReportPerOutlet.ReportSource = DetailedReportperOutlet;
}
public void loadRepport(DataTable dataTable)
{
dataSet.Tables[0].Merge(dataTable);
rpBangLuongChiTietNhanVien rpLuong = new rpBangLuongChiTietNhanVien();
ParameterFields pField = new ParameterFields();
ParameterField pTruongKeToan = new ParameterField();
ParameterDiscreteValue pTruongKeToan_value = new ParameterDiscreteValue();
pTruongKeToan_value.Value = "Danh Thanh";
pTruongKeToan.ParameterFieldName = "TruongKeToan";
pTruongKeToan.CurrentValues.Add(pTruongKeToan_value);
pField.Add(pTruongKeToan);
ParameterField pTenQuan = new ParameterField();
ParameterDiscreteValue pTenQuan_value = new ParameterDiscreteValue();
pTenQuan_value.Value = "Quán Karaoke Nice";
pTenQuan.ParameterFieldName = "TenQuan";
pTenQuan.CurrentValues.Add(pTenQuan_value);
pField.Add(pTenQuan);
ParameterField pDiaChiQuan = new ParameterField();
ParameterDiscreteValue pDiaChiQuan_value = new ParameterDiscreteValue();
pDiaChiQuan_value.Value = "123 Đinh Tiên Hoàng, quận 10, Tp. Hồ Chí Minh";
pDiaChiQuan.ParameterFieldName = "DiaChiQuan";
pDiaChiQuan.CurrentValues.Add(pDiaChiQuan_value);
pField.Add(pDiaChiQuan);
crBaoCaoLuong.ParameterFieldInfo = pField;
rpLuong.SetDataSource(dataSet.Tables[0]);
rpLuong.Refresh();
crBaoCaoLuong.ReportSource = rpLuong;
dataSet.Tables[0].Reset();
}
private void button7_Click(object sender, EventArgs e)
{
ParameterField paramField1 = new ParameterField();
//creating an object of ParameterFields class
ParameterFields paramFields1 = new ParameterFields();
//creating an object of ParameterDiscreteValue class
ParameterDiscreteValue paramDiscreteValue1 = new ParameterDiscreteValue();
//set the parameter field name
paramField1.Name = "id";
//set the parameter value
paramDiscreteValue1.Value = x;
//add the parameter value in the ParameterField object
paramField1.CurrentValues.Add(paramDiscreteValue1);
//add the parameter in the ParameterFields object
paramFields1.Add(paramField1);
ReportViewer f2 = new ReportViewer();
TableLogOnInfos reportLogonInfos = new TableLogOnInfos();
TableLogOnInfo reportLogonInfo = new TableLogOnInfo();
ConnectionInfo reportConInfo = new ConnectionInfo();
Tables tables = default(Tables);
// Table table = default(Table);
var with1 = reportConInfo;
with1.ServerName = "LAPTOP-19NF5E9";
with1.DatabaseName = "BankReconciliationDBProNovember";
with1.UserID = "sa";
with1.Password = "******";
NewSummrybalance cr = new NewSummrybalance();
tables = cr.Database.Tables;
foreach (Table table in tables)
{
reportLogonInfo = table.LogOnInfo;
reportLogonInfo.ConnectionInfo = reportConInfo;
table.ApplyLogOnInfo(reportLogonInfo);
}
f2.crystalReportViewer1.ParameterFieldInfo = paramFields1;
f2.crystalReportViewer1.ReportSource = cr;
this.Visible = false;
f2.ShowDialog();
this.Visible = true;
}
private void printDtl2()
{
rptCutBundlePlanSheet2 oRpt = new rptCutBundlePlanSheet2();
ParameterFields ps = new ParameterFields();
ParameterField p = new ParameterField();
ParameterDiscreteValue pdc = new ParameterDiscreteValue();
SetDBLogonForReport(oRpt);
p.Name = "@LayBatNo";
pdc.Value = Convert.ToInt32(cmbLayerBatchNo.SelectedValue);
p.CurrentValues.Add(pdc);
ps.Add(p);
ParameterField p2 = new ParameterField();
ParameterDiscreteValue pdc2 = new ParameterDiscreteValue();
p2.Name = "@cutDate";
pdc2.Value = Convert.ToDateTime(txthidDate.Text);
p2.CurrentValues.Add(pdc2);
ps.Add(p2);
crystalReportViewer1.ParameterFieldInfo = ps;
crystalReportViewer1.ReportSource = oRpt;
crystalReportViewer1.Show();
}
private ParameterFields GetCashReportParameters()
{
ParameterFields crParams = new ParameterFields();
ParameterField crParam = new ParameterField();
ParameterDiscreteValue crParamDiscreteValue = new ParameterDiscreteValue();
crParam.Name = "DataRaportu";
crParamDiscreteValue.Value = dtpCashReportDate.Value;
crParam.CurrentValues.Add(crParamDiscreteValue);
crParams.Add(crParam);
return(crParams);
}
private void PrintDoc(int grouping, int typex)
{
string reporttitle = "Stock Evaluation".ToUpper();
frm_reportViwer rpt = new frm_reportViwer();
rpt.MdiParent = MDI_SMartAnything.ActiveForm;
rpt.FormHeadertext = reporttitle;
ParameterField paramField = new ParameterField();
ParameterFields paramFields = new ParameterFields();
ParameterDiscreteValue paramDiscreteValue = new ParameterDiscreteValue();
paramFields = commonFunctions.AddCrystalParamsWithLoca(reporttitle, commonFunctions.Loginuser.ToUpper(), commonFunctions.GlobalLocation, findExisting.FindExisitingLoca(commonFunctions.GlobalLocation));
paramField.Name = "status";
paramDiscreteValue.Value = "processed".ToUpper();
paramField.CurrentValues.Add(paramDiscreteValue);
paramFields.Add(paramField);
if (grouping == 1)
{
rpt_stockEvoNew rptBank = new rpt_stockEvoNew();
if (typex == 1)
{
rptBank.SetDataSource(commonFunctions.GetDatatable(ReportStrings.GetStockEvoNew("001", "", "", "", 1, 1)));
}
else if (typex == 2)
{
// rptBank.SetDataSource(commonFunctions.GetDatatable(ReportEngine.GetStockEvoSTR(commonFunctions.GlobalLocation, typex, txt_Suplier.Text.Trim(), "")));
}
rpt.RepViewer.ParameterFieldInfo = paramFields;
rpt.RepViewer.ReportSource = rptBank;
rpt.RepViewer.Refresh();
rpt.Show();
}
else if (grouping == 2)
{
rpt_stockevonew_Groupcus rptgroupCat = new rpt_stockevonew_Groupcus();
if (typex == 1)
{
rptgroupCat.SetDataSource(commonFunctions.GetDatatable(ReportStrings.GetStockEvoNew("001", "", "", "", 1, 1)));
}
rpt.RepViewer.ParameterFieldInfo = paramFields;
rpt.RepViewer.ReportSource = rptgroupCat;
rpt.RepViewer.Refresh();
rpt.Show();
}
}
//
private void PrintDateEmp()
{
// rptprodDataIntervalDataEmp oRpt = new rptprodDataIntervalDataEmp();
ParameterFields ps = new ParameterFields();
ParameterField p = new ParameterField();
ParameterDiscreteValue pdc = new ParameterDiscreteValue();
// SetDBLogonForReport(oRpt);
p.Name = "@dt1";
pdc.Value = Convert.ToDateTime(dtpfrom1.Value.ToShortDateString());
p.CurrentValues.Add(pdc);
ps.Add(p);
ParameterField p2 = new ParameterField();
ParameterDiscreteValue pdc2 = new ParameterDiscreteValue();
p2.Name = "@dt2";
pdc2.Value = Convert.ToDateTime(dtpto1.Value.ToShortDateString());
p2.CurrentValues.Add(pdc2);
ps.Add(p2);
crystalReportViewer1.ParameterFieldInfo = ps;
// crystalReportViewer1.ReportSource = oRpt;
crystalReportViewer1.Show();
}
private void btnPrn2_Click(object sender, EventArgs e)
{
// rptMonthAttendance oRpt = new rptMonthAttendance();
ParameterFields ps = new ParameterFields();
ParameterField p = new ParameterField();
ParameterDiscreteValue pdc = new ParameterDiscreteValue();
// SetDBLogonForReport(oRpt);
p.Name = "@cc";
pdc.Value = 1;
p.CurrentValues.Add(pdc);
ps.Add(p);
ParameterField p2 = new ParameterField();
ParameterDiscreteValue pdc2 = new ParameterDiscreteValue();
p2.Name = "@mno";
pdc2.Value = Convert.ToInt32(cmbMonth.SelectedValue);
p2.CurrentValues.Add(pdc2);
ps.Add(p2);
crystalReportViewer1.ParameterFieldInfo = ps;
// crystalReportViewer1.ReportSource = oRpt;
crystalReportViewer1.Show();
}
public void PayrollPrint(decimal IDS)
{
//Instantiate variables
string exePath = Application.StartupPath;
exePath = exePath + "\\Report\\PayrollRpt.rpt";
ReportDocument reportDocument = new ReportDocument();
ParameterField paramField = new ParameterField();
ParameterFields paramFields = new ParameterFields();
ParameterDiscreteValue paramDiscreteValue = new ParameterDiscreteValue();
//Set instances for input parameter 1 - @vDepartment
paramField.Name = "@IDS";
//Below variable can be set to any data
//present in SalseData table, Department column
paramDiscreteValue.Value = IDS;
paramField.CurrentValues.Add(paramDiscreteValue);
//Add the paramField to paramFields
paramFields.Add(paramField);
crystalReportViewer1.ParameterFieldInfo = paramFields;
reportDocument.Load(@exePath);
//set the database loggon information.
//**Note that the third parameter is the DSN name
// and not the Database or System name
// reportDocument.SetDatabaseLogon("pchitriv", "Windows2000",
// "TestDB_DSN", "testDB", false);
// reportDocument.SetDatabaseLogon(Variables.UserName, Variables.Password, Variables.ServerName, Variables.DBName, false);
foreach (CrystalDecisions.Shared.IConnectionInfo connection in reportDocument.DataSourceConnections)
{
connection.IntegratedSecurity = true;
for (int i = 0; i < reportDocument.DataSourceConnections.Count; i++)
{
// reportDocument.DataSourceConnections[i].SetConnection("server8\\sql", "Barangay", "sa", "cadechloe2318");
reportDocument.DataSourceConnections[i].SetConnection(Variables.ServerName, Variables.DBName, Variables.UserName, Variables.Password);
}
}
//Load the report by setting the report source
crystalReportViewer1.ReportSource = reportDocument;
crystalReportViewer1.PrintReport();
}
private void btnRegDet_Click(object sender, EventArgs e)
{
rptAttRegFullDtl oRpt = new rptAttRegFullDtl();
ParameterFields ps = new ParameterFields();
ParameterField p = new ParameterField();
ParameterDiscreteValue pdc = new ParameterDiscreteValue();
SetDBLogonForReport(oRpt);
p.Name = "@month";
pdc.Value = Convert.ToInt32(cmbMonth.SelectedValue);
p.CurrentValues.Add(pdc);
ps.Add(p);
ParameterField p3 = new ParameterField();
ParameterDiscreteValue pdc3 = new ParameterDiscreteValue();
p3.Name = "@comCode";
pdc3.Value = cmbCompany.SelectedValue.ToString();
p3.CurrentValues.Add(pdc3);
ps.Add(p3);
crystalReportViewer1.ParameterFieldInfo = ps;
crystalReportViewer1.ReportSource = oRpt;
crystalReportViewer1.Show();
}
public void PassParameterLeaveHeader(string ReportName, string FiscalYr)
{
ParameterFields pFields = new ParameterFields();
ParameterField pfHeader = new ParameterField();
ParameterField pfFiscalYr = new ParameterField();
//Generate ParameterDiscreteValue
ParameterDiscreteValue dvHeader = new ParameterDiscreteValue();
ParameterDiscreteValue dvFiscalYr = new ParameterDiscreteValue();
//Adding ParameterDiscreteValue to ParameterField
pfHeader.Name = "pHeader";
dvHeader.Value = ReportName;
pfHeader.CurrentValues.Add(dvHeader);
pfFiscalYr.Name = "pFiscalYr";
dvFiscalYr.Value = FiscalYr;
pfFiscalYr.CurrentValues.Add(dvFiscalYr);
//Adding Parameters to ParameterFields
pFields.Add(pfHeader);
pFields.Add(pfFiscalYr);
//Passing ParameterFields to CrystalReportViewer
CRV.ParameterFieldInfo = pFields;
}
private void button2_Click(object sender, EventArgs e)
{
// rptDailyDepStatus oRpt = new rptDailyDepStatus();
ParameterFields ps = new ParameterFields();
ParameterField p = new ParameterField();
ParameterDiscreteValue pdc = new ParameterDiscreteValue();
// SetDBLogonForReport(oRpt);
p.Name = "@dt";
pdc.Value = Convert.ToDateTime(dateTimePicker1.Value.ToShortDateString());
p.CurrentValues.Add(pdc);
ps.Add(p);
ParameterField p3 = new ParameterField();
ParameterDiscreteValue pdc3 = new ParameterDiscreteValue();
p3.Name = "@compCode";
pdc3.Value = cmbCompany.SelectedValue.ToString();
p3.CurrentValues.Add(pdc3);
ps.Add(p3);
crystalReportViewer1.ParameterFieldInfo = ps;
// crystalReportViewer1.ReportSource = oRpt;
crystalReportViewer1.Show();
}
private void btnSum_Click(object sender, EventArgs e)
{
// rptMonthAttendnceSummery oRpt = new rptMonthAttendnceSummery();
ParameterFields ps = new ParameterFields();
ParameterField p = new ParameterField();
ParameterDiscreteValue pdc = new ParameterDiscreteValue();
// SetDBLogonForReport(oRpt);
p.Name = "@month";
pdc.Value = Convert.ToInt32(cmbMonth.SelectedValue);
p.CurrentValues.Add(pdc);
ps.Add(p);
ParameterField p3 = new ParameterField();
ParameterDiscreteValue pdc3 = new ParameterDiscreteValue();
p3.Name = "@comCode";
pdc3.Value = cmbCompany.SelectedValue;
p3.CurrentValues.Add(pdc3);
ps.Add(p3);
crystalReportViewer1.ParameterFieldInfo = ps;
// crystalReportViewer1.ReportSource = oRpt;
crystalReportViewer1.Show();
}
public void LoadReport(ReportState rptState)
{
if (rptState != ReportState.FromPostBack)
{
try
{
rptdoc = new ReportDocument();
ParameterField paramField = new ParameterField();
ParameterFields paramFields = new ParameterFields();
DataTable dt = new DataTable();
dt = getdata();
ds.Tables[0].Merge(dt);
rptdoc.Load(Server.MapPath("ExamSNCrt.rpt"));
rptdoc.SetDataSource(dt);
ExamFormSerialNoApp.ReportSource = rptdoc;
paramField.Name = "tittle";
paramField.CurrentValues.Add(paramDValue);
paramField.HasCurrentValue = true;
paramFields.Add(paramField);
ExamFormSerialNoApp.ParameterFieldInfo = paramFields;
ExamFormSerialNoApp.EnableDatabaseLogonPrompt = false;
ExamFormSerialNoApp.EnableParameterPrompt = false;
Session["cr"] = rptdoc;
}
catch (NullReferenceException ex)
{
ExamFormSerialNoApp.Visible = false;
}
catch (CrystalReportsException ex)
{
ExamFormSerialNoApp.Visible = false;
}
catch (IndexOutOfRangeException ex)
{
ExamFormSerialNoApp.Visible = false;
}
catch (SqlException ex)
{
ExamFormSerialNoApp.Visible = false;
}
catch (ArgumentNullException ex)
{
ExamFormSerialNoApp.Visible = false;
}
}
else
{
ExamFormSerialNoApp.ReportSource = (ReportDocument)Session["cr"];
}
}
//mycode
private void Report()
{
ParameterField paramField1 = new ParameterField();
//creating an object of ParameterFields class
ParameterFields paramFields1 = new ParameterFields();
//creating an object of ParameterDiscreteValue class
ParameterDiscreteValue paramDiscreteValue1 = new ParameterDiscreteValue();
//set the parameter field name
paramField1.Name = "id";
//set the parameter value
paramDiscreteValue1.Value = quotationId;
//add the parameter value in the ParameterField object
paramField1.CurrentValues.Add(paramDiscreteValue1);
//add the parameter in the ParameterFields object
paramFields1.Add(paramField1);
ReportView f2 = new ReportView();
TableLogOnInfos reportLogonInfos = new TableLogOnInfos();
TableLogOnInfo reportLogonInfo = new TableLogOnInfo();
ConnectionInfo reportConInfo = new ConnectionInfo();
Tables tables = default(Tables);
// Table table = default(Table);
var with1 = reportConInfo;
with1.ServerName = "tcp:KyotoServer,49172";
with1.DatabaseName = "NewProductList";
with1.UserID = "sa";
with1.Password = "******";
CrystalReport2 cr = new CrystalReport2();
tables = cr.Database.Tables;
foreach (Table table in tables)
{
reportLogonInfo = table.LogOnInfo;
reportLogonInfo.ConnectionInfo = reportConInfo;
table.ApplyLogOnInfo(reportLogonInfo);
}
f2.crystalReportViewer1.ParameterFieldInfo = paramFields1;
f2.crystalReportViewer1.ReportSource = cr;
this.Visible = false;
f2.ShowDialog();
this.Visible = true;
}
public void LoadReport(ReportState rptState)
{
if (rptState != ReportState.FromPostBack)
{
try
{
rptdoc = new ReportDocument();
paramField = new ParameterField();
paramDValue = new ParameterDiscreteValue();
DataTable dt = new DataTable();
dt = getdata();
ds.Tables[0].Merge(dt);
rptdoc.Load(Server.MapPath("StudentRemarkCrt.rpt"));
rptdoc.SetDataSource(dt);
Stu_Remarks_Report.ReportSource = rptdoc;
paramField.Name = "tittle";
paramField.CurrentValues.Add(paramDValue);
paramField.HasCurrentValue = true;
paramFields.Add(paramField);
Stu_Remarks_Report.ParameterFieldInfo = paramFields;
Stu_Remarks_Report.EnableDatabaseLogonPrompt = false;
Stu_Remarks_Report.EnableParameterPrompt = false;
Session["cr"] = rptdoc;
}
catch (NullReferenceException ex)
{
Stu_Remarks_Report.Visible = false;
}
catch (IndexOutOfRangeException ex)
{
Stu_Remarks_Report.Visible = false;
}
catch (CrystalReportsException ex)
{
Stu_Remarks_Report.Visible = false;
}
catch (ArgumentNullException ex)
{
Stu_Remarks_Report.Visible = false;
}
catch (COMException ex)
{
Response.Redirect("../../Login.aspx");
}
}
else
{
Stu_Remarks_Report.ReportSource = (ReportDocument)Session["cr"];
}
}
private void printMnthEmp()
{
// rptMonthAttEmployee oRpt = new rptMonthAttEmployee();
ParameterFields ps = new ParameterFields();
ParameterField p = new ParameterField();
ParameterDiscreteValue pdc = new ParameterDiscreteValue();
// SetDBLogonForReport(oRpt);
p.Name = "@empid";
pdc.Value = Convert.ToInt32(cmbEmp.SelectedValue);
p.CurrentValues.Add(pdc);
ps.Add(p);
ParameterField p2 = new ParameterField();
ParameterDiscreteValue pdc2 = new ParameterDiscreteValue();
p2.Name = "@mno";
pdc2.Value = Convert.ToInt32(cmbMonth.SelectedValue);
p2.CurrentValues.Add(pdc2);
ps.Add(p2);
crystalReportViewer1.ParameterFieldInfo = ps;
//crystalReportViewer1.ReportSource = oRpt;
crystalReportViewer1.Show();
}
public void PassParameterHeader(string ReportName)
{
ParameterFields pFields = new ParameterFields();
ParameterField pfHeader = new ParameterField();
ParameterDiscreteValue dvHeader = new ParameterDiscreteValue();
pfHeader.Name = "pHeader";
dvHeader.Value = ReportName;
pfHeader.CurrentValues.Add(dvHeader);
pFields.Add(pfHeader);
CRVT.ParameterFieldInfo = pFields;
}
void DateIntervalSumActStyle()
{
rptProdDateIntervalSumactstyl2 oRpt = new rptProdDateIntervalSumactstyl2();
ParameterFields ps = new ParameterFields();
ParameterField p = new ParameterField();
ParameterDiscreteValue pdc = new ParameterDiscreteValue();
SetDBLogonForReport(oRpt);
p.Name = "@dt1";
pdc.Value = Convert.ToDateTime(dtpfrom1.Value.ToShortDateString());
p.CurrentValues.Add(pdc);
ps.Add(p);
ParameterField p2 = new ParameterField();
ParameterDiscreteValue pdc2 = new ParameterDiscreteValue();
p2.Name = "@dt2";
pdc2.Value = Convert.ToDateTime(dtpto1.Value.ToShortDateString());
p2.CurrentValues.Add(pdc2);
ps.Add(p2);
crystalReportViewer1.ParameterFieldInfo = ps;
crystalReportViewer1.ReportSource = oRpt;
crystalReportViewer1.Show();
}
void CuttingBySize()
{
RptCuttingSize oRpt = new RptCuttingSize();
ParameterFields ps = new ParameterFields();
ParameterField p = new ParameterField();
ParameterDiscreteValue pdc = new ParameterDiscreteValue();
SetDBLogonForReport(oRpt);
p.Name = "@dt1";
pdc.Value = Convert.ToDateTime(dtpCutFrom.Value.ToShortDateString());
p.CurrentValues.Add(pdc);
ps.Add(p);
ParameterField p2 = new ParameterField();
ParameterDiscreteValue pdc2 = new ParameterDiscreteValue();
p2.Name = "@dt2";
pdc2.Value = Convert.ToDateTime(dtpCutTo.Value.ToShortDateString());
p2.CurrentValues.Add(pdc2);
ps.Add(p2);
crystalReportViewer1.ParameterFieldInfo = ps;
crystalReportViewer1.ReportSource = oRpt;
crystalReportViewer1.Show();
}
//
private void PrintEmployee()
{
prodByDtIntrvlSummary oRpt = new prodByDtIntrvlSummary();
ParameterFields ps = new ParameterFields();
ParameterField p = new ParameterField();
ParameterDiscreteValue pdc = new ParameterDiscreteValue();
SetDBLogonForReport(oRpt);
p.Name = "@dt1";
pdc.Value = Convert.ToDateTime(dtpfrom1.Value.ToShortDateString());
p.CurrentValues.Add(pdc);
ps.Add(p);
ParameterField p2 = new ParameterField();
ParameterDiscreteValue pdc2 = new ParameterDiscreteValue();
p2.Name = "@dt2";
pdc2.Value = Convert.ToDateTime(dtpto1.Value.ToShortDateString());
p2.CurrentValues.Add(pdc2);
ps.Add(p2);
crystalReportViewer1.ParameterFieldInfo = ps;
crystalReportViewer1.ReportSource = oRpt;
crystalReportViewer1.Show();
}
public void InitializeReport()
{
ReportDocument DetailedReportperOutlet;
DetailedReportperOutlet = new PullOutDetailedPerOutletRpt();
int CustomerNumber = int.Parse(Request.QueryString["CustomerNumber"]);
DateTime DateFrom = DateTime.Parse(Request.QueryString["DateFrom"]);
DateTime DateTo = DateTime.Parse(Request.QueryString["DateTo"]);
DataBaseLogIn(DetailedReportperOutlet);
ParameterField prmCustomerNumber = new ParameterField();
ParameterField prmDateFrom = new ParameterField();
ParameterField prmDateTo = new ParameterField();
ParameterFields prmList = new ParameterFields();
prmCustomerNumber.ParameterFieldName = "customer_number";
prmDateFrom.ParameterFieldName = "date_from";
prmDateTo.ParameterFieldName = "date_to";
ParameterDiscreteValue prmCustNoValue = new ParameterDiscreteValue();
ParameterDiscreteValue prmDateFromValue = new ParameterDiscreteValue();
ParameterDiscreteValue prmDateToValue = new ParameterDiscreteValue();
prmCustNoValue.Value = Request.QueryString["CustomerNumber"];
prmDateFromValue.Value = Request.QueryString["DateFrom"];
prmDateToValue.Value = Request.QueryString["DateTo"];
prmCustomerNumber.CurrentValues.Add(prmCustNoValue);
prmDateFrom.CurrentValues.Add(prmDateFromValue);
prmDateTo.CurrentValues.Add(prmDateToValue);
prmList.Add(prmCustomerNumber);
prmList.Add(prmDateFrom);
prmList.Add(prmDateTo);
crViewerDetailedReportPerOutlet.ParameterFieldInfo = prmList;
crViewerDetailedReportPerOutlet.ReportSource = DetailedReportperOutlet;
}
private void btnShow_Click(object sender, EventArgs e)
{
rptInformationSpecific oRpt = new rptInformationSpecific();
ParameterFields ps = new ParameterFields();
ParameterField p = new ParameterField();
ParameterDiscreteValue pdc = new ParameterDiscreteValue();
SetDBLogonForReport(oRpt);
p.Name = "@fmdate";
pdc.Value = Convert.ToDateTime(dtpFrom.Value.ToShortDateString());
p.CurrentValues.Add(pdc);
ps.Add(p);
ParameterField p2 = new ParameterField();
ParameterDiscreteValue pdc2 = new ParameterDiscreteValue();
p2.Name = "@todate";
pdc2.Value = Convert.ToDateTime(dtpTo.Value.ToShortDateString());
p2.CurrentValues.Add(pdc2);
ps.Add(p2);
ParameterField p4 = new ParameterField();
ParameterDiscreteValue pdc4 = new ParameterDiscreteValue();
p4.Name = "@InformationAccount";
pdc4.Value = Convert.ToInt32(cmbInfoAccount.SelectedValue);
p4.CurrentValues.Add(pdc4);
ps.Add(p4);
ParameterField p3 = new ParameterField();
ParameterDiscreteValue pdc3 = new ParameterDiscreteValue();
p3.Name = "@accCode";
pdc3.Value = Convert.ToInt32(cmbAccount.SelectedValue);
p3.CurrentValues.Add(pdc3);
ps.Add(p3);
crystalReportViewer1.ParameterFieldInfo = ps;
crystalReportViewer1.ReportSource = oRpt;
crystalReportViewer1.Show();
}
private void CustomerBill_Load(object sender, EventArgs e)
{
if (c.cnn.State == ConnectionState.Open)
{
c.cnn.Close();
}
c.cnn.Open();
SqlDataAdapter sqlda = new SqlDataAdapter("select * from customerdetails", c.cnn);
ReportDocument rpdocument = new ReportDocument();
string rppath = Application.StartupPath;
rppath = rppath.Substring(0, rppath.LastIndexOf("bin"));
rpdocument.Load(rppath + "Customerbillrpt.rpt");
try
{
DataSet dsetSer = new DataSet();
sqlda.Fill(dsetSer, "customerdetails");
rpdocument.SetDataSource(dsetSer);
crystalReportViewer1.ReportSource = rpdocument;
string selctcust = Application.OpenForms["BILL"].Controls["comboBox1"].Text;
if (selctcust != "")
{
ParameterFields paramfields = new ParameterFields();
ParameterField pfcustID = new ParameterField();
pfcustID.ParameterFieldName = "paramCustID";
ParameterDiscreteValue discrit = new ParameterDiscreteValue();
discrit.Value = selctcust;
pfcustID.CurrentValues.Add(discrit);
paramfields.Add(pfcustID);
}
try
{
crystalReportViewer1.SelectionFormula = "{customerdetails.customerid}='" + selctcust + "'";
}
catch (Exception ex)
{
MessageBox.Show("Error 5" + ex);
}
}
catch (Exception ex)
{
MessageBox.Show("Error" + ex);
}
}
private void ImprimeEpicrisis()
{
try
{
Reports _Reporte = new Reports();
ReportDocument objReport = new ReportDocument();
//String reportPath = Application.StartupPath + @"\Reporting\" + "IngresoCompras_Sintetico.rpt";
String reportPath = ConfigurationManager.AppSettings["Reports"] + "\\Reporting\\" + "Epicrisis.rpt";
objReport.Load(reportPath);
objReport.Refresh();
objReport.ReportOptions.EnableSaveDataWithReport = false;
// PARAMETROS DE CONEXION
TableLogOnInfo logoninfo = new TableLogOnInfo();
logoninfo.ConnectionInfo.ServerName = ConfigurationManager.AppSettings["Source"];
logoninfo.ConnectionInfo.DatabaseName = ConfigurationManager.AppSettings["CatalogSISTMED"];
logoninfo.ConnectionInfo.UserID = ConfigurationManager.AppSettings["User ID"];
logoninfo.ConnectionInfo.Password = ConfigurationManager.AppSettings["Password"];
logoninfo.ConnectionInfo.IntegratedSecurity = false;
Tables tables = objReport.Database.Tables;
foreach (Table table in tables)
{
table.ApplyLogOnInfo(logoninfo);
}
// FIN PARAMETROS DE CONEXION
ParameterFields Parametros = new ParameterFields();
ParameterField ParametroField = new ParameterField();
ParameterDiscreteValue ParametroValue = new ParameterDiscreteValue();
Parametros.Clear();
//1er PARAMETRO
ParametroField.Name = "@PACIENTE_ID";
ParametroValue.Value = Clases.Paciente.PacienteIngresado;
ParametroField.CurrentValues.Add(ParametroValue);
Parametros.Add(ParametroField);
_Reporte.Parameters = Parametros;
_Reporte.Reporte = objReport;
_Reporte.Show();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void frmposreport_Load(object sender, EventArgs e)
{
try
{
string path = Application.StartupPath + "\\CrystalReports\\cryPosreport.rpt";
if (!File.Exists(path))
{
MessageBox.Show("The Directory CrystalReports or Report File cryPosreport.rpt Not Exists");
return;
}
posTableAdapter pos = new posTableAdapter();
dsReport.PosInvoiceDataTable dt = pos.GetData(posinvoice);
salesinvoiceTableAdapter saladapter = new salesinvoiceTableAdapter();
dsReport.salesinvoiceDataTable satd = saladapter.GetData(Convert.ToString(posinvoice));
general.particulars = particulars;
general.voucherno = Convert.ToString(posinvoice);
double oldbalance = Convert.ToDouble(general.OldBalance());
//cryPosreport cryReport = new cryPosreport();
//cryReport.SetDataSource((DataTable)dt);
//cryPOSView.ReportSource = cryReport;
ReportDocument rDoc = new ReportDocument();
rDoc.Load(Application.StartupPath + "\\CrystalReports\\cryPosreport.rpt");
rDoc.SetDataSource((DataTable)satd);
ParameterFields paramfields = new ParameterFields();
ParameterField parameter = new ParameterField();
ParameterDiscreteValue discretedvalue = new ParameterDiscreteValue();
parameter.Name = "oldbalance";
discretedvalue.Value = oldbalance;
parameter.CurrentValues.Add(discretedvalue);
paramfields.Add(parameter);
//cryPOSView.ParameterFieldInfo = paramfields;
//cryPOSView.ReportSource = rDoc;
rDoc.SetParameterValue("oldbalance", oldbalance);
rDoc.PrintToPrinter(1, true, 1, 1);
this.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
throw;
}
}
public void InitializeReport()
{
ReportDocument PullOutSummaryPerCustomer;
PullOutSummaryPerCustomer = new PullOutSummaryPerOutletRpt();
DataBaseLogIn(PullOutSummaryPerCustomer);
ParameterField prmCustomerNumber = new ParameterField();
ParameterField prmDateFrom = new ParameterField();
ParameterField prmDateTo = new ParameterField();
ParameterFields prmList = new ParameterFields();
prmCustomerNumber.ParameterFieldName = "customer_number";
prmDateFrom.ParameterFieldName = "date_from";
prmDateTo.ParameterFieldName = "date_to";
ParameterDiscreteValue prmCustomerNumberValue = new ParameterDiscreteValue();
ParameterDiscreteValue prmDateFromValue = new ParameterDiscreteValue();
ParameterDiscreteValue prmDateToValue = new ParameterDiscreteValue();
prmCustomerNumberValue.Value = Request.QueryString["CustomerNumber"];
prmDateFromValue.Value = Request.QueryString["DateFrom"];
prmDateToValue.Value = Request.QueryString["DateTo"];
prmCustomerNumber.CurrentValues.Add(prmCustomerNumberValue);
prmDateFrom.CurrentValues.Add(prmDateFromValue);
prmDateTo.CurrentValues.Add(prmDateToValue);
prmList.Add(prmCustomerNumber);
prmList.Add(prmDateFrom);
prmList.Add(prmDateTo);
this.crViewerMonthlyPullOutSummaryPerCustomer.ParameterFieldInfo = prmList;
crViewerMonthlyPullOutSummaryPerCustomer.ReportSource = PullOutSummaryPerCustomer;
}
private void generarReporte(string fInicial, string fFinal, string tipo)
{
string nombreParametro = "p_fecha_inicial";
string nombreParametro2 = "p_fecha_final";
ReporteForm form = new ReporteForm();
if (tipo.Equals("producto"))
{
ReporteVentasDiarias oRep = new ReporteVentasDiarias();
form.crystalReportViewer1.ReportSource = oRep;
}
else if (tipo.Equals("dia"))
{
ReporteVentasDiarias2 oRep = new ReporteVentasDiarias2();
form.crystalReportViewer1.ReportSource = oRep;
}
/*PARAMETRO 1*/
ParameterField pf = new ParameterField();
ParameterFields pfs = new ParameterFields();
ParameterDiscreteValue pdv = new ParameterDiscreteValue();
pf.Name = nombreParametro;
pdv.Value = fInicial;
pf.CurrentValues.Add(pdv);
pfs.Add(pf);
/*PARAMETRO 2*/
ParameterField pf2 = new ParameterField();
ParameterDiscreteValue pdv2 = new ParameterDiscreteValue();
pf2.Name = nombreParametro2;
pdv2.Value = fFinal;
pf2.CurrentValues.Add(pdv2);
pfs.Add(pf2);
form.crystalReportViewer1.ParameterFieldInfo = pfs;
form.Show();
}
private void btnSearch_Click(object sender, EventArgs e)
{
using (SqlConnection sqlCon = new SqlConnection(ConnectionString))
try
{
GroupWise_CrystalReportNew reportDocument = new GroupWise_CrystalReportNew();
ParameterField paramField = new ParameterField();
ParameterFields paramFields = new ParameterFields();
ParameterDiscreteValue paramDiscreteValue = new ParameterDiscreteValue();
paramField.Name = "@GroupId";
paramDiscreteValue.Value = cbgroupNames.SelectedValue.ToString();
paramField.CurrentValues.Add(paramDiscreteValue);
paramFields.Add(paramField);
paramFields.Add(paramField);
crystalReportViewer1.ParameterFieldInfo = paramFields;
//string reportPath = Server.MapPath("~/Memberwisrrptfile.rpt");
reportDocument.Load("~/GroupWise_CrystalReportNew.rpt");
//reportDocument.Load(@"D:\New folder\Loanapp11sep\10092015 Loan\Loan-25-07-2015\source\LoanApplication\LoanApplication\Memberwisrrptfile.rpt");
reportDocument.SetParameterValue("@GroupId", cbgroupNames.SelectedValue.ToString());
crystalReportViewer1.ReportSource = reportDocument;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
finally
{
}
}
public static void ShowReport(EMDataSet emDataSet,int contid,string reportDescription)
{
GenericCrystalViewer view = new GenericCrystalViewer();
view.Text = "Balance Report";
BalanceReport report = new BalanceReport();
report.SetDataSource(emDataSet);
view.viewer.ReportSource = report;
ParameterFields fields = new ParameterFields();
ParameterField field = new ParameterField();
field.ParameterFieldName = "contNumber";
ParameterDiscreteValue discrete = new ParameterDiscreteValue();
discrete.Value = emDataSet.ContainerTbl.FindByContID(contid).ContNumber;
field.CurrentValues.Add(discrete);
fields.Add(field);
ParameterField field2 = new ParameterField();
field2.ParameterFieldName = "ReportDescription";
ParameterDiscreteValue discrete2 = new ParameterDiscreteValue();
discrete2.Value = reportDescription;
field2.CurrentValues.Add(discrete2);
fields.Add(field2);
view.viewer.ParameterFieldInfo = fields;
view.Show();
}
public void hacer_report(String idcomprobante)
{
ParameterDiscreteValue parametro=new ParameterDiscreteValue();
ParameterFields paramlist = new ParameterFields();
DataSet ds = new DataSet("comprobante");
db.ejecutar("select envnumcomprobante,envfecha_registro,if(clitipo=0,(select concat(natnombres,' ',natapellidos) from ste_clinatural where idclinatural=idcliente),(select jurrazonsocial from ste_clijuridico where idste_clijuridico=idcliente)) as nomcliente, cliruc, envdestinatario, envrucdestinatario, envdireccion_destino,envdireccion_origen,'" + this.txtrucremitente.Text + "' as rucremitente, ste_envio.gremision from ste_envio inner join ste_cliente on ste_envio.envidcliente=ste_cliente.idcliente where idenvio=" + idcomprobante);
ds.Tables.Add(db.gettabla());
db.ejecutar("select * from ste_detalleenvio where denidenvio=" + idcomprobante);
ds.Tables.Add(db.gettabla());
db.ejecutar("select * from ste_camionero inner join ste_unidad on ste_unidad.uniidcamionero=ste_camionero.idcamionero where ste_unidad.idunidad=" + this.cbunidad.SelectedIndex);
ds.Tables.Add(db.gettabla());
ds.WriteXmlSchema("./comprobante.xml");
CrystalDecisions.CrystalReports.Engine.ReportClass rpt;
switch (cmbtipcomprobante.SelectedIndex)
{
case 0://boleta
rpt = new reportes.boletadeventa();
break;
case 1://factura
rpt = new reportes.factura();
double subt=0;
foreach (DataRow r in ds.Tables[1].Rows) {
subt +=Double.Parse(r["dencantidad"].ToString()) * Double.Parse(r["denpreciounitario"].ToString());
//subt += ((Double)r["dencantidad"]) * ((Double)r["denpreciounitario"]);
}
parametro.Value = aletras(subt.ToString(),true);
paramlist.Add("enletras", ParameterValueKind.StringParameter, DiscreteOrRangeKind.DiscreteValue).CurrentValues.Add(parametro);
break;
default://orden de despacho
rpt = new reportes.ordendedespacho();
break;
}
rpt.SetDataSource(ds);
//FACTURA
formularios.Imprimir frmr = new formularios.Imprimir(rpt);
frmr.crystalReportViewer1.ParameterFieldInfo = paramlist;
frmr.ShowDialog(this);
//GUIA DE REMISION
if (cmbtipcomprobante.SelectedIndex==1)
{
rpt = new reportes.guiaderemision();
rpt.SetDataSource(ds);
frmr = new formularios.Imprimir(rpt);
//frmr.crystalReportViewer1.ParameterFieldInfo = paramlist;
frmr.ShowDialog(this);
}
}
private void btnThongKePhim_Click(object sender, EventArgs e)
{
int thang = Convert.ToInt16(dtpNgay.Value.Month);
//MessageBox.Show(thang.ToString());
ParameterFields paramFields = new ParameterFields();
ParameterField paramThang = new ParameterField();
ParameterDiscreteValue paramDiscreteValue = new ParameterDiscreteValue();
paramThang.Name = "pThang";
paramDiscreteValue = new ParameterDiscreteValue();
paramDiscreteValue.Value = thang;
paramThang.CurrentValues.Add(paramDiscreteValue);
paramFields.Add(paramThang);
crystalReportViewer1.ParameterFieldInfo = paramFields;
crystalReportViewer1.ReportSource = new rptPhim();
crystalReportViewer1.Refresh();
}
protected void lbGenerarInforme_Click(object sender, EventArgs e)
{
ParameterField parametro = new ParameterField();
ParameterFields parametros = new ParameterFields();
parametro.ParameterValueType = ParameterValueKind.NumberParameter;
parametro.Name = "@id_curso";
ParameterDiscreteValue valor = new ParameterDiscreteValue();
valor.Value = Convert.ToInt32(ddlAnios.SelectedValue);
parametro.CurrentValues.Add(valor);
parametros.Add(parametro);
CRViewerCursos.ParameterFieldInfo = parametros;
Util.ReporteCursos rep = new Util.ReporteCursos();
rep.SetDatabaseLogon("net", "net");
this.CRViewerCursos.ReportSource = rep;
this.CRViewerCursos.DataBind();
this.ReportViewerPanel.Visible = true;
this.formPanel.Visible = false;
}
private void cbxGenerarInforme_Click(object sender, EventArgs e)
{
ParameterField parametro = new ParameterField();
ParameterFields parametros = new ParameterFields();
parametro.ParameterValueType = ParameterValueKind.NumberParameter;
parametro.Name = "@id_curso";
ParameterDiscreteValue valor = new ParameterDiscreteValue();
valor.Value = Convert.ToInt32(cbxAnios.SelectedValue);
parametro.CurrentValues.Add(valor);
parametros.Add(parametro);
CRViewerCursos.ParameterFieldInfo = parametros;
Util.ReporteCursos rep = new Util.ReporteCursos();
rep.SetDatabaseLogon("net", "net");
this.CRViewerCursos.ReportSource = rep;
this.CRViewerCursos.Show();
this.OcultarControles();
this.WindowState = FormWindowState.Maximized;
}
private void Reporte_Produccion_Load(object sender, EventArgs e)
{
//Diseño de la ventana
this.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(237)))), ((int)(((byte)(228)))), ((int)(((byte)(196)))));
this.Icon = global::Sistema_Shajobe.Properties.Resources.Clientes_ICO;
//REPORTE CRISTAL REPORT
ReportDocument reporte = new ReportDocument();
ParameterField parametro = new ParameterField();
ParameterFields parametros = new ParameterFields();
ParameterDiscreteValue discretos = new ParameterDiscreteValue();
parametro.Name = "@Dato_Produccion";
discretos.Value = Id_Produccion;
parametro.CurrentValues.Add(discretos);
parametros.Add(parametro);
crystalReportViewer1.ParameterFieldInfo = parametros;
//reporte.Load(@"Titulacion\Sistema Shajobe\Sistema Shajobe\RCliente.rpt");
crystalReportViewer1.ReportSource = RProduccionProducto1;
}
public void AddParameter(string i_paramName, string i_paramValue, ParameterFields o_paramFields)
{
ParameterField paramField = new ParameterField();
ParameterDiscreteValue paramDiscreteValue = new ParameterDiscreteValue();
ParameterValues paramValues = new ParameterValues();
// Set the name of the parameter to modify.
paramField.ParameterFieldName = i_paramName;
// Set a value to the parameter.
paramDiscreteValue.Value = i_paramValue;
paramValues.Add(paramDiscreteValue);
paramField.CurrentValues = paramValues;
// Add the parameter to the ParameterFields collection.
o_paramFields.Add(paramField);
// Return paramFields
}
private ParameterFields AddParameter(string paramName, string paramValue, ParameterFields paramFields)
{
ParameterField paramField = new ParameterField();
ParameterDiscreteValue paramDiscreteValue = new
ParameterDiscreteValue();
ParameterValues paramValues = new ParameterValues();
// 设置要修改的参数的名称。
paramField.ParameterFieldName = paramName;
// 为该参数设置一个值。
paramDiscreteValue.Value = paramValue;
paramValues.Add(paramDiscreteValue);
paramField.CurrentValues = paramValues;
// 将该参数添加到 ParameterFields 集合中。
paramFields.Add(paramField);
return paramFields;
}
public CrystalViewer(EMDataSet dataSet,bool isPO)
{
//
// Required for Windows Form Designer support
//
InitializeComponent();
ParameterFields fields= new ParameterFields();
ParameterField field = new ParameterField();
field.ParameterFieldName = "isPO";
ParameterDiscreteValue discrete = new ParameterDiscreteValue();
discrete.Value = isPO;
field.CurrentValues.Add(discrete);
fields.Add(field);
CrystalReport1 c = new CrystalReport1();
crystalReportViewer1.ParameterFieldInfo = fields;
EMDataSet copy = (EMDataSet)dataSet.Copy();
c.SetDataSource(copy);
crystalReportViewer1.ReportSource = c;
//
// TODO: Add any constructor code after InitializeComponent call
//
}
private void LoadReport()
{
try
{
string strSql = "select work_id,shipsup,cargosup,to_char(appdate,'yyyy-mm-dd') appdate, cargo_name,cargo_num from zjgdou_declare where to_char(appdate,'yyyy-mm-dd')>='2009-05-08'";
// DataTable tab = rpDocDB.GetDataTable(strSql);
string strPath = Server.MapPath("../../rpt/declare.rpt");
this.rpDoc.Load(strPath);
// rpDoc.SetDataSource(tab);
this.Login(rpDoc);
ParameterFields pfs = new ParameterFields();
ParameterField pf = new ParameterField();
ParameterDiscreteValue pfv = new ParameterDiscreteValue();
string strCode = "信息中心";
pfv.Value = strCode;
pf.Name = "corp";
pf.CurrentValues.Add(pfv);
pfs.Add(pf);
this.CrystalReportViewer1.ParameterFieldInfo = pfs;
this.CrystalReportViewer1.ReportSource = rpDoc;
this.CrystalReportViewer1.DataBind();
//this.CrystalReportViewer1.RefreshReport();
//this.Session["REPORT"] = rpDoc;
}
catch (Exception err)
{
}
}
