Hi Vishal , Include your table and custtable in the datasource of the report one under the other and make a relation w.r.t accountnum. In custtable datasource sortorder select custtable.name and ur problem will be solved. Regards , Santosh Kumar Sharma [EMAIL PROTECTED]
V G <[EMAIL PROTECTED]> wrote: Hi I have a requirement where in I have to sort the report by the customer name. The table that is used in the query have customer No but not customer name. I am fetching the customer name from the custTable based on custAccount. I can create a temp table and insert the record with the customer name and than fetch it sort by customer name Is there a easier way or any other way to do this. Thanks Vishal [Non-text portions of this message have been removed] --------------------------------- Did you know? You can CHAT without downloading messenger. Know how! [Non-text portions of this message have been removed]