Login Issue

I am developing a windows application using VB.NET 2003 and the bundled version of crystal reports.

I have an issue with deployment to a number of users. I have a report viewer in my application that sends a dataset created from an xml document at runtime to a crystal report document. The reports display on all of our company PC's without any issues, but a couple of our users are getting 'Login failed' when trying to view the reports and are shown a dialog asking for the database location.

Using crystal to display data from ADO.NET at runtime seems to work with 95% of users, but we can't figure out why some users are encountering this issue.

Is this a known issue and if so is there a known solution to the problem Any advice would be appreciated.

Jason

Answer this question

Login Issue

Ed Kaim

Hi,

I got the answer for this Error after a long work out.

1. If U have Sub report in your report it should be binded with the Data

2. If the Sub Report is not binded with the Data then don't do Report.SetLogonInfo=False;

Just try this code in C# it is using a Sub report...

ReportDocument oReport = new ReportDocument();

ReportDocument SubRpt = new ReportDocument();

public DataAccessLayerBaseClass dataAccess;

DataSet ds = new DataSet();

CatalogTableAdapters.CatalogTableAdapter daCatalog = new CatalogTableAdapters.CatalogTableAdapter();

Catalog.CatalogDataTable Catalog = new Catalog.CatalogDataTable();

try

{

ds = GenerateCutQtyReport(Request.QueryString["WhereStr"]);

oReport.Load(Server.MapPath("MyReport.rpt"));

if (ds.Tables[0].Rows.Count > 0)

{

oReport.SetDataSource(ds);

SubRpt = oReport.OpenSubreport("MySubReport");

SubRpt.SetDataSource((System.Data.DataTable)Catalog);

}

else

{

throw new Exception("No Records to Display.");

}

oReport.SetParameterValue("PageHeading1", Request.QueryString["PH1"]);

oReport.SetParameterValue("PageHeading2", Request.QueryString["PH2"]);

CrystalReportViewer1.ReportSource = oReport;

CrystalReportViewer1.DisplayGroupTree = false;

CrystalReportViewer1.DataBind();

}

catch (System.Exception ex)

{

lblError.Text += ex.Message;

}

finally

{

oReport = null;

}

Thanks a Lot...

Happy Coding All

Regards

Iyyappan.A
Apoorva
Check to see if your users have the .NET 2.0 framework installed, if they do, get them to apply the latest hotfix for crdb_adoplus.dll.
Pat.
The user with the problem is using .NET 1.1 framework, and the crystal reports merge module included with Studio .NET 2003 was included in our application install.
Login Issue

Answer this question

Login Issue

Hot Topic

Visual Studio

Login Issue

Login Issue

Ed Kaim

Apoorva

Pat.