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] How to Name Worksheets in excel TOC reports?

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] How to Name Worksheets in excel TOC reports?
 Login/Join
 
Shankar
Guru
posted
Hi all,
Is it possible to name worksheets depending on particular value of BY field which has been used to create Excel Tables of Contents Reports?

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


WF 8.1.04,Windows 7,
DataBase: Oracle 11g,Output :Excel,PDF,HTML
 
Posts: 281 | Location: India | Registered: April 21, 2007Report This Post
<JG>
posted
BYTOC
 
Report This Post
Shankar
Guru
posted Hide Post
JG,
That is ok.By doing BYTOC,it will generate the report with different worksheet with the name in data file.I want to give my own name to the worksheet for some values.Is it possible?

Thanks,


WF 8.1.04,Windows 7,
DataBase: Oracle 11g,Output :Excel,PDF,HTML
 
Posts: 281 | Location: India | Registered: April 21, 2007Report This Post
<JG>
posted
Not unless you use a macro.

I posted a solution for this a few weeks a go. Do a search and you will find it.
 
Report This Post
Glenda
Guru
posted Hide Post
When I want to set my own tab titles, I loop through rather than using BYTOC.

Something like this maybe:

-SET &PASS     = 0;
-REDO
-SET &PASS     = &PASS + 1;
-IF  &PASS     = 6 GOTO NOMORE;
-SET &TabTitle = DECODE &PASS(1 ENG
-                             2 JAP
-                             3 ITY
-                             4 WGM
-                             5 FRA);
-SET &WHRC     = DECODE &PASS(1 'WHERE COUNTRY EQ ''ENGLAND'''
-                             2 'WHERE COUNTRY EQ ''JAPAN'''
-                             3 'WHERE COUNTRY EQ ''ITALY'''
-                             4 'WHERE COUNTRY EQ ''W GERMAN'''
-                             5 'WHERE COUNTRY EQ ''FRANCE''');
-SET &HOLDER   = DECODE &PASS(1 'ON TABLE PCHOLD FORMAT EXL2K OPEN'
-                             5 'ON TABLE PCHOLD FORMAT EXL2K CLOSE'
-                          ELSE 'ON TABLE PCHOLD FORMAT EXL2K');
TABLE FILE CAR
PRINT 
       COUNTRY
       CAR
       MODEL
       BODYTYPE
BY CAR NOPRINT 
&WHRC.EVAL
&HOLDER.EVAL
ON TABLE SET STYLE *
TYPE=REPORT,
     TITLETEXT='&TabTitle',
$
ENDSTYLE
END
-GOTO REDO
-NOMORE
-EXIT


Glenda

In FOCUS Since 1990
Production 8.2 Windows
 
Posts: 301 | Location: Galveston, Texas | Registered: July 07, 2004Report This Post
Shankar
Guru
posted Hide Post
Hi Glenda,
I do not have any fix number of values for the field for which different worksheet will be generated.So,it is not possible to use loop here.What I want is,suppose I have blank value for my BY field,In this case the records will be populated with blank tab.I just want to name the tab.Is it possible???

Thanks.


WF 8.1.04,Windows 7,
DataBase: Oracle 11g,Output :Excel,PDF,HTML
 
Posts: 281 | Location: India | Registered: April 21, 2007Report This Post
RSquared
Guru
posted Hide Post
Shankar,

create a define for the sort field.
eg.
/*
DEFINE FILE WHATEVER
BYTOC1/A5=IF SORTBY NE '' THEN SORTBY ELSE 'BLANK';
END

TABLE FILE WHATEVER
PRINT FIELD1
...
BY BYTOC1
...


WF 7.6.11
Oracle
WebSphere
Windows NT-5.2 x86 32bit
 
Posts: 398 | Registered: February 04, 2008Report This Post
Prarie
Virtuoso
posted Hide Post
What are you going to name the Tab..if there is not a fixed value? do you want all the tabs to have the same name?
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 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] How to Name Worksheets in excel TOC reports?

Copyright © 1996-2020 Information Builders