Focal Point
[CLOSED] Displaying First Record of Group

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/8747072276

August 20, 2014, 12:44 PM
Mitch P.
[CLOSED] Displaying First Record of Group
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
August 20, 2014, 05:40 PM
Waz
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

August 26, 2014, 09:37 AM
Mitch P.
Thanks, that did the trick.


WebFOCUS 7.6
Windows, All Outputs