Posted on: 7/15/2012 12:46:35 PM | Views : 229

This is my code for crytal report. it is asking user name password.
this is mi web.config file
<add name="con" connectionString="Data Source=TRAINING-ROOM-8;Initial Catalog=newMreport;Integrated Security=True;User ID=sa; Password=123456789;Pooling=False " providerName="System.Data.SqlClient"/>
protected void Page_Load(object sender, EventArgs e) { SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ConnectionString); ConnectionInfo connectionInfo = new ConnectionInfo(); SqlCommand command = new SqlCommand("Select * From Transactions", con); SqlDataAdapter adapter = new SqlDataAdapter(command); DataSet dataset = new DataSet(); adapter.Fill(dataset, "Dataset1"); ReportDocument MedicalReport = new ReportDocument(); MedicalReport.Load(Server.MapPath("CrystalReport3.rpt")); MedicalReport.SetDataSource(dataset.Tables["Transations"]); CrystalReportViewer1.ReportS ...

Go to the complete details ...