If you don't specify alias names in the report designer, the report will use whatever table is selected. In the form that the user runs the report from, run a SQL Select against the source table, building the Order clause on the fly to place the data in the necessary.
PF
>How do I pass parameters to the report like do form xxxx with para1,para2.
>
>the order is set by user say customer name or customer city.
>Do I have to create different views/reports, for different order.
>We are using views in the report.
>
>Thank you,
>sanjay chavda
>
sanjayc@mailandnews.com
(On an infant's shirt): Already smarter than Bush