SQL Report Preview in Report Editor

I created a custom SQL report in report Editor. When i click on the report query preview, i see the output. I saved the report and when i click on HMTL preview it shows only 1 record as opposed to 10 records. Any thoughts what could be missing?

TIA