Connecting Tech Pros Worldwide Forums | Help | Site Map

dyaamic crystal report by multiple parameter

Newbie
 
Join Date: Jun 2009
Posts: 18
#1: Jun 17 '09
hi friends
i am creating crytal report frm the stored procedure ,this works fine when i pass one parameter but it shows an error "incorrect parameter " whn i pass two parameter
my code is
{
ReportDocument reportDocument = new ReportDocument();
ParameterField paramField = new ParameterField();
ParameterFields paramFields = new ParameterFields();
ParameterDiscreteValue paramDiscreteValue = new ParameterDiscreteValue();

paramField.Name = "@Dept";
paramDiscreteValue.Value = TextBox1.Text.ToString();
paramField.CurrentValues.Add(paramDiscreteValue);
paramFields.Add(paramField);

paramField.Name = "@Name";
paramDiscreteValue.Value = TextBox2.Text.ToString();
paramField.CurrentValues.Add(paramDiscreteValue);
paramFields.Add(paramField);

CrystalReportViewer1.ParameterFieldInfo = paramFields;
reportDocument.Load(Server.MapPath("CrystalReport. rpt"));
CrystalReportViewer1.ReportSource = reportDocument;
reportDocument.SetDatabaseLogon("sa", "sa", "OPWFMS-7KYGZ7SB", "test");

}
plz let me knw any chnges

Expert
 
Join Date: Aug 2007
Location: nj,usa
Posts: 313
#2: Jun 19 '09

re: dyaamic crystal report by multiple parameter


Do your crystal report takes two parameter?Did you check the datatype of input parameter?
Newbie
 
Join Date: Jun 2009
Posts: 18
#3: Jun 19 '09

re: dyaamic crystal report by multiple parameter


hi ,
thnsk fr repaly i solved that problem actulay i forget to put the second parameter in crystal report
Reply