[Closed]Can I set pagesize and orientation in Rpt Ptr output EXL2k
Hi,
Even if I look through the online documentation, I can't figure out if I can page setup (pagesize and orientation) in Report Painter if output is EXL2K?
It is available for Postscript report but I don't realize what is a postscript.
Online doc: Format PostScript Creates an output file in PostScript format, which supports headings, footings, and totals. ?????
Does anybody can tell what I need and what I don't understand?
Thank you.This message has been edited. Last edited by: Marikaki,
Marikaki
WF 7.7.03m, MRE, BI Dashboard, DevStudio, Report Caster, Windows 7, I.E. 8/9, Apache Tomcat 6.0, Derby Output formats: Excel2K, PDF, HTML, AHTML
April 08, 2010, 04:01 PM
njsden
AS far as I understand, PAGESIZE and ORIENTATION are only relevant to "PAPER"-targeted formats such as Postscript and PDF.
EXL2K is targeted to a "worksheet" and therefore the above style keywords don't apply.
I assume that what you want to achieve is to produce an Excel spreadsheet in such a way that specific "page settings" are somehow embedded in it when WebFOCUS produces the file so when the user decides to print it, your desired size and orientation are already set as your reports needs?
I'm afraid I have no idea as to how to implement what you want except, maybe, by using Excel Templates.
Thank you for the information. I tried to use orientation in my report but I had no success. Perhaps I'm not using it correctly. Do you know how? Neftali told me it not faisable.
A quick view of the source:
...
BY PERIODWK AS 'Sem.'
BY NBRWDYWK AS 'J/S'
ON APCDESC SKIP-LINE
HEADING
"&CONFIDENT<+0>En date du &FFDATEDMYY"
"&RPT_TITLE1"
"&RPT_TITLE2 &FFMTHEND</1"
"<+0>&BLANK<+0>&FFDATEMYY<+0>&FFDATEMLY<+0>Années cumulées fin &FFDATEMBY"
FOOTING
"</1 &NOTE_1</1"
"&EOR"
ON TABLE SET SHOWBLANKS ON
ON TABLE SET NODATA ''
ON TABLE SET EMPTYCELLS OFF
ON TABLE PCHOLD FORMAT EXL2K
-*ON TABLE SET PSPAGESETUP ON
ON TABLE SET STYLE *
UNITS=IN,
FONT='TAHOMA',
SIZE=10,
TITLETEXT='&EXLABEL',
ORIENTATION=LANDSCAPE,
PAGESIZE='Legal',
$
TYPE=SKIPLINE,
BACKCOLOR=SILVER,
$
TYPE=REPORT,
SQUEEZE=ON,
GRID=OFF,
-*$
-*TYPE=REPORT,
-* ORIENTATION=LANDSCAPE,
$
...etc
Marikaki
WF 7.7.03m, MRE, BI Dashboard, DevStudio, Report Caster, Windows 7, I.E. 8/9, Apache Tomcat 6.0, Derby Output formats: Excel2K, PDF, HTML, AHTML
April 08, 2010, 04:29 PM
Marikaki
OK RivoU, I just realized that actually we are WF 767. That's why it is not workin.
Thanks.
Marikaki
WF 7.7.03m, MRE, BI Dashboard, DevStudio, Report Caster, Windows 7, I.E. 8/9, Apache Tomcat 6.0, Derby Output formats: Excel2K, PDF, HTML, AHTML
April 08, 2010, 04:34 PM
Marikaki
Thanks Neftali. I going to take a look at Excel template. Maybe it's the same.
Marikaki
WF 7.7.03m, MRE, BI Dashboard, DevStudio, Report Caster, Windows 7, I.E. 8/9, Apache Tomcat 6.0, Derby Output formats: Excel2K, PDF, HTML, AHTML
April 09, 2010, 10:00 AM
njsden
RivoU, that's great news. Being in a WF 5.3.4 definitely makes us miss on those nice improvements.
Marikaki, the use of Excel Templates involves a lot more work but for now it may be the way to implement what you want considering the limitation of your particular version of WF (which is much more recent that the one we currently use anyway).
I ran a quick test in my local Dev.Studio 7.6.11 and the ORIENTATION setting works very nicely as RivoU stated. PAGESIZE however still seems not to be supported so if you need to be able to control both settings you will most probably need to resort to using Excel Templates regardless of the particular WF 7.6.x release.
If that particular behaviour is needed in many of your reports you may consider opening a case with IBI for future enhancements to the tool.
- Neftali.This message has been edited. Last edited by: njsden,