Hi, My requirement is to create a SSRS report with each page displaying 250 records.And if the report is exported to Excel, it should have all the records in Sheet1. I tried displaying 250 records per page using rownumber() function. But when the report exported to excel, it showed 250 records per sheet. How to meet my requirement? Is there any alternate way of doing it?? Please help….

Yes. In SSRS 2008 R2, a global field was added called the RenderFormat and you can use this in conditional expressions to control things like page breaks. It sounds like you already have the page break logic worked out and I assume you're using an outer group expression that is something like: =(RowNumber() MOD 250 = 0). To conditionally enable a page break, in the properties for the group where you are managing the page break, set the Group>PageBreak>Disabled property to an expression like =(Globals!RenderFormat.Name="Excel") Paul Turley, MVP, www.SQLServerBIBlog.com *Please vote if helpful*