Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [Closed]Can I set pagesize and orientation in Rpt Ptr output EXL2k
Go
New
Search
Notify
Tools
Reply
  
[Closed]Can I set pagesize and orientation in Rpt Ptr output EXL2k
 Login/Join
 
Gold member
posted
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

 
Posts: 96 | Location: Montreal, Quebec, Canada | Registered: January 20, 2010Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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.
 
Posts: 1533 | Registered: August 12, 2005Reply With QuoteReport This Post
Member
posted Hide Post
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
 
Posts: 23 | Location: Tallinn, Estonia | Registered: July 31, 2009Reply With QuoteReport This Post
Gold member
posted Hide Post
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

 
Posts: 96 | Location: Montreal, Quebec, Canada | Registered: January 20, 2010Reply With QuoteReport This Post
Gold member
posted Hide Post
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

 
Posts: 96 | Location: Montreal, Quebec, Canada | Registered: January 20, 2010Reply With QuoteReport This Post
Gold member
posted Hide Post
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

 
Posts: 96 | Location: Montreal, Quebec, Canada | Registered: January 20, 2010Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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.
 
Posts: 1533 | Registered: August 12, 2005Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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.
 
Posts: 1533 | Registered: August 12, 2005Reply With QuoteReport This Post
Gold member
posted Hide Post
Thank you Neftali for your comments.

Here is how we distinguish the professionals.

Have a nice weekend, both of you.
 
Posts: 96 | Location: Montreal, Quebec, Canada | Registered: January 20, 2010Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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.
 
Posts: 1533 | Registered: August 12, 2005Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [Closed]Can I set pagesize and orientation in Rpt Ptr output EXL2k

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.