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] regarding the MAX of date.
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] regarding the MAX of date.
 Login/Join
 
Platinum Member
posted
HI ALL,

i have a report which contains some 100 records,out of those 100 record,first 25 are same record,next 25 are same,like wise i have 4 sets of 25 each.
Now i want to display only 4 records only i.e; out of each 25 set i want to display only 1,so please guide me on How to proceed.
i am using distinct and it's not working;i have as field called date,can i use Max of that date to pull only one record per set.(each set has similar date,so can i proceed with max date).
please help....

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
Virtuoso
posted Hide Post
SUM fst./max./lst./ave. (select what is appropriate) BY DATE


GamP

- Using AS 8.2.01 on Windows 7 - IE11.
in Focus since 1988
 
Posts: 1960 | Location: Netherlands | Registered: September 25, 2007Reply With QuoteReport This Post
Guru
posted Hide Post
I think i dont understand your question. Are you useing BY DATE field? If you have hidden sort fields? Are you using developer studio to write this report? I dev studio you can uncheck repete sorted value or in code you can see if BY DISPLAY OFF?


WebFOCUS 7.6.10
Windows
HTML
 
Posts: 294 | Registered: March 04, 2010Reply With QuoteReport This Post
Member
posted Hide Post
Ok I assume you have the sort correctly, so what you want is the 1st record.
add the following to your report.
COMPUTE GOODREC/A1=IF FIELDNAME NE LAST FIELDNAME THEN 'Y'
REPEAT THIS OVER AND OVER TO INCLUDE ALL YOUR SORT FIELDS
ELSE 'N'; NOPRINT

.
.
.
.
WHERE TOTAL GOODREC EQ 'Y';
 
Posts: 17 | Location: Colorado, USA | Registered: January 22, 2010Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] regarding the MAX of date.

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