Focal Point
[Closed]Can I set pagesize and orientation in Rpt Ptr output EXL2k

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/372108414

April 08, 2010, 03:52 PM
Marikaki
[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.

- Neftali.



Prod/Dev: WF Server 8008/Win 2008 - WF Client 8008/Win 2008 - Dev. Studio: 8008/Windows 7 - DBMS: Oracle 11g Rel 2
Test: Dev. Studio 8008 /Windows 7 (Local) Output:HTML, EXL2K.
April 08, 2010, 04:07 PM
RivoU
WF supports setting ORIENTATION=LANDSCAPE in stylesheet for EXL2K output format from release 7.6.9

Excel (EXL2K Format) Style Enhancements

Br,
Rivo


iSM 6.0
iDM 7.6.5 - 7702
WF 7.6.4 - 7702

All output formats
April 08, 2010, 04:25 PM
Marikaki
Hi RivoU,

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).



Prod/Dev: WF Server 8008/Win 2008 - WF Client 8008/Win 2008 - Dev. Studio: 8008/Windows 7 - DBMS: Oracle 11g Rel 2
Test: Dev. Studio 8008 /Windows 7 (Local) Output:HTML, EXL2K.
April 09, 2010, 10:07 AM
njsden
Marikaki,

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,



Prod/Dev: WF Server 8008/Win 2008 - WF Client 8008/Win 2008 - Dev. Studio: 8008/Windows 7 - DBMS: Oracle 11g Rel 2
Test: Dev. Studio 8008 /Windows 7 (Local) Output:HTML, EXL2K.
April 09, 2010, 11:34 AM
Marikaki
Thank you Neftali for your comments.

Here is how we distinguish the professionals.

Have a nice weekend, both of you.
April 09, 2010, 11:52 AM
njsden
Thank you for saying that, Marikaki. It means a lot to hear that from you.

Bon week-end à toi aussi!

- Neftali.

This message has been edited. Last edited by: njsden,



Prod/Dev: WF Server 8008/Win 2008 - WF Client 8008/Win 2008 - Dev. Studio: 8008/Windows 7 - DBMS: Oracle 11g Rel 2
Test: Dev. Studio 8008 /Windows 7 (Local) Output:HTML, EXL2K.