how to avoid the prompt dialoque in crystal report during loading

Question

I am working with the crystal report & I used the command as datasource for viewing data in the report. I used a parameter in that command. I passed value from a combo box to that parameter & it is working fine but when the reports gets load, a prompt dialogue appears which asks for a value to enter whereas i am providing the value to that parameter through combo box. I don't want that prompt to appear. Please help & tell me how can I avoid that prompt from display.

Thanks

Pravin Ghadge · Answer

Try this public void button1_Click(object sender EventArgs e) { OleDbConnection con = new OleDbConnection(ConnectionString); DataSet dtReport = new DataSet(); con.Open(); string query = SELECT Additems.Grade Additems.Qty Additems.Rate Additems.bAmt Additems.Outward_bill_ID AS Additems_Outward_bill_ID dbo_Outward_Billing.Name_of_Party dbo_Outward_Billing.Addrs dbo_Outward_Billing.BillDate dbo_Outward_Billing.Project_Site dbo_Outward_Billing.DeliveryNote dbo_Outward_Billing.Vehicle_no dbo_Outward_Billing.DespatchDocNo dbo_Outward_Billing.BuyerOrderNo dbo_Outward_Billing.Destination dbo_Outward_Billing.modepay dbo_Outward_Billing.SuppRef dbo_Outward_Billing.DespatchDate dbo_Outward_Billing.BuyerDate dbo_Outward_Billing.iAmt dbo_Outward_Billing.Excise_duty dbo_Outward_Billing.ED_cess dbo_Outward_Billing.SHED_cess dbo_Outward_Billing.Sub_Total dbo_Outward_Billing.Vat dbo_Outward_Billing.Total_Amount dbo_Outward_Billing.Outward_bill_ID AS dbo_Outward_Billing_Outward_bill_ID FROM dbo_Outward_Billing RIGHT OUTER JOIN Additems ON dbo_Outward_Billing.[Outward_bill_ID] = Additems.[Outward_bill_ID] WHERE Additems.Outward_bill_ID=  + comboBox1.SelectedItem +  ; OleDbDataAdapter Adapter = new OleDbDataAdapter(query con); rpt.SetDataSource(dtReport); TextObject myTextObjectOnReport; try { if (rpt.ReportDefinition.ReportObjects[txtBill_No] != null) { myTextObjectOnReport = (TextObject)rpt.ReportDefinition.ReportObjects[txtBill_No]; //rpt.SetParameterValue(outwardno comboBox1.SelectedItem.ToString()); string stroutwardno= comboBox1.SelectedItem.ToString(); ParameterFields myparam = new ParameterFields(); ParameterField param1 = new ParameterField(); ParameterDiscreteValue dv1 = new ParameterDiscreteValue(); param1.ParameterFieldName = outwardno; dv1.Value = stroutwardno; param1.CurrentValues.Add(dv1); myparam.Add(param1); crystalReportViewer1.ParameterFieldInfo = myparam; rpt .SetParameterValue(stroutwardnostroutwardno); } } catch { MessageBox.Show(Select Invoice Number); } crystalReportViewer1.ReportSource = rpt; crystalReportViewer1.Refresh(); con.Close(); } } }

swapnil jatkar · Answer

Thank a lot....

swapnil jatkar · Answer

using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using CrystalDecisions.CrystalReports.Engine; using CrystalDecisions.Shared; using System.Data.OleDb; namespace SJPproject { public partial class RPTBill : Form { public RPTBill() { InitializeComponent(); } ReportDocument rpt = new ReportDocument(); OleDbCommand cmd; OleDbDataReader dr; string ConnectionString = System.Configuration.ConfigurationSettings.AppSettings[sjp]; private void RPTBill_Load(object sender EventArgs e) { rpt.Load(@D:\09-01-2012\SJPproject\Report\GeneralBill.rpt); ParameterField pf = new ParameterField(); ParameterField.Equals(pfrpt.ParameterFields.Find(outwardGeneralBill1)); pf.CurrentValues = 00; pf.EnableNullValue = true; BindBill_No(); } public void BindBill_No() { OleDbConnection con = new OleDbConnection(ConnectionString); con.Open(); string str = select Outward_bill_ID from dbo_Outward_Billing; OleDbCommand com = new OleDbCommand(str con); OleDbDataReader reader = com.ExecuteReader(); while (reader.Read()) { comboBox1.Items.Add(reader[Outward_bill_ID]); //combo_billno.DisplayMember = Outward_bill_ID; //combo_billno.ValueMember = Outward_bill_ID; } reader.Close(); con.Close(); } public void button1_Click(object sender EventArgs e) { OleDbConnection con = new OleDbConnection(ConnectionString); DataSet dtReport = new DataSet(); con.Open(); string query = SELECT Additems.Grade Additems.Qty Additems.Rate Additems.bAmt Additems.Outward_bill_ID AS Additems_Outward_bill_ID dbo_Outward_Billing.Name_of_Party dbo_Outward_Billing.Addrs dbo_Outward_Billing.BillDate dbo_Outward_Billing.Project_Site dbo_Outward_Billing.DeliveryNote dbo_Outward_Billing.Vehicle_no dbo_Outward_Billing.DespatchDocNo dbo_Outward_Billing.BuyerOrderNo dbo_Outward_Billing.Destination dbo_Outward_Billing.modepay dbo_Outward_Billing.SuppRef dbo_Outward_Billing.DespatchDate dbo_Outward_Billing.BuyerDate dbo_Outward_Billing.iAmt dbo_Outward_Billing.Excise_duty dbo_Outward_Billing.ED_cess dbo_Outward_Billing.SHED_cess dbo_Outward_Billing.Sub_Total dbo_Outward_Billing.Vat dbo_Outward_Billing.Total_Amount dbo_Outward_Billing.Outward_bill_ID AS dbo_Outward_Billing_Outward_bill_ID FROM dbo_Outward_Billing RIGHT OUTER JOIN Additems ON dbo_Outward_Billing.[Outward_bill_ID] = Additems.[Outward_bill_ID] WHERE Additems.Outward_bill_ID=  + comboBox1.SelectedItem +  ; OleDbDataAdapter Adapter = new OleDbDataAdapter(query con); rpt.SetDataSource(dtReport); TextObject myTextObjectOnReport; try { if (rpt.ReportDefinition.ReportObjects[txtBill_No] != null) { myTextObjectOnReport = (TextObject)rpt.ReportDefinition.ReportObjects[txtBill_No]; rpt.SetParameterValue(outwardno comboBox1.SelectedItem.ToString()); } } catch { MessageBox.Show(Select Invoice Number); } crystalReportViewer1.ReportSource = rpt; crystalReportViewer1.Refresh(); con.Close(); } } }

Pravin Ghadge · Answer

Hi Swapnil Plz show me ur code snippet.