my report has the same data everytime I access it

In my web app, my report has the same data everytime I access it. I DO NOT have the Save Data with Report checked.  The only data that comes up is the data that gets displayed in design time.

I am updating my parameters but when i trace the stored procedure calls the parameters are not updated.

The data doesn't update whether I use crystal viewer or generate the report in pdf.

I am using crystal 9 advanced, Windows 2003, SQL Server. I have been at this for sometime now and cannot get it figured out!

Any help would be great.

Thanks, Jordan


using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.IO;
using System.Collections.Specialized;
using System.Configuration;

using CrystalDecisions.Web;
using CrystalDecisions.CrystalReports.Engine;
using CrystalDecisions.Shared;

using JHS.App.Reports.CrystalFiles;

namespace JHS.App.Reports
{
      /// <summary>
      /// Summary description for InmateReport.
      /// </summary>
      public class InmateReport : System.Web.UI.Page
      {

            protected ReportDocument crReportDocument = new CustomerGeneralReport();

            protected string _ID1;
            protected string _ID2;
            protected string _ID3;

            protected string url;

            ConnectionInfo crConnectionInfo;
            TableLogOnInfo crtableLogoninfo;
            protected CrystalDecisions.Web.CrystalReportViewer CrystalReportViewer1;
            Tables crTables;

            private void Page_Load(object sender, System.EventArgs e)
            {
                  // Put user code to initialize the page here

                  url = ConfigurationSettings.AppSettings["URL"];
                  Response.Expires=-1;

                  try
                  {

                  HttpContext ctx = HttpContext.Current;
                  HttpCookie inCookie = ctx.Request.Cookies["2JHS3"];
                  if(inCookie != null)
                  {
                        _ID1= inCookie.Values["ID1"].ToString();
                        _ID2= inCookie.Values["ID2"].ToString();
                        _ID3= inCookie.Values["ID3"].ToString();
                  }


                        crConnectionInfo = new ConnectionInfo();
                        crReportDocument.SetParameterValue("@param1", _ID1);
                        crReportDocument.SetParameterValue("@param2", _ID2);
                        crReportDocument.SetParameterValue("@param3", _ID3);

      
                        crConnectionInfo.ServerName = ConfigurationSettings.AppSettings["SERVER_NAME"];
                        crConnectionInfo.DatabaseName = ConfigurationSettings.AppSettings["DBNAME"];
                        crConnectionInfo.UserID = ConfigurationSettings.AppSettings["USERID"];
                        crConnectionInfo.Password = ConfigurationSettings.AppSettings["PASSWORD"];

                        crTables = crReportDocument.Database.Tables;

                        //Loop through each table in the report and apply the
                        //LogonInfo information
                        foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in crTables)
                        {
                              crtableLogoninfo = crTable.LogOnInfo;
                              crtableLogoninfo.ConnectionInfo = crConnectionInfo;
                              crTable.ApplyLogOnInfo(crtableLogoninfo);
                              crTable.Location = crConnectionInfo.DatabaseName + ".dbo." + crTable.Location.Substring(crTable.Location.LastIndexOf(".") + 1);
                        }

                        CrystalReportViewer1.ReportSource = crReportDocument;
                        CrystalReportViewer1.Visible = true;
                        /*
                        System.IO.Stream st;
                        st = crReportDocument.ExportToStream(ExportFormatType.PortableDocFormat);

                        Response.ClearContent();
                        Response.ClearHeaders();
                        Response.Expires=-1;
                        Response.ContentType = "application/PDF";
                        byte[] b = new byte[st.Length];
                        st.Read(b,0,(int) st.Length);
                        Response.BinaryWrite(b);
                        crReportDocument.Close();
                        Response.Flush();
                        Response.Close();
                        */
                  }
                        catch (FormatException ex)
                  {
                        Response.Write(ex.ToString());
      }