Thanks to IdoMillet i was able to figure out how to randomize the data but now i cant figure out how to make it so it picks 5 records for each group instead of just 5 records total. IdoMillet mentioned that you would have to apply it to "within group" logic but i am uncertain as to what this means. Does anyone know how to suppress the details for each group so it only shows 5 records?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
suppressing detail for each group
- Thread starter draacor
- Start date
You may need to manually count your detail records and suppress accordingly.
// formula @CntDetail - place in detail section and suppress printing of this formula.
WhilePrintingRecords;
numberVar Cnt;
Cnt:= Cnt + 1
// formula @CntDetailReset - Place in group footer and suppress printing of this formula.
WhilePrintingRecords;
numberVar Cnt:= 0
In detail section expert conditionally suppress with following formula:
{@CntDetail} > 5
MrBill
// formula @CntDetail - place in detail section and suppress printing of this formula.
WhilePrintingRecords;
numberVar Cnt;
Cnt:= Cnt + 1
// formula @CntDetailReset - Place in group footer and suppress printing of this formula.
WhilePrintingRecords;
numberVar Cnt:= 0
In detail section expert conditionally suppress with following formula:
{@CntDetail} > 5
MrBill
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question