Reportoutput() - View in Excel 2002 Format returns no data

[bioCam]

Hi. I am using a Render Variable 'ReportFormat' for Reportoutput() with values 'HTML', 'PDF', 'XLS', '(Other)'.

My report has a Header + 2 conditional blocks -> HTML + PDF, XLS, (Other)

HTML - This block has Size & Overflow defined to freeze header from scrolling, display 10 Rows Per Page etc..

PDF, XLS, (Other) - This block DOES NOT have Size & Overflow defined and DOES NOT have Rows Per Page defined.

If Reportoutput is HTML - render HTML block otherwise the PDF, XLS, (Other) block.

Results are fine in HTML, PDF, View in Excel 2000 Single Sheet Format.

When I select 'View in Exel 2002 Format', only the Header is displayed, no data is displayed at all.

'View in Exel 2002 Format' has worked earlier before I put in the conditional block.  But I need the conditional blocks as there are data values that I don't display in HTML output but display all in other output formats.

Has anyone experienced this before and can help??  Thank you.