each page printed on on excel sheet when exporting custom report to excel

Dear All,

I have created a custom report in for getting details about inventory transfer orders. but when I run the report each transfer order is printed in one page also there is a free space to print more than one. also when I try export my report to excel I get each page printed in one excel sheet so if i have 10 pages in report viewer I got 10 excel sheets. I guess there is something wrong with design settings. your help is highly appreciated.