how to prevent a DataBase logon message to pop up

[chayado]

Hi All

I am using a crystal report .net 2.0,
For designing the report i connected the report to a local data set whenfor the actually data suorce of the report i used the function:

CrystalReport.SetDataSource(data table);

When i run the application the report shows beautifully ,but if i try to disply the report by a installed application a DataBase Logon message pops up and demand a login id and password,

how cen i solve this prablem???

Thanks.

Chaya

[yasirmturk]

Dear try to understand this and if you got any problem let me know

public partial class rptViewer : System.Web.UI.Page
{
    static ReportDocument rd = new ReportDocument();
    ConnectionInfo ci = new ConnectionInfo();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Request.QueryString["rpt"] != null)
        {
 
            ci.ServerName = ConfigurationManager.AppSettings.Get("DBServer");
            ci.DatabaseName = ConfigurationManager.AppSettings.Get("DBName");
            //ci.IntegratedSecurity = true;
            ci.UserID = ConfigurationManager.AppSettings.Get("DBLogin");
            ci.Password = ConfigurationManager.AppSettings.Get("DBPass");
            LoadRpt();
        }
    }
 
    protected void LoadRpt()
    {
        rd.Load(Server.MapPath("rpt/" + Request.QueryString["rpt"] + ".rpt"));
        if (ApplyLogon(rd, ci))
        {
            for (int i = 1; i < Request.QueryString.Count; i++)
            {
                rd.SetParameterValue(Request.QueryString.GetKey(i), Request.QueryString[i]);
            }
            Crv.ReportSource = rd;
            Crv.Width = new Unit("100%");
        }
        else
            lbltxt.Text = "Login info failed. Check DB settings";
    }
 
    protected bool ApplyLogon(ReportDocument cr, ConnectionInfo ci)
    {
        TableLogOnInfo li;
 
        // for each table apply connection info
        foreach (CrystalDecisions.CrystalReports.Engine.Table tbl in cr.Database.Tables)
        {
            li = tbl.LogOnInfo;
            li.ConnectionInfo = ci;
            tbl.ApplyLogOnInfo(li);
 
            // check if logon was successful
            // if TestConnectivity returns false, check
            // logon credentials
            if (tbl.TestConnectivity())
            {
                // drop fully qualified table location
                if (tbl.Location.IndexOf(".") > 0)
                {
                    tbl.Location = tbl.Location.Substring(tbl.Location.LastIndexOf(".") + 1);
                }
                else tbl.Location = tbl.Location;
            }
            else return (false);
        }
        return (true);
    }
 
    // The Logon method iterates through all tables
    protected bool Logon(ReportDocument cr, string server, string db, string id, string pass)
    {
        ConnectionInfo ci = new ConnectionInfo();
        SubreportObject subObj;
        ci.ServerName = server;
        ci.DatabaseName = db;
        ci.UserID = id;
        ci.Password = pass;
 
        if (!ApplyLogon(cr, ci)) return (false);
 
        foreach (ReportObject obj in cr.ReportDefinition.ReportObjects)
        {
            if (obj.Kind == ReportObjectKind.SubreportObject)
            {
                subObj = (SubreportObject)obj;
                if (!ApplyLogon(cr.OpenSubreport(subObj.SubreportName), ci)) return (false);
            }
        }
        return (true);
    }
}