I was wondering if there is a way to select a particular row from dataset, i had a requirement where i need to show top 5 orders for the client, so i have this procedure with <code>select TOP 5 orders</code> which brigns the top 5 order and now what i need to do is to show the each order in diffrent page with a table , i mean the firstorder should be in page one's table and the second order should be in page 2 table and 3third order should be in page 3 table is there any way i can achieve it i tried goolge but no luck can any one please help me out thanks

If you are using SSRS 2008 version: 1. Add a Tablix control in your report 2. Set the dataset and add data fields in the columns. Also add group if you have to. 3. Set Page Break for group or Details section of the tablix. This should display one row per page. Pleaes let me know if it works.. Regards, Senthil

Hi, Just adding to what Senthil has said, Add a group over OrderID (or similar filed) and set the page break to "Between Each instance of group" from group properties->page breaks.- Chintak (My Blog)