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,
SUM fst./max./lst./ave. (select what is appropriate) BY DATE
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?
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';
|Powered by Social Strata|