Thanks.
Finally, I succeeded in accomplishing it as follows:
Moved Chart.AccountID and Sum of JrnlRow.Amount from Group Header to Group Footer (It was needed because I was not getting the value of OnLastRecord in Group Header).
Created a formula field grprecno with the following formula:
WHILEPRINTINGRECORDS; GLOBAL NUMBERVAR GroupRecNumber; GroupRecNumber := GroupRecNumber + 1;
Created a formula field mod_record with the following formula:
({@grprecno} Mod 8)
Then I inserted seven Group Footer sections from Group Footer # 1b to Group Footer # 1h and inserted a blank line in each footer. Then in the section expert, entered the following formula for each footer in Suppress (No Drill-Down).
//Group Footer # 1b: Chart.AccountID If OnLastRecord = true Then If {@Mod_Record} <= 1 Then false Else true Else true //Group Footer # 1c: Chart.AccountID If OnLastRecord = true Then If {@Mod_Record} <= 2 Then false Else true Else true //Group Footer # 1d: Chart.AccountID If OnLastRecord = true Then If {@Mod_Record} <= 3 Then false Else true Else true //Group Footer # 1e: Chart.AccountID If OnLastRecord = true Then If {@Mod_Record} <= 4 Then false Else true Else true //Group Footer # 1f: Chart.AccountID If OnLastRecord = true Then If {@Mod_Record} <= 5 Then false Else true Else true //Group Footer # 1g: Chart.AccountID If OnLastRecord = true Then If {@Mod_Record} <= 6 Then false Else true Else true //Group Footer # 1h: Chart.AccountID If OnLastRecord = true Then If {@Mod_Record} <= 7 Then false Else true Else true
Regards,
Aziz
Add comment