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     report rotation on 90 degree

Read-Only Read-Only Topic
Go
Search
Notify
Tools
report rotation on 90 degree
 Login/Join
 
Petren
Member
posted
Have:
Name Age
Bill 39
Nick 46
Fox 21

Need:
Name Bill Nick Fox
Age 39 46 21

Help please! Can i obtain the result by pushing the button?


WebFOCUS 7.6 on Win 2K/IIS 6/Weblogic 8.1/Servlet Mode
 
Posts: 11 | Registered: August 05, 2008Report This Post
Danny-SRL
Virtuoso
posted Hide Post
Petren,

Welcome to the Forum. Please Update your Signature with what version your are on so we will better know how to help you.

** Update signature
1) Logon to Focal Point and go into your complete profile.
2) Scroll down the page until you see the “Signature” field.
3) Fill in the signature you want to use. Here is a sample to model:

Prod: WebFOCUS 5.2.3 on Win 2K/IIS 6/ISAPI Mode
Test: WebFOCUS 7.1 on Win 2K/IIS 6/Weblogic 8.1/Servlet Mode

4) Once all changes are made/added, scroll down to the bottom of the page and click on the Submit button.


As for your question:
It is important, for you and for those on the Forum, that you read the manual. If you do not have one, you can download it from the IBI web site. I suggest that you look up ACROSS.


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

 
Posts: 1980 | Location: Tel Aviv, Israel | Registered: March 23, 2006Report This Post
Petren
Member
posted Hide Post
WebFOCUS 7.6 on Win 2K/IIS


WebFOCUS 7.6 on Win 2K/IIS 6/Weblogic 8.1/Servlet Mode
 
Posts: 11 | Registered: August 05, 2008Report This Post
Prarie
Virtuoso
posted Hide Post
Do some research on ACROSS See it that gets you closer.


In Focus since 1993. WebFOCUS 7.7.03 Win 2003
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Report This Post
Mikel
Platinum Member
posted Hide Post
Have:
TABLE FILE EMPLOYEE
  PRINT LAST_NAME HIRE_DATE
END
-RUN

Need:
TABLE FILE EMPLOYEE
  SUM FST.HIRE_DATE
  ACROSS LAST_NAME AS ' '
END
-RUN

Regards,
Mikel


WebFOCUS 8.1.05, 8.2.01
 
Posts: 173 | Location: Madrid, Spain | Registered: May 09, 2003Report This Post
susannah
Expert
posted Hide Post
quote:
Can i obtain the result by pushing the button?

i don't know of a button you can push...
-* creates a simple extract file
TABLE FILE CAR
SUM SALES DEALER_COST BY MODEL
ON TABLE HOLD
END
-* creates an ordering field called 'LIST' with values 1,2,3,etc
TABLE FILE HOLD
LIST SALES MODEL DEALER_COST
ON TABLE HOLD
END
-* displays the 3 variables you asked for, cost, sales and model, across the order of that LIST variable,
-* w/o displaying actually displaying ing.
TABLE FILE HOLD
SUM MODEL OVER SALES OVER DEALER_COST
ACROSS LIST NOPRINT
END
-*
You can copy this code and run it on your site, then adapt the concept to your data. We use the CAR file (or one of the other sample files) here on the Point to pose questions and illustrate techniques, when we can.



In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report This Post
susannah
Expert
posted Hide Post
Mikel, you're back!!! cool.



In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report This Post
Waz
Expert
posted Hide Post
If you just want to change a BY to an ACROSS with a push of a button, then why not use OLAP.

Otherwise a drilldown will do the job.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report 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     report rotation on 90 degree

Copyright © 1996-2020 Information Builders