problem with crystal report in aspnet

Vishnu Suresh

I have a web program in which datas are to be printed using crystal report. The front end in asp.net and back end is sql. Now I have created the crystal report to display the data. But the problem is it is showing all the datas in the table. I need to show only specific data.

If the user type Code number 11124 on the textbox then the crystal report need to show the data relate to code 11124. But now its showing all the datas in the table.

How can I do this.

protected void Page_Load(object sender, EventArgs e)

{

ReportDocument crystalReport = new ReportDocument();

crystalReport.Load(Server.MapPath("CrystalReport4.rpt"));

crystalReport.SetDatabaseLogon

("name"@passwd", @"databasename)

CrystalReportViewer1.ReportSource = crystalReport;

}

This is the code to show the crystal report viewer. Is there any way here I can put the sql statement like select * from table where code=@code.

19 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ravi Kumar11y ago
Accepted answer
that is stored procedure instead of the you can call your query
Ravi Kumar11y ago
server name and db name not required
Vishnu Suresh11y ago
3rd is server name and 4th is database name. Sir I have checked the code. When I give the code in page load it didnt give any error and I can print. But when I given this in button event its shows this password error at the time of printing.
Ravi Kumar11y ago
crystalReport.SetDatabaseLogon("sa", "password", @"SVR2015", "dbname");
what is 3rd and 4th parameters
Vishnu Suresh11y ago
The database password is "password". And for this code I am previously using is working perfectly. ReportDocument crystalReport = new ReportDocument();

crystalReport.Load(Server.MapPath("CrystalReport4.rpt"));
crystalReport.SetDatabaseLogon("sa", "password", @"SVR2015", "dbname");

CrystalReportViewer1.ReportSource = crystalReport;

But when I use the code below or I gave two parameter as you told its not working and its asking the password again.

String str = "select top 20 * from Qtattemp where (CODE like + @search + '%')ORDER BY CODE ASC ;";
SqlCommand xp = new SqlCommand(str, con);
xp.Parameters.Add("@search", SqlDbType.VarChar).Value = TextBox1.Text;
con.Open();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = xp;
da.Fill(dt);
con.Close();
if (dt.Rows.Count > 0)
{
ReportDocument crystalReport = new ReportDocument();
crystalReport.Load(Server.MapPath("CrystalReport4.rpt"));
crystalReport.SetDatabaseLogon("sa", "password", @"SVR2015", "dbname");
crystalReport.SetDataSource(dt);
CrystalReportViewer1.ReportSource = crystalReport;
CrystalReportViewer1.DataBind();

This code shows the error.
Ravi Kumar11y ago
did you give db pwd or what password you given
Vishnu Suresh11y ago
Yes I have given two parameter, but its asking password
Ravi Kumar11y ago
your given 4 parameters in below line
crystalReport.SetDatabaseLogon("sa", "password", @"SVR2015", "dbname");
you should give only 2 parameters
crystalReport.SetDatabaseLogon("sa", "password");
dont give db name
just give db user name and password
Vishnu Suresh11y ago
I have executed the code as u given. but the same error happening. It is asking password. But for this code it didnt asking any password.

ReportDocument crystalReport = new ReportDocument();

crystalReport.Load(Server.MapPath("CrystalReport4.rpt"));

crystalReport.SetDatabaseLogon("sa", "password", @"SVR2015", "dbname");

CrystalReportViewer1.ReportSource = crystalReport;
Ravi Kumar11y ago
crystalReport.SetDatabaseLogon("sa", "password", @"SVR2015", "dbname");
change as fallows
crystalReport.SetDatabaseLogon("sa", "admin");
Vishnu Suresh11y ago
Sir, its working,but have one error with the login.After clicking on print, it ask about password. here is the code. I already given the user name and password, but it is again asking.

protected void Button1_Click(object sender, EventArgs e)

{

String str = "select top 20 * from Qtattemp where (CODE like + @search + '%')ORDER BY CODE ASC ;";

SqlCommand xp = new SqlCommand(str, con); xp.Parameters.Add("@search",

SqlDbType.VarChar).Value = TextBox1.Text; con.Open();

SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = xp; da.Fill(dt); con.Close();

if (dt.Rows.Count > 0) { ReportDocument crystalReport = new ReportDocument();

crystalReport.Load(Server.MapPath("CrystalReport4.rpt")); crystalReport.SetDatabaseLogon("sa", "password", @"SVR2015", "dbname"); crystalReport.SetDataSource(dt);

CrystalReportViewer1.ReportSource = crystalReport; CrystalReportViewer1.DataBind();
}
pls help
Ravi Kumar11y ago
wc
Vishnu Suresh11y ago
Thank you sir for your great help. Its working. Thank you.
Vishnu Suresh11y ago
Sir this usp_inspectionPendingDetails means
Ravi Kumar11y ago
ReportDocument MedicalReport = new ReportDocument();
Vishnu Suresh11y ago
Sir, could u pls tell me wat that MedicalReport indicates. Its ur page of crystal report
Ravi Kumar11y ago
check the fallowing code

SqlDataAdapter da1 = new SqlDataAdapter("usp_inspectionPendingDetails", con);
da1.SelectCommand.CommandType = CommandType.StoredProcedure;
da1.SelectCommand.Parameters.AddWithValue("@Customer", txtCustomer.text);
dt.Clear();
da1.Fill(dt);
if (dt.Rows.Count > 0)
{
MedicalReport.Load(Server.MapPath("InspectionPendingReport.rpt"));
MedicalReport.SetDataSource(dt);
CrystalReportViewer1.ReportSource = MedicalReport;
CrystalReportViewer1.DataBind();
}
Vishnu Suresh11y ago
@Ravi, I need to add theses sql commands to it. How can I add. only display the data from table where code [email protected] I need to intialise code=textbox1.text. When I enter code in textbox then it will displaying regarding data from database and show in crystal report.
Ravi Kumar11y ago
include the fallowing line
CrystalReportViewer1.DataBind();