[RESOLVED] [VB.NET/Crystal Reports]Multiple Tables problem... help!!

[boreder]

Hello guys.

Im having a problem right now on displaying my Cystal Report with multiple tables.

My report contains two tables and but when I tried displaying my report in VB2005, I always get an exception error.

question: how do I set the ConnectionInfo and the LogOnInfo given the there are two tables in the report?

ive already tried a single table and it worked well.

please guys.. help me. =)

[SunshineBH]

What exception error are you getting?

What exactly do you mean by "two tables" as this should not be an issue at all.

[boreder]

i am a newbie to vb.net and crystal so i still dont know my way to this thing.

its an internal exception error.

two tables would mean, in my report i used two tables from the database to display the information i want. i am not talking about the design, but on how to set the connection to the database. obviously i dont know my way around using ConnectionInfo and LogonInfo when more than two tables are involved.

im sorry if my question wasnt so clear. =)

[SunshineBH]

Still not too sure what you mean sorry :-(
Can you post your code and the error?

Have you tried the Crystal Viewer (available off the Toolbox) If you use the Crystal Viewer then you dont need to worry about setting the connection info as this is handled by the viewer

[Hack]

its an internal exception error.

What is the specific error?

[boreder]

well the error turned out to be caused by the type of database i used and its incompatible with the setup. that part is done but I only used a single table. im gonna have to continue with the usage of two tables.

if you guys have any idea on how to set the connectioninfo and logoninfo, it would be very appreciated. the code below is the one i used for the single table:

Dim logOnInfo As New TableLogOnInfo
            Dim crDatabase As Database
            Dim crTables As Tables
            Dim crTable As Table
 
            logOnInfo = REPORT.Database.Tables.Item(TableName).LogOnInfo
 
            Dim connectionInfo As New ConnectionInfo
 
            crDatabase = REPORT.Database
            crTables = crDatabase.Tables
 
            connectionInfo = REPORT.Database.Tables.Item(TableName).LogOnInfo.ConnectionInfo
            connectionInfo.DatabaseName = Server
            connectionInfo.ServerName = Server
            connectionInfo.Password = Password
            connectionInfo.UserID = username
 
            For Each crTable In crTables
                logOnInfo = crTable.LogOnInfo
                logOnInfo.ConnectionInfo = connectionInfo
                crTable.ApplyLogOnInfo(logOnInfo)
 
                REPORT.Database.Tables.Item(crTable.Name).Location = username & "." & crTable.Location
 
            Next

thanks!

[VBFnewcomer]

pls post the exact error message. if possible take a snapshot of the error using Print Screen key in the keyboard and paste it in MSpaint. Post the image. I presume it is DAO Data linkng Error any way post it let's see

[boreder]

the error problem is fixed.

now, i would like ask for your idea on my second inquiry regarding the two tables included in a report. how to manipulate the ConnectionInfo and LogInfo classes. the code above is for sigle table only... but i want to learn if the report includes more than 1 table.

thanks!

[VBFnewcomer]

the error problem is fixed.

may we know how?

[boreder]

I just changed the connection type to ODBC(RDO). The problem was mainly on it, not on the multiple tables.

Using the Datasource Save Location Settings (I dont know the exact tool/window, cuz im using a japanese environment.) I updatedthe datasource to match that of the actual database table. The reason I had to do this because the Dataset(.xsd) was created manually cuz the database is so big, it slows down the pc when trying to use the wizard.

Im sorry if I cant explain it well, I hope my solutions makes sense.

[sarajoseph]

check this url , it abt showing data from multiple table in Crystal report

http://vb.net-informations.com/cryst...ple_tables.htm

jos.