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     Table column numbers in output (during development)

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Table column numbers in output (during development)
 Login/Join
 
Virtuoso
posted
Hi again,

I've been busily styling all our reports and I found that quite a bit of my time gets consumed by determining what column number in the table output I'm looking at, so that I can apply styling to particular columns. It would be really great if there were some way to print the column numbers above or under the titles!

It gets especially confusing if you're trying to apply conditional formatting to a across-columns, as you can reference the across-column with ACROSSCOLUMN=N3, but you need to reference the actual column in the WHEN=N10 LT 0 clause!

An example would probably clarify what I mean here;

Say you have:
TABLE FILE MY_TABLE_FILE
SUM
     BUDGET/D10S
     COST/D10S NOPRINT
     DEMAND/D10S
     STOCK/D10S
BY GROUP
BY ARTICLE
BY DIVISION
SUM
     BUDGET/D10S
     COST/D10S NOPRINT
     DEMAND/D10S
     STOCK/D10S
BY GROUP
BY ARTICLE
BY DIVISION
ACROSS YEAR
ACROSS MONTH
END


That gives output like:
                                           YEAR
                                           2010
                                           MONTH
                                           1                   2                   3
GROUP ARTICLE DIVISION BUDGET DEMAND STOCK BUDGET DEMAND STOCK BUDGET DEMAND STOCK BUDGET DEMAND STOCK


Now if I could get the below under or above that row of titles, that would be really helpful:
N1    N2      N3       N4     N6     N7    N8     N10    N11   N8     N10    N11   N8     N10    N11    (columns)
                                           N1     N3     N4    N1     N3     N4    N1     N3     N4     (across)


The fact that I'm not even sure about the above numbering being correct only underlines why it'd be helpful Wink
It appears that in newer versions of WebFOCUS we'd be able to reference across-columns in the WHEN clause using A1, A3, etc, but even with that, the above seems really useful to me.

[Edit: Someone marked this as SOLVED - I wonder why?]

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


WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010
: Member of User Group Benelux :
 
Posts: 1669 | Location: Enschede, Netherlands | Registered: August 12, 2010Report This Post
Guru
posted Hide Post
Thats why I always replace column number in stylesheet with column name. It also doesnt go wrong when you add a column.


(Prod: WebFOCUS 7.7.03: Win 2008 & AIX hub/Servlet Mode; sub: AS/400 JDE; mostly Self Serve; DBs: Oracle, JDE, SQLServer; various output formats)
 
Posts: 391 | Location: California | Registered: April 14, 2003Report This Post
Virtuoso
posted Hide Post
That's nice and all, but the Report Editor generates numbers and you can't use column names for across columns. I've tried and seen that it results in odd behaviour and I recall coming across this in the documentation too.

So there is reason to use column numbers and therefore there is reason to want some method for figuring out what column number corresponds to what table column in the results.

Come to think of it, the same could be said for a mapping of column numbers to field names, as those can be quite different from how they are printed in the output; they can be in a different order or aliased, after all. That's especially useful on DB2/400 where column names are limited to 8 characters and field descriptions (thanks for those) are printed instead - it's not always easy to figure out what database column corresponds to the column title.


WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010
: Member of User Group Benelux :
 
Posts: 1669 | Location: Enschede, Netherlands | Registered: August 12, 2010Report 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     Table column numbers in output (during development)

Copyright © 1996-2020 Information Builders