Database Login for Crystal reports
in [VB.NET]
|
Prev: How to check if a file is open
Next: GetLongPathNameA
From: Ayaz Ahmed on 27 Sep 2005 10:13 Hello, Use This code Dim crReportDocument crReportDocument = New TestReport crConnectionInfo.ServerName = databaseServer crConnectionInfo.DatabaseName = databaseName crConnectionInfo.UserID = databaseUser crConnectionInfo.Password = UserPassword crTables = crReportDocument.Database.Tables Dim i As Integer i = 1 For Each crTable In crTables 'crTable = crTables(i) crTableLogOnInfo = crTable.LogOnInfo crTableLogOnInfo.ConnectionInfo = crConnectionInfo crTable.ApplyLogOnInfo(crTableLogOnInfo) crTable.Location = crTable.Location.Substring(crTable.Location.LastIndexOf(".") + 1) Next CRViewer.ReportSource = crReportDocument Thanks, Regards, Ayaz Ahmed Project Manager Creative Chaos (Pvt.) Ltd. "Managing Your Digital Risk" http://www.csquareonline.com Mobile +92 300 2280950 Office +92 21 455 2414 Email: ayaz(a)csquareonline.com ayazzahmed(a)gmail.com *** Sent via Developersdex http://www.developersdex.com ***
From: Murali via DotNetMonster.com on 28 Sep 2005 02:06 Hi ! I am using the same code, but it still displays the database login screen.. I hav changed the report connetion to DSN to OLEDB type. But i the problem still persists... As i mentioned already, i found the temporary solution with blank password login name... Anyways plz let me know any other methods to avoid database login prompt.. Thanks & Regards, Murali M Ayaz Ahmed wrote: >Hello, > >Use This code > >Dim crReportDocument >crReportDocument = New TestReport > >crConnectionInfo.ServerName = databaseServer >crConnectionInfo.DatabaseName = databaseName >crConnectionInfo.UserID = databaseUser crConnectionInfo.Password = >UserPassword > > crTables = crReportDocument.Database.Tables > Dim i As Integer > i = 1 > For Each crTable In crTables > 'crTable = crTables(i) > crTableLogOnInfo = crTable.LogOnInfo > crTableLogOnInfo.ConnectionInfo = crConnectionInfo > crTable.ApplyLogOnInfo(crTableLogOnInfo) > crTable.Location = >crTable.Location.Substring(crTable.Location.LastIndexOf(".") + 1) > Next > CRViewer.ReportSource = crReportDocument > >Thanks, > >Regards, > >Ayaz Ahmed >Project Manager >Creative Chaos (Pvt.) Ltd. >"Managing Your Digital Risk" >http://www.csquareonline.com >Mobile +92 300 2280950 >Office +92 21 455 2414 >Email: ayaz(a)csquareonline.com > ayazzahmed(a)gmail.com -- Murali VSM Software (P) Ltd. Bangalore,India Message posted via DotNetMonster.com http://www.dotnetmonster.com/Uwe/Forums.aspx/dotnet-vb-net/200509/1
From: Ayaz Ahmed on 28 Sep 2005 05:11 Hello, Please go crystal report viewer proporties and go to the behaviour category "EnableDatabaseLoginPrompt" set to false Thanks, Regards, Ayaz Ahmed Project Manager Creative Chaos (Pvt.) Ltd. "Managing Your Digital Risk" http://www.csquareonline.com Mobile +92 300 2280950 Office +92 21 455 2414 Email: ayaz(a)csquareonline.com ayazzahmed(a)gmail.com *** Sent via Developersdex http://www.developersdex.com ***
From: Murali via DotNetMonster.com on 28 Sep 2005 05:33 Hi Ayaz Ahmed! Sorry i could'nt find that property in my VS.net 2003 for CrystalReport Viewer. Regards, Murali Ayaz Ahmed wrote: >Hello, > >Please go crystal report viewer proporties and go to the behaviour >category "EnableDatabaseLoginPrompt" set to false > >Thanks, > >Regards, > >Ayaz Ahmed >Project Manager >Creative Chaos (Pvt.) Ltd. >"Managing Your Digital Risk" >http://www.csquareonline.com >Mobile +92 300 2280950 >Office +92 21 455 2414 >Email: ayaz(a)csquareonline.com > ayazzahmed(a)gmail.com -- Message posted via DotNetMonster.com http://www.dotnetmonster.com/Uwe/Forums.aspx/dotnet-vb-net/200509/1
From: YAR-X on 28 Sep 2005 11:50
hi i have the same problem and i tryed to find the property in vs2003 and it is not there help please:) |