I m using push method,whats wrong in this code,why it ask for The report you requested requires further information.thanks in advance [/B]


using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
using System.Web.Services;
using System.Collections.Generic;
using CrystalDecisions.Shared;
using CrystalDecisions.CrystalReports.Engine;

public partial class CrystalReportProformaInvoice : System.Web.UI.Page
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrin gs["Connection"].ConnectionString);
SqlCommand cmdPrintReportInformation = new SqlCommand();
ReportDocument MyReport = new ReportDocument();
string server = @"EOTREENA\SQLEXPRESS";
string database = "Inventory";
string user = "UserInventory";
string password = "admin";

public static string strProformaInvoiceID;
protected void Page_Load(object sender, EventArgs e)
{
strProformaInvoiceID = Session["ProformaInvoiceID"].ToString();
cmdPrintReportInformation = new SqlCommand("SP_PrintReport_SD_ProformaInvoiceInfor mation_View", con);
cmdPrintReportInformation.CommandType = CommandType.StoredProcedure;
cmdPrintReportInformation.Parameters.AddWithValue( "@ProformaInvoiceID", strProformaInvoiceID);
con.Open();
SqlDataAdapter da = new SqlDataAdapter(cmdPrintReportInformation);
DataSet1 ds = new DataSet1();
da.Fill(ds, "ProformaInvoice");
MyReport.Load(Server.MapPath("ProformaInvoiceCryst alReport.rpt"));
MyReport.SetDataSource(ds.Tables["ProformaInvoice"]);
SetConnectionInfo(server, database, user, password);
CrystalReportViewer1.ReportSource = MyReport;
CrystalReportViewer1.DataBind();
con.Close();
}
public void SetConnectionInfo(string server, string database, string user, string password)
{
TableLogOnInfo logOnInfo = new TableLogOnInfo();
logOnInfo = MyReport.Database.Tables[0].LogOnInfo;
ConnectionInfo connectionInfo = new ConnectionInfo();
connectionInfo = logOnInfo.ConnectionInfo;
connectionInfo.DatabaseName = database;
connectionInfo.ServerName = server;
connectionInfo.UserID = user;
connectionInfo.Password = password;
MyReport.Database.Tables[0].ApplyLogOnInfo(logOnInfo);
}
}