I'm in WebFocus DevStudio 7.62 (Server is 7.64) and am trying to use an Excel Template so that the Excel report will have some pre-set print setups (landscape, fits on one page...).
I'm not having any luck... I thought that 7.6 was supposed to deliver this? Has anyone got any workarounds on this?This message has been edited. Last edited by: Kerry,
WF 7.62, SQL 2000, Windows XP
December 18, 2008, 02:00 AM
Tony A
If you're using Excel templates then the most controlled method would still be VBA. It's not hard and I always add a line to force the save format to xlNormal to recover the extraneous white space that results from with mso/xml - you can reduce the file size by as much as 66%.
If you're unsure as to the code required, then just turn on recording and style away. Capture the macro produced and adjust as necessary before putting it within your template.
T
In FOCUS since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
WebFOCUS App Studio 8.2.06 standalone on Windows 10
December 18, 2008, 02:36 AM
<JG>
Take a look at the following, the included VBA does exactly what you want.