John,
The way I'd do this is to use one of the cursors, create a report and use quick report, do
NOT add the table to the DE and do
NOT add the alias in the dialog. This way the report will work for whatever the current alias is. Some conditional field code can handle the extra field.
>I have 3 table, all have identical fields, except for one, which has one extra field. I'd like to use one report definition, but change the cursor(alias) that it uses for the data source. I've never done this before, and the help files give me no direction in how to do this. Here's what I've done so far:
>
>I've got my report set up, I'm using ONLY the table field names(not the table name(table.field)) in the report fields.
>I've got a dataenvironment set up with all three tables in it.
>when I run the report this is the command I use:
>
>REPORT FORM \REPORTS\MAILLISTPG.FRX NOCONSOLE RECORD (currecno) TO PRINTER
>
>The above works, but will only print data from the first table in the dataenviron....I feel like I'm 2 inches from the lightswitch, but it's too dark to see!! ARGH!!!
>
>ANY help is appreciated.