Dynamically Assigning Tables

[Dman]

I have two tables. One that reflects data for the past 3 months and one that is an archive table to which data over 3 months old is sent. They are identical in their design with the exception that the table name is different. Is there a way to design a report such that a user could choose from the current or archived tables before the report is populated? My current report is written in Crystal Reports 9 and only reflects current data. Thanks in advance.

[brucevde]

If you are using the CRAXDRT Report object then you can change the data source at runtime. You can change the Server, Database and Tables if you want.

The following is an xample that changes the location to a different table. Note that I used the SQL Server native driver - may be different for other databases. Also, I am using version 8.5.

Dim objCrystal As CRAXDRT.Application
    Dim objReport As CRAXDRT.Report
    
    Set objCrystal = New CRAXDRT.Application
    Set objReport = objCrystal.OpenReport(ReportFileName)
    
    objReport.Database.Tables(1).SetLogOnInfo 'set login parameters    
    objReport.Database.Tables(1).Location = "Set to Desired Table"
 
    'Show report
    CRViewer1.ReportSource = objReport
    CRViewer1.ViewReport
 
    'Clean up
    Set objReport = Nothing
    Set objCrystal = Nothing