How to add Serial No field to Group Data in crystal Report:
When we work with group data dusplay on crystal report. if we use record Number field from
Special Filed of report then it is not reset when group is changed it will show continue Serial Number (Sr.No.)
To Reset or show right way Sr.No. to crystal report. We can achieve by many ways.
But easiest way is running field. This is easy to create and used.
Use Following steps:
1) Right click on 'Running Total Fields'
2) Choose 'New' Option.
3) Give Running Total Name.E.g.:RSrNo
4) Choose 'Filed to summarize' from 'Available Tables and Fields'.
5) Set 'Type of Summary' from ComboBox .Choose 'count'.
6) In 'Evaluate' Choose 'For each record' option.
7) In 'Reset' Choose 'On change of group'.
8) On Select 'OK' Button.
Now Place this running total field on report.
No comments:
Post a Comment
Please do not enter any spam link in the comment box.