Visual Basic Crystal Reports - Change Report source through VB6

Author

Change Report source through VB6

Ludwig Jr Hemelaer

2005-05-30, 4:01 pm

Applications: Visual Basic 6 with service pack 5 + Crystal Reports 9

I've made a report in Crystal Reports 9 with a database connection to a
Foxpro table (table1.dbf). Opening this report in Visual Basic 6 is no
problem at all, but I want to make it possible for the user to change the
database source of the report by selecting another foxpro database
(table2.dbf).

The database selection is up & running, data component 'DataVerkoop' is the
one with the right database.

How can I modify the report so it takes the 'new' database as source? (the
structure of the new Foxpro database is the same as the one I used to make
the report)

Many thanks!

mthompso

2005-06-08, 4:02 pm

Ludwig Jr Hemelaer wrote:
> Applications: Visual Basic 6 with service pack 5 + Crystal Reports 9
>
> I've made a report in Crystal Reports 9 with a database connection to a
> Foxpro table (table1.dbf). Opening this report in Visual Basic 6 is no
> problem at all, but I want to make it possible for the user to change the
> database source of the report by selecting another foxpro database
> (table2.dbf).
>
> The database selection is up & running, data component 'DataVerkoop' is the
> one with the right database.
>
> How can I modify the report so it takes the 'new' database as source? (the
> structure of the new Foxpro database is the same as the one I used to make
> the report)
>
> Many thanks!
>
>
This is taken from a VB project, but the principle is the same. In the
code portion of the form that loads the report viewer, insert the following:

For i = 1 To Report.Database.Tables.Count
Report.Database.Tables(i).Location = strPathToDB
Next i

where strPathToDB is where the database is located.

Alternately, could you source your database location from the data
component? Or the name of its recordset?

HTH - Miles Thompson

Sponsored Links