In order to print a report in Google Sheets you will have to change the printer settings.

Step 1:  Select the range of the sheet that you are wanting to print.

Step 2:  Select Print

Once you have the Print Range selected, click the print button (File -> Print)

Step 3:  Change the Printer Settings

• Change the Print Range to 'Selected Cells'
• Change the Page Orientation to Portrait
• Under Rows & column headers de-select the checkbox next to 'Repeat frozen rows'