Crystal XI + VB6

[Besoup]

Hey,
I am designing a report that is going to run of a temporary table being created on a SQL Server via VB6. My question is how do I change the source table name in my code so it will look at the current temporary table. My temporary table names will vary but the fields inside them will be identically named. Will changing the source table name of the report effect the report itself if all the field names are the same still?

any input is greatly appreciated.

[Besoup]

I have the code to open the report here:

Private Sub RunReport(stTableName As String)
Dim crxApp As New CRAXDDRT.Application
Dim crxReport As CRAXDDRT.Report
Dim crxDatabaseTables As CRAXDDRT.DatabaseTables
Dim crxDatabaseTable As CRAXDDRT.DatabaseTable
Dim crxDatabase As CRAXDDRT.Database
Dim crxParm As CRAXDDRT.ParameterValues
Dim crxSubReport As CRAXDDRT.Report

Dim ReportName As String
ReportName = "\\Server\Reports\PL.rpt"

Set crxReport = crxApp.OpenReport(ReportName)

With crView
.ReportSource = crxReport
.ViewReport
While .IsBusy
DoEvents
Wend
.Zoom "100"
.Visible = True
End With

End Sub

I just want to programmatically change the name of the table that the report is looking at if that is possible...