problem with crystal report in aspnet

Question

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.

Ravi Kumar · Answer

that is stored procedure instead of the you can call your query

Ravi Kumar · Answer

ReportDocument MedicalReport = new ReportDocument();

Vishnu Suresh · Answer

Sir could u pls tell me wat that MedicalReport indicates. Its ur page of crystal report

Ravi Kumar · Answer

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(); }

Ravi Kumar · Answer

server name and db name not required

Vishnu Suresh · Answer

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 Kumar · Answer

crystalReport.SetDatabaseLogon(sa password @SVR2015 dbname); what is 3rd and 4th parameters

Vishnu Suresh · Answer

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 Kumar · Answer

did you give db pwd or what password you given

Vishnu Suresh · Answer

Yes I have given two parameter but its asking password

Ravi Kumar · Answer

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 Suresh · Answer

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 Kumar · Answer

crystalReport.SetDatabaseLogon(sa password @SVR2015 dbname); change as fallows crystalReport .SetDatabaseLogon(sa admin);

Vishnu Suresh · Answer

Sir its workingbut 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 Kumar · Answer

wc

Vishnu Suresh · Answer

Thank you sir for your great help. Its working. Thank you.

Vishnu Suresh · Answer

Sir this usp_inspectionPendingDetails means

Vishnu Suresh · Answer

@Ravi I need to add theses sql commands to it. How can I add. only display the data from table where code =@code.THen 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 Kumar · Answer

include the fallowing line CrystalReportViewer1.DataBind();