[RESOLVED] How to get rid of the login box

[usamaalam]

Hello everybody,

I am using CR 10 with ASP.NET 1.1/MSSQL. Whenever I run the report from application, it first shows a page where it asks SQL Server username/password and then it shows the report. My report is directly connected to a View in the SQL Server database.

How can I get rid of this login box when the report is presented from the application?

Thanks.

[Asgorath]

see my post http://www.vbforums.com/showthread.php?t=451212, you need to apply logon information to each table of the report.

[usamaalam]

Thanks a lot. I will try your code and will let you know.

[usamaalam]

I converted your code in C# and tried but getting logon failed exception. Here's the code.

		Database crDatabase;
		Tables crTables;
		//CrystalDecisions.CrystalReports.Engine.Table crTable = new CrystalDecisions.CrystalReports.Engine.Table();
		TableLogOnInfo crTableLogOnInfo = new TableLogOnInfo();
		ConnectionInfo crConnectionInfo;			

		ReportDocument crReportDocument = new ReportDocument();
		crConnectionInfo = new ConnectionInfo();		
		crConnectionInfo.ServerName = "LOCALHOST";
		crConnectionInfo.DatabaseName = "PCSNSurvey";
		crConnectionInfo.UserID = "sa";
		crConnectionInfo.Password = "sa";
						

		crReportDocument.FileName = Server.MapPath("Reports/CustomerList.rpt");
		crDatabase = crReportDocument.Database;
		crTables = crDatabase.Tables;
			
		foreach(CrystalDecisions.CrystalReports.Engine.Table crTable in crTables)
		{
			crTableLogOnInfo = crTable.LogOnInfo;
			crTableLogOnInfo.ConnectionInfo = crConnectionInfo;
			crTable.ApplyLogOnInfo(crTableLogOnInfo);
		}
				
		rptCustomerList.ReportSource = crReportDocument;

I am getting exception on the following line, however I am providing simple login credentials of my local pc.

crTable.ApplyLogOnInfo(crTableLogOnInfo);

Would you please help me out with this?

Thanks.

[usamaalam]

I am trying this code as well. It doesn't throw exception when report is loaded but shows report with old data. When I click Refresh, application blows up and says "Login failed.".

		CrystalDecisions.CrystalReports.Engine.ReportDocument reportDoc = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
		reportDoc.FileName = Server.MapPath("Reports/CustomerList.rpt");	
				
		string serverName = PCSN.SurveyApplication.BusinessLogicLayer.DatabaseInfo.GetServerName();
		string databaseName = PCSN.SurveyApplication.BusinessLogicLayer.DatabaseInfo.GetDatabaseName();
		string userName = PCSN.SurveyApplication.BusinessLogicLayer.DatabaseInfo.GetUserName();
		string password = PCSN.SurveyApplication.BusinessLogicLayer.DatabaseInfo.GetPassword();

		reportDoc.SetDatabaseLogon(userName,password,serverName,databaseName,true);
				
		rptCustomerList.ReportSource = reportDoc;

Thanks.

[shakti5385]

Basically login problem in the CR will occur when the report can not find the data table. I make a different code for this but it is VB.NET, Just read CR in VB.NET at my signature.

[usamaalam]

The problem was on my side. Basically I need to provide login information and survey name for DSN.

Thanks.

[shakti5385]

The problem was on my side. Basically I need to provide login information and survey name for DSN.

Thanks.

Ok that is other matter, no idea about that.

[usamaalam]

Yes, basically reports were designed by some other developer and I didn't notice it is going to connect via DSN. Now I can use it from application without a login box.

Thanks.