TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Nel
NA
716
1.1m
Error message "No value given for one or more required parameters"-Crystal Reports using dataset
Nov 15 2011 2:39 AM
Hi,
I have a Crystal Report and I use dataset and OleDbDataAdapter to get the values that the user chose on the form.
Here is my code:
ReportDocument cryRpt = new ReportDocument();
string comstring = "SELECT NOVI.GBR, NOVI.AB, NALOG1.DATA,Min(NALOG1.POCKM) AS MinOfPOCKM,Max(NALOG1.KRAJKM) AS MaxOfKRAJKM,(Max(NALOG1.KRAJKM)-Min(NALOG1.POCKM)) AS RAZLIKA FROM (NALOG1 INNER JOIN MAGACIN ON NALOG1.GBRV=MAGACIN.GBR) INNER JOIN NOVI ON NALOG1.GBRV=NOVI.GBR where ( ( (NOVI.GBR)>='?' And (NOVI.GBR)<='?' ) AND ( (NOVI.AB)='?' or (NOVI.AB)='?' ) AND ( ( (NALOG1.DATA)>=?) and ((NALOG1.DATA)<=?) ) ) GROUP BY NOVI.GBR, NOVI.AB, NALOG1.DATA";
OleDbCommand command = new OleDbCommand();
command.Connection = conn;
command.CommandText = comstring;
if (radioButton4.Checked==true){
command.Parameters.AddWithValue("@gbr1", textBox1.Text);
command.Parameters.AddWithValue("@gbr2", textBox1.Text);
}
if (radioButton5.Checked==true){
command.Parameters.AddWithValue("@gbr1", "1001");
command.Parameters.AddWithValue("@gbr2", "1080");
}
if (radioButton6.Checked==true){
command.Parameters.AddWithValue("@gbr1","1081" );
command.Parameters.AddWithValue("@gbr2", "1149");
}
if (radioButton7.Checked == true)
{
command.Parameters.AddWithValue("@gbr1", "1001");
command.Parameters.AddWithValue("@gbr2", "1149");
}
if(checkBox1.Checked==true){
command.Parameters.AddWithValue("@ab1", 1);
command.Parameters.AddWithValue("@ab2", 1);
}
else if (checkBox2.Checked==true)
{
command.Parameters.AddWithValue("@ab1", 2);
command.Parameters.AddWithValue("@ab2", 2);
}
else if((checkBox1.Checked==true) && (checkBox2.Checked==true))
{
command.Parameters.AddWithValue("@ab", 1);
command.Parameters.AddWithValue("@ab",2);
}
command.Parameters.AddWithValue("@data1", dateTimePicker1.Value);
command.Parameters.AddWithValue("@data2", dateTimePicker2.Value);
DataSet dataSet2=new DataSet();
conn.Open();
OleDbDataAdapter oleDBDataAdapter1 = new OleDbDataAdapter(new OleDbCommand(comstring, conn));
OleDbCommand command1 = new OleDbCommand();
command1.Connection = conn;
oleDBDataAdapter1.SelectCommand.CommandText=comstring;
dataSet2.Clear();
oleDBDataAdapter1.Fill(dataSet2);
cryRpt.SetDataSource(dataSet2);
crystalReportViewer1.DisplayToolbar=true;
cryRpt.Load(@"E:\Potrosuvacka-Pregledi\Potrosuvacka-Pregledi\CrystalReport1.rpt");
crystalReportViewer1.ReportSource = cryRpt;
cryRpt.PrintOptions.PaperOrientation = CrystalDecisions.Shared.PaperOrientation.Landscape;
crystalReportViewer1.Refresh();
conn.Close();
System.Data.OleDb.OleDbException was unhandled
Message="No value given for one or more required parameters."
Could anybody help me please?
Thanks in advance
Reply
Answers (
3
)
Crystal report objects by their position ?
Automatically Generate SSRS Reports with some parameters and export to excel and save in some path