Display 17 detail records in a group on each page - Crystal Reports

Hi,

I have a crystal report with one group header. If the group consists of more than 17 records in the detail section, then i want to display them in the next page. Can you please provide me the steps to do it ?

Thanks
milani_lucieAsked:
Who is Participating?
 
mlmccConnect With a Mentor Commented:
Try this idea

Add a formula to the group header
WhilePrintingRecords;
Gobal NumberVar GroupRecordCount;
GroupRecordCount := 0;
''

In the detail section add a formula
WhilePrintingRecords;
Gobal NumberVar GroupRecordCount;
GroupRecordCount := GroupRecordsCount + 1;
''

In the section expert
Click the DETAIL SECTION
Click the formula button to the right of NEW PAGE AFTER
WhilePrintingRecords;
Gobal NumberVar GroupRecordCount;
GroupRecordCount = 17;

mlmcc
0
 
milani_lucieAuthor Commented:
How to add a formula to group header ? Can you please provide steps ? Appreciate your time and patience !

Thanks
0
 
milani_lucieAuthor Commented:
Got it. Thanks
0
 
milani_lucieAuthor Commented:
How to add a formula to group header ? Can you please provide steps ? Appreciate your time and patience ! Sorry i stuck up here !!

Thanks
0
 
mlmccCommented:
Did you get it.

Display the field explorer
Right click FORMULAS
Click NEW
Give it a name
Enter the formula
Click SAVE AND EXIT

Drag it from the FIELD EXPLORER to the report just like any other field

mlmcc
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.