>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.

John,

Take the Cursors out of the DE on the Report. Select the Right cursor and call the report normally. It will use the Current Work Area. As far as the extra field, either create a local variable of that extra field name when you're using the two cursors that don't have the field, or put some code in the Init() of the DE of the report that checks for existense of the field and create a variable if necessary.

HTH