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.