As we know, field “record number” from “special fields” in Crystal Report starts from 1 and increase one by one for each record until last page of the report. However, when we need a record number field that resets from 1 whenever the group field changes, we need to manually create it.To create the record number field, here are the steps:
- Create a new “Running Total Field”
- Give a name for the field, for example : rtf_recordNumber
- Choose a field to summarize.
- Set the “Type of summary” to “count”
- On “Evaluate”, choose “For each record”
- On “Reset”, choose “On change of group”.
- Choose the “key” group name field that will reset the record number.
- Click OK
- Add the field to the report.
0 comments:
Post a Comment