>Hi Cetin
>
>Could you please explain why not to add tables in data environment,and what is the best practice to generate a report with more than one tables !!
>
>Thanks

Don't set the report to have a Private Datasession. If you don't specify that, it will use the data environment that you set up prior to calling the report. Ex.

use mytable1 order tag1
use mytable2 order tag1 in 0

report form MyReport

HTH.