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