InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 02:12:08 GMT20http://www.sqlservercentral.com/Forums/Topic1422464-1633-1.aspxThanks!! Will try and let you know!!Thu, 21 Feb 2013 11:58:08 GMTvar05http://www.sqlservercentral.com/Forums/Topic1422464-1633-1.aspxHi Var05,Try this out.suppose your report query is like this.Select Col1, Col2, . .--introducing one more column that define the number of rows in you selection and assign then a numeric value through 1 to 50 row_number() over(order by (select 1)) as 'r_num'From [SomeTableName]So, Above query have your result set required for report.Create New Report->create your dataset->on report body create a table area.1. In grouping pane Create Parent Group to your Default and write the grouping expression. =iif(fields!r_num.value<=10,1,2) dividing your data on to two different partition.2. Select Detailed Row from table area->go to row visibility->choose "Show and Hide based on expression" and write the below expression =iif(Fields!id.Value<=10,false,true) and "Display can be toggle by" Select your Parent Group Name.3. Select The Grouping Row from your Table in property window go for the property "InitialToggleState" and write expression. =iif(Fields!id.Value<=10,true,false)if you feel this is as your ans then mark it.if you require supportive report file to the above example do let me know.Thanks,Neeraj Thu, 21 Feb 2013 08:01:38 GMTneerajstarhttp://www.sqlservercentral.com/Forums/Topic1422464-1633-1.aspxHi All,I have a report that will have more than 50 rows in the result set. I would like to show top N rows alone in the report and hide the rest of the rows with toggle. Is there any way to achieve this? In a same time is there any way I can select rows from 11 and 50 in another grouping....first group would show top 10 rows....and anthr grp from top 11..Any ways pls?ThanksThu, 21 Feb 2013 03:00:10 GMTvar05