Liew

How do you select the data for the report? If you select certain fields from a table, based on the user's selection, then you can provide the data for the report as an SQL cursor.

In the report, in each of the fields's options, ensure you don't include the table name. e.g. Mytable.StudentName would just be StudentName. Thus the report doesn't care from what tableit gets the field - the original or the cursor from it.

Now, if you've ommitted any fields in your SQL query, they simply won't appear on the report.

HTH

Terry

>In my report, I have few detail bands for some fields from different tables and some of them are optional. Before the report is generated, user can select the tables to be shown. As a result, those detail band(table) which is not selected will be hidden in the report, how could I do so?