Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Reg sorting on individual page.
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Reg sorting on individual page.
 Login/Join
 
Platinum Member
posted
Hia ll,
i have a report with some 1000 records and the report has 10 fields,on 4 fields out of 10 i can do sorting either ASCENDING OR DESCENDING.
each page has 10 records,so total of 100 pages.my question is that if i go to page 2 which has record 11-20,and do sorting on a field.i am going into the page 1.all i need is sorting of the records of page 2 only similarly to the particular pages only.But my sorting is happening for 1- 10 records only for what ever page i pick.

please advise.

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


7.6.7
windows
PDF,EXCEL.
 
Posts: 160 | Location: Atlanta,GA | Registered: July 16, 2009Reply With QuoteReport This Post
Expert
posted Hide Post
Hi Swati,

Can you please provide some more details? For example, is this an AHTML report, or something else? Do you have a code example to share?

Cheers,

Kerry


Kerry Zhan
Focal Point Moderator
Information Builders, Inc.
 
Posts: 1950 | Location: New York | Registered: November 16, 2004Reply With QuoteReport This Post
Expert
posted Hide Post
Swati, you may need to add an extra sort field per page as an outer sort. You'd have to restrict what you put on each page. Then add a dummy sort field to which you would assign the value of the item from the page you want to sort and maybe spaces for the other pages. I can see it in my mind. You will need to be creative and play with it a bit. And start small, with 2 sort fields to start till you get your technique down. Sounds like a fun project.


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, 2006Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Reg sorting on individual page.

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.