hi, can someone guide me? query i am using is: select m.*,b.ord_item,b.item_no,b.serial_no from main_table m join sec_table b on m.header=b.header the output shld be all the columns in the main table eg: a-z are the columns in the main table the outpust shld be a..................................................................z under each header id their respective order ids, serial nos,item nos.. so the total output shld a......................................................................z a1 a2.................................................................->1st row. ordered item, item no, serial no a12,a21.............................................................->2nd row ordered item, item no, serial no of 2nd row.. let me know if you need something else.. thanks

Use matrix for it Keep One Column grouping by header and under this keep you order number grouping Hope this will give you an idea.Gaurav Gupta http://sqlservermsbiblog.blogspot.com/

Hi, This can be achieved by adding a row group in the table. Please refer to the steps below: 1. Add a table to the report. 2. Drag and drop the data fields ord_item, item_no and serial_no to cells in the detail row in the table. 3. Add a row group with group header to the table. It groups by the field header. 4. Drag and drop the data fields a…z which from the main table to cells in new group header. For more information about How to Add a Group, please refer to the link below: http://msdn.microsoft.com/en-us/library/ms156487(v=SQL.100).aspx If anything is unclear, please feel free to ask. Thanks, Tony ChainPlease remember to mark the replies as answers if they help and unmark them if they provide no help