public Boolean printReport(CrystalDecisions.CrystalReports.Engine.ReportClass crReport, CrystalReportViewer CrystalReportViewer1, String param1, String ParamName1, String param2, String ParamName2)
{
if (PrinterName=="none") return false;
paramField.ParameterFieldName = ParamName1;
discreteVal.Value = param1;
paramField.CurrentValues.Add (discreteVal);
paramFields.Add (paramField);
crReport.DataDefinition.ParameterFields[0].CurrentValues.Add (discreteVal);
paramField2.ParameterFieldName = ParamName2;
discreteVal2.Value = param2;
paramField2.CurrentValues.Add (discreteVal2);
paramFields.Add (paramField2);
crReport.DataDefinition.ParameterFields[1].CurrentValues.Add (discreteVal2);
CrystalReportViewer1.ReportSource = crReport;
CrystalReportViewer1.ParameterFieldInfo = paramFields;
CrystalReportViewer1.RefreshReport();
ParameterValues tmpParam = new ParameterValues();
ParameterValues tmpParam2 = new ParameterValues();
tmpParam.Add(discreteVal);
tmpParam2.Add(discreteVal2);
crReport.DataDefinition.ParameterFields[0].ApplyCurrentValues(tmpParam);
crReport.DataDefinition.ParameterFields[1].ApplyCurrentValues(tmpParam2);
crReport.PrintOptions.PrinterName = PrinterName;
// crReport.PrintToPrinter(1,false,1,1);
crReport.PrintToPrinter(1,false,1,99);
//Response.write (PrinterName);
return true;
}
public static void loadReport(ReportDocument rd, CrystalReportViewer crv, Int16 status, string phone = null, int?tableID = null)
{
try
{
SqlCommand cmd = new SqlCommand("st_getOrderReport", MainClass.con);
cmd.CommandType = CommandType.StoredProcedure;
if (phone == null)
{
cmd.Parameters.AddWithValue("@tableID", tableID);
cmd.Parameters.AddWithValue("@status", status);
cmd.Parameters.AddWithValue("@phone", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@phone", phone);
cmd.Parameters.AddWithValue("@status", status);
cmd.Parameters.AddWithValue("@tableID", DBNull.Value);
}
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
rd.Load(Application.StartupPath + "\\Reports\\billReport.rpt");
rd.SetDataSource(dt);
crv.ReportSource = rd;
crv.RefreshReport();
}
catch (Exception ex)
{
if (rd != null)
{
rd.Close();
}
MainClass.showMessage(ex.Message, "error");
}
}
public static void loadBillReport(ReportDocument rd, CrystalReportViewer crv, Int16 status, Int64 orderid)
{
try
{
SqlCommand cmd = new SqlCommand("st_getOrderReport", MainClass.con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@orderID", orderid);
cmd.Parameters.AddWithValue("@status", status);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
rd.Load(Application.StartupPath + "\\Reports\\billReport.rpt");
rd.SetDataSource(dt);
crv.ReportSource = rd;
crv.RefreshReport();
}
catch (Exception ex)
{
if (rd != null)
{
rd.Close();
}
MainClass.showMessage(ex.Message, "Error", "Error");
}
}
public static void ShowReportSaleReturn(CrystalReportViewer crv, string proc, string param = null, object val1 = null)
{
try
{
ReportDocument rd;
SqlConnection sql_con = new SqlConnection(MainClass.connection());
SqlCommand cmd = new SqlCommand(proc, sql_con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue(param, val1);
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
DataTable dat = new DataTable();
adapter.Fill(dat);
rd = new ReportDocument();
rd.Load(Application.StartupPath + "\\Reports\\SalesReturnReport.rpt");
rd.SetDataSource(dat);
crv.ReportSource = rd;
crv.RefreshReport();
}
catch (Exception ex)
{
MainClass.ShowMsg(ex.Message, "Error");
}
}
public void showReport(ReportDocument rd, CrystalReportViewer crv, string proc, string reportFile, string param = null, object val = null)
{
try
{
//DialogResult dr = MessageBox.Show(param, Convert.ToInt32(val).ToString(), MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation);
SqlCommand cmd = new SqlCommand(proc, MainClass.con);
cmd.CommandType = CommandType.StoredProcedure;
if (param != null && val != null)
{
cmd.Parameters.AddWithValue(param, val);
}
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
rd.Load(Application.StartupPath + "\\Reports\\" + reportFile);
rd.SetDataSource(dt);
crv.ReportSource = rd;
crv.RefreshReport();
}
catch (Exception ex)
{
MainClass.con.Close();
MainClass.ShowMSG(ex.Message, "Error ", "Error");
}
}
public printpreview(string rptfilename, string recordselectionformula)
{
MessageBox.Show(rptfilename);
StartPosition = FormStartPosition.CenterParent;
Size = new Size(550, 400);
ConnectionInfo cni = new ConnectionInfo();
if (gv.mdbfile == "")
{
cni.ServerName = gv.listfile;
}
else
{
cni.ServerName = gv.mdbfile;
}
doc = new ReportDocument();
doc.Load(rptfilename);
doc.RecordSelectionFormula = recordselectionformula;
foreach (Table crtb in doc.Database.Tables)
{
TableLogOnInfo li = crtb.LogOnInfo;
li.ConnectionInfo = cni;
crtb.ApplyLogOnInfo(li);
}
crv = new CrystalReportViewer();
crv.Dock = DockStyle.Fill;
crv.Size = new Size(550, 350);
crv.ToolPanelView = ToolPanelViewType.None;
crv.ReportSource = doc;
crv.RefreshReport();
crv.Parent = this;
}
public void showReport(ReportDocument rep, object[] source)
{
frmReport frm = new frmReport();
CrystalReportViewer report = frm.getviewer();
rep.SetDataSource(source);
report.ReportSource = rep;
report.RefreshReport();
frm.ShowDialog();
}
public Boolean initReport(ReportClass crReport, CrystalReportViewer CrystalReportViewer1, String param, String ParamName)
{
if(param=="" || param==null ) return false;
paramField.ParameterFieldName = ParamName;
discreteVal.Value = param;
paramField.CurrentValues.Add (discreteVal);
paramFields.Add (paramField);
CrystalReportViewer1.ReportSource = crReport;
CrystalReportViewer1.ParameterFieldInfo = paramFields;
CrystalReportViewer1.RefreshReport();
return true;
}
public void DoRefresh()
{
if (opened)
{
if (!_offline)
{
if (RsViewEngine.ProfileManager.Profile.Settings.EmbeddedParamEdit.Enabled)
{
addRptToViewer();
}
else
{
ctlViewer.RefreshReport();
}
}
else
{
DoOnline();
}
}
}
public void showPurchaseInvoiceRecipt(ReportDocument rd, CrystalReportViewer crv, string proc, string param1, object val1)
{
try
{
SqlCommand cmd = new SqlCommand(proc, MainClass.con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue(param1, val1);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
//it is a class for crystal report
//it is a property jdr bi Application ki exe save hogi whan se path utha k le aya ga
rd.Load(Application.StartupPath + "\\Reports\\PurchaseInvoiceRecipt.rpt");
rd.SetDataSource(dt);
crv.ReportSource = rd;
crv.RefreshReport();
}
catch (Exception ex)
{
MainClass.ShowMSG(ex.Message, "Error", "Error");
}
}
public void ShowonCrystalReportSalesInvoice(ReportDocument rdd, CrystalReportViewer crv, string proc, string param1, object val1)
{
try
{
SqlCommand cmd = new SqlCommand(proc, MainClass.con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue(param1, val1);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
rdd.Load(Application.StartupPath + "\\Reports\\CrystalReportSale.rpt");
rdd.SetDataSource(dt);
crv.ReportSource = rdd;
crv.RefreshReport();
}
catch (Exception exp)
{
throw exp;
}
}
/// <summary>
/// 显示报表一次
/// </summary>
/// <param name="parentControl"></param>
/// <param name="FileName"></param>
/// <param name="ds"></param>
/// <returns></returns>
public int ShowReportOnce(System.Windows.Forms.Control parentControl, string FileName, object ds)
{
try
{
ReportDocument rpt = null;
if (ReportViewer.ReportSource == null)
{
rpt = new ReportDocument();
rpt.Load(FileName);
}
else
{
rpt = ReportViewer.ReportSource as ReportDocument;
}
rpt.SetDataSource(ds);
ReportViewer.ReportSource = rpt;
ReportViewer.RefreshReport();
Show(parentControl);
}
catch (Exception ex) { MessageBox.Show(ex.Message); return(-1); }
return(0);
}
protected void Page_Load(object sender, EventArgs e)
{
var fileName = Request.QueryString["fileName"];
var filePath = String.Format("{0}\\{1}", Server.MapPath("~/Reports"), fileName);
var fileInfo = new FileInfo(filePath);
if (fileInfo.Exists == false)
{
ReturnErrorStatusAndShowMessage(fileName);
return;
}
var connectionInfo = GetConnectionInfo();
CrystalDecisions.Web.Report webReport = new CrystalDecisions.Web.Report();
webReport.FileName = filePath;
CrystalReportSource.Report = webReport;
SetDBLogonForReport(connectionInfo, CrystalReportSource.ReportDocument);
CrystalReportViewer.Error += new CrystalDecisions.Web.ErrorEventHandler(delegate(Object o, CrystalDecisions.Web.ErrorEventArgs errorArgs)
{
//ignore missing parameters error (not an error)
if (!errorArgs.ErrorMessage.Contains("Missing parameter values"))
{
ShowFeaturedText(String.Format("Error {0}", errorArgs.ErrorMessage));
}
});
CrystalReportViewer.DataBind();
CrystalReportViewer.RefreshReport();
}
public Boolean printReport(CrystalDecisions.CrystalReports.Engine.ReportClass crReport, CrystalReportViewer CrystalReportViewer1, String param, String ParamName)
{
bool success=false;
if (PrinterName!="none")
{
try
{
paramField.ParameterFieldName = ParamName;
discreteVal.Value = param;
paramField.CurrentValues.Add (discreteVal);
paramFields.Add (paramField);
crReport.DataDefinition.ParameterFields[0].CurrentValues.Add (discreteVal);
CrystalReportViewer1.ReportSource = crReport;
CrystalReportViewer1.ParameterFieldInfo = paramFields;
CrystalReportViewer1.RefreshReport();
ParameterValues tmpParam = new ParameterValues();
tmpParam.Add(discreteVal);
crReport.DataDefinition.ParameterFields[0].ApplyCurrentValues(tmpParam);
crReport.PrintOptions.PrinterName = PrinterName;
//crReport.PrintToPrinter(1,false,1,1);
crReport.PrintToPrinter(1,false,1,99);
success=true;
}
catch{}
}
return success;
}
public Boolean initReport(ReportClass crReport, CrystalReportViewer CrystalReportViewer1, String param1, String ParamName1, String param2, String ParamName2)
{
if(param1=="" || param1==null ) return false;
if(param2=="" || param2==null ) return false;
paramField.ParameterFieldName = ParamName1;
discreteVal.Value = param1;
paramField.CurrentValues.Add (discreteVal);
paramFields.Add (paramField);
crReport.DataDefinition.ParameterFields[0].CurrentValues.Add (discreteVal);
paramField2.ParameterFieldName = ParamName2;
discreteVal2.Value = param2;
paramField2.CurrentValues.Add (discreteVal2);
paramFields.Add (paramField2);
crReport.DataDefinition.ParameterFields[1].CurrentValues.Add (discreteVal2);
CrystalReportViewer1.ReportSource = crReport;
CrystalReportViewer1.ParameterFieldInfo = paramFields;
CrystalReportViewer1.RefreshReport();
return true;
}
