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