One thing you can do is to remove the tables from the dataenvironment. You can then put code in the report's dataenvironment init method to do a sql select from whichever table you want. That cursor will then be used in the report.

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