Link to home
Start Free TrialLog in
Avatar of cmmcginn
cmmcginnFlag for United States of America

asked on

Use same FoxPro report form with different data tables

I used a wizard to create a report in VFP9 using a data table and a support table.  Now, I want to use it with a different data table and same support table, but I'm having trouble.  

I just want to use a different data table, but I can't get the report to work properly.  It keeps looking to the support table (the one with descriptions) for the data grouping fields I selected, that actually come from the data tables.  For each data grouping field, I attempt to revise the report to point to the data table, but when I go back and look at them, they continue to point to the support table.

I'm a bit rusty with Fox reports.  Not sure why this is so difficult.

Thank you.
SOLUTION
Avatar of jrbbldr
jrbbldr

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of Olaf Doschke
Olaf Doschke
Flag of Germany image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of cmmcginn

ASKER

Thanks everyone. I've been away on a family matter, so my reply is late.

I'm just working with a few free tables; no database.

I've attempted to bring the free table I need into the DE, but it isn't working properly.  When I attempt to reference fields in the expression builder, I choose the table I want from the bottom drop down list, but it doesn't actually switch to that table. I choose the fields I want, and it looks like it works, bu it really doesn't.  When I look back at a field I've chosen, it refers to a different table from when I created the report with the wizard.
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thank you everyone.  I guess the wizards are convenient, but apparently introduce background settings that make them inflexible.

I appreciate everyone's help.
OK, just to add a bit:  VFP does not only look for DBC files along SET('PATH') paths, so the setting of several search paths also applies to free tables. But if you want to use different tables the approach to query all data needed for the report into a cursor is more flexible.

You can still create the report control expressions via the expression builder, which will let you pick from all currently open tables or cursors, not only from tables of the report DE.

Bye, Olaf.