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.



Read-Only Read-Only Topic
Go
Search
Notify
Tools
sortable columns
 Login/Join
 
dev532
Gold member
posted
Hi,

Is there a feature in Webfocus 7.1 to make columns sortable so that when a column title is clicked, the column should be sorted in ascending and descending order alternatively.

I am looking at Javascript sorttable option but to use this feature, a HTML table has to be generated and tagged with a 'class' attribute. Since I will be using -HTMLFORM on a !IBI.FIL.HOLD , I am not sure where to use the 'class' attribute.


Thanks.


WF 7.1.1, WF Developer studio 7.1.1, Windows & Mainframe, HTML
 
Posts: 84 | Registered: July 28, 2009Report This Post
GinnyJakes
Expert
posted Hide Post
There are a lot of focexecs in the New Century Demo that do that. Program ibinccen/saleprft.fex is one of them. If the demo is installed at your site (or you can find it on your desktop if you have Developer Studio installed), the link is http://your_webserver/approot/ibinccen/default.htm


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
Darin Lee
Virtuoso
posted Hide Post
The easiest way is using an Active HTML output and it's delivered as part of the output. Another way we have used is to add a drilldown to the column title or up/down arrow graphic which re-runs the report passing a BY HIGHEST parameter.

You've got lots of options - just a matter of balancing ease of use, resource requirements, knowledge base, available technologies, etc.


Regards,

Darin


In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
 
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007Report This Post
GamP
Virtuoso
posted Hide Post
The upside of using active html for this request is that it will be done entirely on the client workstation. No interaction with the server any moer, which is the case int he other scenarios.
The downside is that active html output is a license product, you have to pay for it to make it work.
The choice is yours ....


GamP
- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
 
Posts: 1961 | Location: Netherlands | Registered: September 25, 2007Report This Post
dev532
Gold member
posted Hide Post
Hi Gamp,

Active HTML report -

How do I get rid off the page statistics that it displays at the very top.
Such as this one-
30 of 30 records (100%), Page 1 of 2 ►|►►

Also, I wouldn't need a separate license to use Active HTML report if I own a licensed copy of WebFocus, right?

Thanks.


WF 7.1.1, WF Developer studio 7.1.1, Windows & Mainframe, HTML
 
Posts: 84 | Registered: July 28, 2009Report This Post
GinnyJakes
Expert
posted Hide Post
I don't think you can get rid of the stats. However, you can choose to put them on the bottom instead of the top.

Even if you own a copy of WebFOCUS, Active Reports is an additional license.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
dev532
Gold member
posted Hide Post
I am okay with the stats at the top.

I am unable to control the spacing between columns though. The regular SET SPACES, SQUEEZE,WRAP and other options don't seem to have any effect on the Active Reports.

I could get around that by using a Defined field (with whitespace character) and with no Column Title but it still displays the Down Arrow thing for the columns.

All I need is spaces between columns.

Any ideas?

Thanks!


WF 7.1.1, WF Developer studio 7.1.1, Windows & Mainframe, HTML
 
Posts: 84 | Registered: July 28, 2009Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic


Copyright © 1996-2020 Information Builders