Update Database Fields in report design

[Chong]

Please help. I need help on updating my report database fields so I can make changes to my report on detail section.
Below are my codes for populating my dataset and bring it to my report.

Dim strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=C:\VB Project\FormPractice\Login\Scholarship.mdb"

Dim intSSN As Integer = CInt(strSNNsubString)
Dim strPerSQL As String = "SELECT * FROM Personal, Education, Answers WHERE Personal.SSN =" & intSSN & " And Education.SSN =" & intSSN And Answers.SSN = " & intSSN"
Dim usrDataAdapter As New OleDbDataAdapter(strPerSQL, strConn)
usrDataAdapter.TableMappings.Add("Table", "Personal")
Dim usrDataset As New DataSet()
usrDataset.Clear()
usrDataAdapter.Fill(usrDataset, "Personal")

Dim rpt As New crprtAppInfo()
rpt.SetDataSource(usrDataset)
Dim fldName As String
fldName = "fldMdlName"
GetFieldObject(fldName)
crprtViewerApp.ReportSource = rpt

This is what I have before in my strPerSQL query:

Dim strPerSQL As String = "SELECT * FROM Personal, Education WHERE Personal.SSN =" & intSSN & " And Education.SSN =" & intSSN

And now I add one more table to the strPerSQL query:

Dim strPerSQL As String = "SELECT * FROM Personal, Education, Answers WHERE Personal.SSN =" & intSSN & " And Education.SSN =" & intSSN And Answers.SSN = " & intSSN"

My question is, how do I update the Database Fields in my report design so I can add additional fields from the Answers table to my report. I am using Crystal Report.

Many thanks in advance!

Chong

 

[hog]

see my post in the general section re this same problem for the answer