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     [SOLVED] sort in across
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] sort in across
 Login/Join
 
Silver Member
posted
I am working on a report. Everthing is working fine except sorting.

I want to sort by 2009 sales.

here is the data
2007 2008 2009
a1 300 350 200
a2 200 450 100
a3 100 300 150.

Thanks,
SG.

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


Webfocus 7.6.8
PDF,HTML & EXCEL
 
Posts: 32 | Location: memphis,tn | Registered: January 25, 2007Reply With QuoteReport This Post
Virtuoso
posted Hide Post
We'll need more information thatn what you've provided.What is your data source? What have you tried that is not working? What does your master file look like?

At first glance, you have
PRINT 2007 2008 2009
BY SORTFILED (which would be the a1,a2,a3) values.

Just switch it to
PRINT 2007 2008 2009
BY 2009 NOPRINT
BY SORTFIELD

It's just a matter of getting your sort fields in the right order.

P.S. It also helps to ask a more specific question than "here's my problem. Fix it."


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, 2007Reply With QuoteReport This Post
Silver Member
posted Hide Post
Thanks for your response.
I am using year as across field and doing summary on sales column and by custname.

TABLE FILE custdata
SUM sales
ACROSS year
BY custname.
END.
I want my result set to be sorted by current year's sales data.
I tried
BY HIGHEST TOTAL SALES NOPRINT. Did not work.

Thanks,
SG.


Webfocus 7.6.8
PDF,HTML & EXCEL
 
Posts: 32 | Location: memphis,tn | Registered: January 25, 2007Reply With QuoteReport This Post
Expert
posted Hide Post
best to use the CAR file when asking for help on a technique...
then we can copy your code, run it, fix it, post it back.

DEFINE FILE CAR
sorter/I9=IF COUNTRY EQ 'W GERMANY' THEN SALES ELSE 0;
END
TABLE FILE CAR
SUM SALES BY HIGHEST TOTAL sorter NOPRINT
BY CAR ACROSS COUNTRY
END




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Reply With QuoteReport This Post
Virtuoso
posted Hide Post
The synatx should be: BY TOTAL HIGHEST sorter ...


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

 
Posts: 1934 | Location: Tel Aviv, Israel | Registered: March 23, 2006Reply With QuoteReport This Post
Silver Member
posted Hide Post
Thanks! Susannah.
It is working now.
Will try to communicate better next time.
Thanks all, for your responses.
SG


Webfocus 7.6.8
PDF,HTML & EXCEL
 
Posts: 32 | Location: memphis,tn | Registered: January 25, 2007Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] sort in across

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