Peter's Gekko

When I click on the three links in Crystal reports roundup post, I get Page Not Found :(

Links have been fixed. Thanks for reporting.

Hi I am using VS 2005 & SQL Server 2005 for developing my windows Application.

Its the combination of C# & VB.net... Everything works fine except crystal reports.

Actually I start developing this app on my laptop, Where the crystal Reports were working fine... When I install the app along with Crystal reports Redistribution X86.. The form which contains cyrstal report open but not able to Load the report... It Always promot for Server, Database, UID & Password on each client machine.

Intersetigly The servername Field is readonly and its still My Laptop Name Where I Orignally Develop this App.

I follow all Tutorials form all over the web Including Business Objects But NO LUCK

I have the report designed using usuall wizard & ADO.net connection for SQL server

Here is the code I am using

----------------------------------------------------------

Dim myTable As CrystalDecisions.CrystalReports.Engine.Table

       Dim myLogin As CrystalDecisions.Shared.TableLogOnInfo

       Dim crTableLogonInfos As TableLogOnInfos = New TableLogOnInfos()

       Dim crpt As crManifest

       crpt = New crManifest()

       For Each myTable In crpt.Database.Tables

           myLogin = myTable.LogOnInfo

           myLogin.ConnectionInfo.Password = My.Settings.Sql_Password

           myLogin.ConnectionInfo.UserID = My.Settings.Sql_User_Name

           myLogin.ConnectionInfo.DatabaseName = My.Settings.Sql_Database

           myLogin.ConnectionInfo.ServerName = My.Settings.Sql_Server_Name

           myTable.ApplyLogOnInfo(myLogin)

           crTableLogonInfos.Add(myLogin)

           myTable.Location = My.Settings.Sql_Database & ".dbo." & myTable.Location.Substring(myTable.Location.LastIndexOf(".") + 1)

       Next

       CRVMain.LogOnInfo.Clear()

       CRVMain.LogOnInfo = crTableLogonInfos

       CRVMain.ReportSource = crpt

-------------------------------------------------------------

I Tried to take out the lines such as

myTable.ApplyLogOnInfo(myLogin)

           crTableLogonInfos.Add(myLogin)

           myTable.Location = My.Settings.Sql_Database & ".dbo." & myTable.Location.Substring(myTable.Location.LastIndexOf(".") + 1)

BUT THERE ARE STILL ERRORS

I simply want that  report shoud run smooth without any login prompt & Fast data Load.... STILL IN MY DREAMS...

Can Anyone provide HELP???????????????