Good Morning,
This is Rajesh, am having a problem with Crystal Report in ASP.NET with C# using Visual Studios 2008. That is
1. I have created a DataSet and drag one "View" from Solution Explorer.
2. Next I have created one Crystal Report add data from Project data -> ADO.NET Datasets -> "View".
3. Then created a webform add a TextBox for enter date (I want report based on date field DOP on database) and a button called "BtnShow" and Witten code under the button is as follows.
protected void BtnShow_Click(object sender, EventArgs e)
{
SqlConnection cn = new SqlConnection();
cn.ConnectionString = ConfigurationManager.ConnectionStrings["DBConn"].ConnectionString;
SqlDataAdapter adp = new SqlDataAdapter("SELECT EMP_ID, EMP_NAME, BANK_NAME, AC_NO, DOP FROM VIEW WHERE DOP = '" +Convert.ToDateTime(TxtDate.Text)+ "'", cn);
DataSet DS = new DataSet();
adp.Fill(DS);
ReportDocument cr = new ReportDocument();
cr.Load("C:\\Report Path Here\\Report.rpt");
cr.SetDataSource(DS.Tables[0]);
CrystalReportViewer1.ReportSource = cr;
CrystalReportViewer1.RefreshReport();
}
4. When I run the project it working perfectly alright for different date which was in database.
5. But the problem is when I attempt to export or print or any option in the report header (Default options), it asks the login details. If I enter correct details then it didn't show anything, It shows only login page again and again.
6. What to do?
7. Kindly help me. Thanks.