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     How to sort the data by retaining the same format in AHTML.

Read-Only Read-Only Topic
Go
Search
Notify
Tools
How to sort the data by retaining the same format in AHTML.
 Login/Join
 
Prash
Member
posted
Hi,
I'm trying to provide the users an option to Sort on the generated report using AHTML format.

When the report generates for the first time then the report looks good. The format of the report looks good when you sort the column which is mentioned in BY.
But when I try to sort on other columns then whole report gets altered. Can anyone suggest the way to resolve the issue.
Even if I sort any column the grouping should remain.

Example:
-------
Column Names:
-------------
1. Dept ( Grouped)
2. First_Name
3. Last_Name
4. Job_desc
5. Sal

When u apply sorting for DEPT column the format doesn't get altered.
But when you try to sort wrt First_Name then all the data starts appearing multiple times, even in Dept column & format gets altered.

Please help me in resolving the above mentioned issue.

Thanks in advance.


WebFOCUS 7.1
Windows
Output: HTML, Excel & PDF
 
Posts: 10 | Registered: November 22, 2007Report This Post
gregv
Guru
posted Hide Post
Prash,
When changing the primary sort field in AHTML format, you won't know what the Dept is unless it is repeated for each item of the new primary sort (Last Name).

Do you want to keep Dept as the primary sort and then sort Last_Name as the secondary sort?

IHTH.
Greg


Greg

current client: WF 8.1.05 & 8.2 - Windows 7 64bit - Tomcat 7 - MRE / BID - IE11

local: WF 8.2 - Windows 7 64bit - Tomcat 6 - MRE / BID - FOCUS - IE11

PMF 8
 
Posts: 274 | Location: Boston/New England | Registered: February 12, 2006Report This Post
Prash
Member
posted Hide Post
Hi Greg,
You are right. No matter on what columns I do sorting, it has to get sorted with respect to the column which is mentioned in BY ie grouped.

Say DEPT is the primary sort & If I sort by FIRST_NAME ya JOB_DESC then the sorting has to take place with respect to the DEPT & layout of the report should remain as it was appearing for the first time.

Thanks & Regards,
Prashanth.


WebFOCUS 7.1
Windows
Output: HTML, Excel & PDF
 
Posts: 10 | Registered: November 22, 2007Report This Post
GinnyJakes
Expert
posted Hide Post
Then you will have to always say BY DEPT first followed by BY FIRST_NAME, etc. Then your report will be sorted by first name within each department.

Is that what you want?


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
gregv
Guru
posted Hide Post
Prash:
If you want the functionality of AHTML output but keep the same layout then you need to create HTML output with your own dropdown list for each column heading that you want the user to do something.

This has the advantage of allowing you to customize the functionality for your audience. It's not difficult it just takes time to write and debug which AHTML has already done.

Once again, you can do most or all of this customization using Dev Studio, if you want.


Greg

current client: WF 8.1.05 & 8.2 - Windows 7 64bit - Tomcat 7 - MRE / BID - IE11

local: WF 8.2 - Windows 7 64bit - Tomcat 6 - MRE / BID - FOCUS - IE11

PMF 8
 
Posts: 274 | Location: Boston/New England | Registered: February 12, 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     How to sort the data by retaining the same format in AHTML.

Copyright © 1996-2020 Information Builders