Scheduled report is limiting at 10,000 rows

Content

 I have a monthly scheduled report that is limiting at 10,000 rows. It is a comma delimited and when I run it manually there are any where between 40,000 to 50,000 rows. When I try to use the CSV compressed it tells me that I cannot select that format for the report and that I need to add shorting add shorting and it still gives me the same message. Has anyone else ran into this problem and how do I get around this with out having to manually run this report each month. Thanks