dyaamic crystal report by multiple parameter

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • pupilstuff
    New Member
    • Jun 2009
    • 18

    dyaamic crystal report by multiple parameter

    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 ();
    ParameterDiscre teValue paramDiscreteVa lue = new ParameterDiscre teValue();

    paramField.Name = "@Dept";
    paramDiscreteVa lue.Value = TextBox1.Text.T oString();
    paramField.Curr entValues.Add(p aramDiscreteVal ue);
    paramFields.Add (paramField);

    paramField.Name = "@Name";
    paramDiscreteVa lue.Value = TextBox2.Text.T oString();
    paramField.Curr entValues.Add(p aramDiscreteVal ue);
    paramFields.Add (paramField);

    CrystalReportVi ewer1.Parameter FieldInfo = paramFields;
    reportDocument. Load(Server.Map Path("CrystalRe port.rpt"));
    CrystalReportVi ewer1.ReportSou rce = reportDocument;
    reportDocument. SetDatabaseLogo n("sa", "sa", "OPWFMS-7KYGZ7SB", "test");

    }
    plz let me knw any chnges
  • mzmishra
    Recognized Expert Contributor
    • Aug 2007
    • 390

    #2
    Do your crystal report takes two parameter?Did you check the datatype of input parameter?

    Comment

    • pupilstuff
      New Member
      • Jun 2009
      • 18

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

      Comment

      Working...