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     Display of across values syn with Column heading

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Display of across values syn with Column heading
 Login/Join
 
thangam
Gold member
posted
Can I display across value in syn with column heading?
i.e.,
If I use across in my report, the output will look like
val1 val2
Col1 Col2
data1 data2 data3 data4
.
..

I want to display like

Col1 Col2 val1 val2
data1 data2 data3 data4
 
Posts: 77 | Registered: December 22, 2004Report This Post
thangam
Gold member
posted Hide Post
Is there anyone to help me out?
 
Posts: 77 | Registered: December 22, 2004Report This Post
Leah
Virtuoso
posted Hide Post
Are you wanting to reverse how displayed but keep the sort? Don't know if you can get there? UP early I see.
 
Posts: 1317 | Location: Council Bluffs, IA | Registered: May 24, 2004Report This Post
<WFUser>
posted
If I understand you correctly, you have 2 ACROSS fields and you want them display after the other (across 1.......across2.....) rather than under each other. Correct?
 
Report This Post
thangam
Gold member
posted Hide Post
I need to show Item count based on Division, class, subclass and item status.
Item status is my horizontan sort field.
I need to display the column headings as single row. At present, By columns are aligned next row to Across Column. How do I overcome this?

Expected output should be

Column1 Column2 AcrossVal1 Across Val2
data data data data

i.e,

Division Class Subclass ItemStatus
HR Class1 Subclass1 Number of items
 
Posts: 77 | Registered: December 22, 2004Report This Post
Leah
Virtuoso
posted Hide Post
Ah specialized headings.

Have you tried using AS '' no spaces between the quote marks and then creating a heading of your own in the heading that lines up with the data columns?

TABLE FILE XYZ

SUM CNT.FIELD OR WHATEVER AS ''
BY ABC AS ''
BY XYY AS ''
ACROSS TTT AS ''

HEADING
"<15> FIELD HEAD <10> ABC
...
AND SO ON

THE DATA IN THE ACROSS STILL DISPLAYS . DON'T HAVE ACCESS TO OUR SERVER AT THE MOMENT TO PLAY REAL CODE.
 
Posts: 1317 | Location: Council Bluffs, IA | Registered: May 24, 2004Report This Post
<WFUser>
posted
I saw your other post on what I thought was the same issue, and it looked like you got your answer. If not, here's how I did it. You basically need to combine all of your ACROSS fields into one. Sample using the CAR file with the COUNTRY and CAR fields. First I created the ACRTEST.MAS file as follows:

FILE=ACRTEST,SUFFIX=FIX,$
SEGNAME=SEG1,$
FIELD=ACRORD,,I2,A2,$
FIELD=ACRFLD,,A16,A16,$
FIELD=SALES,,D6,A6,$

ACRFLD is the length og my largest field. Here is the fex.

FILEDEF ACRDATA DISK c:\ibi\apps\ibisamp\acrdata.txt
DEFINE FILE CAR
CNTRY/A16 = COUNTRY;
ACRORD/I2 = 1;
END
TABLE FILE CAR
SUM SALES
BY ACRORD
BY CNTRY
ON TABLE SAVE AS ACRDATA
END

FILEDEF ACRDATA DISK c:\ibi\apps\ibisamp\acrdata.txt (APPEND
DEFINE FILE CAR
ACRORD/I2 = 2;
END
TABLE FILE CAR
SUM SALES
BY ACRORD
BY CAR
ON TABLE SAVE AS ACRDATA
END

FILEDEF ACRTEST DISK c:\ibi\apps\ibisamp\acrdata.txt

TABLE FILE ACRTEST
SUM SALES
ACROSS ACRORD NOPRINT
ACROSS ACRFLD
END
 
Report 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     Display of across values syn with Column heading

Copyright © 1996-2020 Information Builders