/*Reportviewer.aspx.cs*/
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using CrystalDecisions.CrystalReports;
using CrystalDecisions.CrystalReports.Engine;
using CrystalDecisions.Shared;


public partial class ReportViewer : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        ReportDocument rptDrug = new ReportDocument();
        string path = Server.MapPath("~");
        path = path + "\\rptDrugNames.rpt";
        rptDrug.Load(path);

        TableLogOnInfo logoninfo = new TableLogOnInfo();
        

        /*Here we are assinging the servername,user name 
and password to the TableLogonInfo Object*/
        logoninfo.ConnectionInfo.ServerName = "localhost";
        logoninfo.ConnectionInfo.UserID = "sa";
        logoninfo.ConnectionInfo.Password = "sasa";

        /* Applaying the TableLogOnInfor object to report 
object.*/
        rptDrug.Database.Tables[0].ApplyLogOnInfo
(logoninfo);
        /*Setting the report source to Crystal Report 
viewer control*/
        CrystalReportViewer1.ReportSource = rptDrug;
        CrystalReportViewer1.DataBind();

    }
}
/*ReportViewer.aspx
 click form crystal reports
 crystal reportviewer*/