Please could someone help me, I am new and I am trying my first ever crystal report. The only crystal report i have is bundled with vb.net 2005 version. I have read lots of articals and followed examplews BUT i still get the Parameter entry page coming up. I have a stored procedure which had 5 variables declared. The stored procedure works!!

Thanks in advance

the code i am using is

using System;
using System.Data;
using System.Configuration;
using System.Data.SqlClient; /*Enables SqlConnection and get data from database without can not use SqlConnection */
using System.Collections;
using System.IO;
using System.Web;
using System.Web.Services;
using System.Web.Security;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using CrystalDecisions.CrystalReports.Engine;
using CrystalDecisions.Shared;
using System.Globalization;




public partial class Default2 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        ReportDocument cr = new ReportDocument();
        ParameterField paramField = new ParameterField();
        ParameterFields Paramfields = new ParameterFields();
        ParameterDiscreteValue paramDiscretevalue = new ParameterDiscreteValue();

        paramField.Name = "@AssignRole";
        paramDiscretevalue.Value = "0";
        paramField.CurrentValues.Add(paramDiscretevalue);
        Paramfields.Add(paramField);

        paramField = new ParameterField();
        paramField.Name = "@ProjectID";
        paramDiscretevalue = new ParameterDiscreteValue();
        paramDiscretevalue.Value = "0";
        paramField.CurrentValues.Add(paramDiscretevalue);
        Paramfields.Add(paramField);

        paramField = new ParameterField();
        paramField.Name = "@Role";
        paramDiscretevalue = new ParameterDiscreteValue();
        paramDiscretevalue.Value = "1";
        paramField.CurrentValues.Add(paramDiscretevalue);
        Paramfields.Add(paramField);

        paramField = new ParameterField();
        paramField.Name = "@StaffID";
        paramDiscretevalue = new ParameterDiscreteValue();
        paramDiscretevalue.Value = "0";
        paramField.CurrentValues.Add(paramDiscretevalue);
        Paramfields.Add(paramField);

        paramField = new ParameterField();
        paramField.Name = "@TaskType";
        paramDiscretevalue = new ParameterDiscreteValue();
        paramDiscretevalue.Value = "1";
        paramField.CurrentValues.Add(paramDiscretevalue);
        Paramfields.Add(paramField);

        cr.Load(@"C:\Web Sites\NODDY\OutstandingIssuelReport.rpt");
        CrystalReportViewer1.ReportSource = cr;
        CrystalReportViewer1.ParameterFieldInfo = Paramfields;
        CrystalReportViewer1.DataBind();
        CrystalReportViewer1.RefreshReport();

Require the following namespaces
using CrystalDecisions.CrystalReports.Engine;
using CrystalDecisions.ReportSource;
using CrystalDecisions.Windows.Forms;
using CrystalDecisions.Shared;


ReportDocument cr = new ReportDocument();
ParameterValues parameter1 = new ParameterValues();
ParameterDiscreteValue parametervalue = new ParameterDiscreteValue();

//Make sure you have the the correct mapPath set
cr.Load(Server.MapPath("testCrystalReport.rpt"));

//Set the parameters of the stored procedure
parametervalue.Value = Session["project"];
parameter1.Add(parametervalue);
cr.DataDefinition.ParameterFields["@ProjectID"].ApplyCurrentValues(parameter1);

parametervalue.Value = Session["staff"];
parameter1.Add(parametervalue);
cr.DataDefinition.ParameterFields["@StaffID"].ApplyCurrentValues(parameter1);

//Set a value from result set of a query
parametervalue.Value = ViewState["ProjName"];
parameter1.Add(parametervalue);
cr.DataDefinition.ParameterFields["NameofProject"].ApplyCurrentValues(parameter1);

//Refresh the report
CrystalReportViewer1.ReportSource = cr;

Yazzy
Springwater Software Ltd