Excel Export - Web Report without
Hi,
I have tried different things for Excel Export to avoid page breaks or do not repeat Column Headers. After using WebReport.XlsxSeamless = true, system not printing Page Header and page footers are not printing but other Headers or group headers are still printing. Is there anyway to avoid printing Column Headers or Group header on each page in Excel Export.
Thanks.
devoas
I have tried different things for Excel Export to avoid page breaks or do not repeat Column Headers. After using WebReport.XlsxSeamless = true, system not printing Page Header and page footers are not printing but other Headers or group headers are still printing. Is there anyway to avoid printing Column Headers or Group header on each page in Excel Export.
Thanks.
devoas
Comments
1. How I can bind the given code on Web Viewer Export/Save options/buttons. Are you suggesting to create another button and write this Code.
2. Taking your code will not print first occurrence of these group headers. Which is not required. Basically I want these headers not repeat on each page. Normally for Printing and viewing purpose we set Column headers / group headers to appear on each page, but on excel export this is creating problem.
3. Even after removing headers, Fast Report create some space between pages, rather than continuous rows of data.
So you valuable suggestion is required on this.
i tried to delete object inside header/footer but it still showed out blank row with a smaller height. you may delete header/footer band, but.... in my case, i can't delete because contains a script beneath header band.
This is working properly and export files without page breaks. Its a better choice for this purpose.
Is there any possibility or Event that we can call before Web viewers standard Export/File Save Button and set this value of Page height unlimited and after save finished restore the standard page value.