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
Loading
Pravin GhadgePosted Feb 18, 2012, 9:38 AM
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("stroutwardno",stroutwardno);
}
}
catch
{
MessageBox.Show("Select Invoice Number");
}
crystalReportViewer1.ReportSource = rpt;
crystalReportViewer1.Refresh();
con.Close();
}
}
}
swapnil jatkarPosted Feb 19, 2012, 8:08 AM
swapnil jatkarPosted Feb 18, 2012, 7:55 AM
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(pf,rpt.ParameterFields.Find("outward","GeneralBill1"));
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 GhadgePosted Feb 18, 2012, 7:41 AM
Plz show me ur code snippet.