My requirement is bit weird. I am using SSRS 2008. I have created a report and the datasource is SQL sever 2008. When i export to TXT format i have to have a record limit of 80,000. If it crosses 80,000 records, i have to export it into another file. I have actually created a wep application which uses the report viewer control. I am writing code behind to populate the report viewer control, and to generate the file in the TXT format. I have no idea about how to set the row limit during export. Please shed some light.