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 ...