locked
The report you requested requires further information RRS feed

  • Question

  • User1940564824 posted

     

    Hi All
    I am displaying my record through crystal report ,its working properly,but when i click to print ,export ,next or any 
    other button in crystal report viewer its dispaly the "The report you requested requires further information" , even i have created the connection
    on page load event also.
    here i am sending my code pls help me........

    protected void Page_Load(object sender, EventArgs e)
        {       
            ConnectCrystalReport();     
        }
    
    protected void ConnectCrystalReport()
        {
            ConnectionInfo ci = new ConnectionInfo();
            ci.ServerName = "216.67.248.49";
            ci.DatabaseName = "KBCL_MegaMart_sql";
            ci.UserID = "####";
            ci.Password = "####";
    
            foreach (TableLogOnInfo cninfo in this.CrystalReportViewer1.LogOnInfo)
            {
                cninfo.ConnectionInfo = ci;
            }
        }
    protected void btnShow_Click(object sender, EventArgs e)
        {       
                    popGrid1();           
        }


    protected void popGrid1()
        {
            ConnectCrystalReport();
            DateTime FDate = DateTime.Parse(txtFDate.Text + " 12:00:00 AM");
            DateTime LDate = DateTime.Parse(txtToDate.Text + " 11:59:59 PM");       
    
            query = "select S.Inv_ID,S.Inv_No,S.MTO_ID,";
            query += " S.Inv_Date,S.Amt,S.Tax_Amt,S.Total_Amt";
            query += " FROM MTOSale_Table S where S.MTO_ID='" + Session["MTOID"] + "'";
            query += " and (S.Inv_Date>='" + FDate + "' and S.Inv_Date<='" + LDate + "') and S.Bill_Status='Active' ";
            query+=" order by  S.Inv_Date desc ";
    
            SqlDataAdapter da = new SqlDataAdapter(query, MainWebClass.con);
            DataTable dt = new DataTable();
            da.Fill(dt);
            rpt.Load(Server.MapPath("crp4.rpt"));
            rpt.SetDataSource(dt);
            rpt.SetDatabaseLogon("userid", "password", @"datasource", "dbname");
            CrystalReportViewer1.ReportSource = rpt;
            CrystalReportViewer1.RefreshReport();       
    
        }

     

     

    Monday, May 16, 2011 11:51 PM

Answers

  • User1048482649 posted

    It is a known issue and there could be many reasons for that. I would suggest you to try the various solutions provided at the below mentioned link. I am sure one of them should work for you:-

     

    http://forums.asp.net/t/1026635.aspx/1/10?The+report+you+requested+requires+further+information

     

    HTH

    Ritesh

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, May 17, 2011 7:44 AM

All replies

  • User1048482649 posted

    It is a known issue and there could be many reasons for that. I would suggest you to try the various solutions provided at the below mentioned link. I am sure one of them should work for you:-

     

    http://forums.asp.net/t/1026635.aspx/1/10?The+report+you+requested+requires+further+information

     

    HTH

    Ritesh

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, May 17, 2011 7:44 AM
  • User1196771204 posted

    hi jaismile,

    does the thread on http://forums.asp.net/t/1026635.aspx/1/10?The+report+you+requested+requires+further+information help you?

    Monday, May 23, 2011 1:10 AM