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] Displaying First Record of Group
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Displaying First Record of Group
 Login/Join
 
Member
posted
I am running the following code:

JOIN
LEFT_OUTER TTR.TTR.TTR_VIN_LAST8 AND TTR.TTR.TTR_VIN_FIRST9 IN TTR TO UNIQUE
CTS.CTS.CTS_VIN_LAST8 AND CTS.CTS.CTS_VIN_FIRST9 IN CTS TAG J0 AS J0
END
-*********************************************************************
-* *
-*********************************************************************
TABLE FILE TTR
PRINT
TTR_REQ_NMBR
TTR_VIN_FIRST9
TTR_VIN_LAST8
TTR_REQ_DATE
TTR_AUC_DATE
TTR_REQ_COMMENT
TTR_TITLE_NMBR
TTR_MAIL_COMMENT
TTR_AUC_NMBR
CTS_CT_MAIL_DATE
CTS_TITLE_IND
CTS_CT_AUC_NMBR AS 'CTS_AUC_NMBR'
BY TTR_VIN_LAST8 NOPRINT
BY HIGHEST TTR_REQ_DATE NOPRINT
WHERE (TTR_VIN_LAST8 EQ 'CF370933');
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE HOLD AS TTRF00A1 FORMAT ALPHA
END

This creates a report of multiple records. I only want to keep the first record. What is the most efficient way to do that?

Also, the final version of this will not have a specified value for the WHERE statement but an input box to allow the person to search for multiple values for a singe run.

Thanks for any assistance,
Mitch P.

This message has been edited. Last edited by: Mitch P.,


WebFOCUS 7.6
Windows, All Outputs
 
Posts: 10 | Registered: August 13, 2014Reply With QuoteReport This Post
Expert
posted Hide Post
If this is only the first record of the returned recordset, then use WHERE RECORDLIMIT EQ 1

If its the first for each BY HIGHEST, then change to BY HIGHEST 1


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.06OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

 
Posts: 6136 | Location: 33.8688° S, 151.2093° E | Registered: October 31, 2006Reply With QuoteReport This Post
Member
posted Hide Post
Thanks, that did the trick.


WebFOCUS 7.6
Windows, All Outputs
 
Posts: 10 | Registered: August 13, 2014Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Displaying First Record of Group

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