Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


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

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[Closed]Can I set pagesize and orientation in Rpt Ptr output EXL2k
 Login/Join
 
Marikaki
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, 2010Report This Post
njsden
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, 2005Report This Post
RivoU
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, 2009Report This Post
Marikaki
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, 2010Report This Post
Marikaki
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, 2010Report This Post
Marikaki
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, 2010Report This Post
njsden
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, 2005Report This Post
njsden
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, 2005Report This Post
Marikaki
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, 2010Report This Post
njsden
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, 2005Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

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-2020 Information Builders