CODEWITHSUNDEEP
c#asp.netcrystal-reports
Ayyappan Anbalagan
Ayyappan Anbalagan

Reputation: 11292

how to solve this Problem in asp.net crystal report

Problem in crystal report After excecuting the bellow code,In my report page it ask like "The report you requested requires further information" server= user= password= databse=

protected void Page_Load(object sender, EventArgs e)
{
    MySqlConnection sqlcom = new MySqlConnection("server=localhost;userid=root;password=root;database=hemaepdb;");
    MySqlCommand cmd = new MySqlCommand("SP_ViewBillDetails", sqlcom);
    cmd.CommandType = CommandType.StoredProcedure;
    cmd.Parameters.Add("p_Invoice_Id", MySqlDbType.Int16).Value = 1;
    cmd.Parameters.Add("p_Org_id", MySqlDbType.Int16).Value = 1;
    MySqlDataAdapter adapter = new MySqlDataAdapter(cmd);
    DataSet dsTest = new DataSet();
    sqlcom.Open();
    adapter.Fill(dsTest, "Table");
    sqlcom.Close();
    CrystalReportViewer1.Visible = true;
    ReportDocument myRpt = new ReportDocument();
    myRpt.Load(Server.MapPath("CrystalReport.rpt"));
    myRpt.SetDatabaseLogon("root", "root", "localhost", "hemaepdb");
    myRpt.SetDataSource(dsTest);
    CrystalReportViewer1.ReportSource = myRpt;
}

Upvotes: 1

Views: 1014

Answers (1)

djdd87
djdd87

Reputation: 68456

Use a DataTable instead of a DataSet:

myRpt.SetDataSource(dsTest.Tables[0]);

And add the following to the end of the method:

CrystalReportViewer1.DisplayGroupTree = false;
CrystalReportViewer1.DataBind();

Upvotes: 2

Related Questions