When we work with group field on crystal report, group header will be print on every page
by using group header option print on every page. But the group footer print on after every group and their
has no option to print group footer on every page. We can accomplish as same as group footer using display
sum of required filed in page footer using running field.
For this follow bellowing steps:
Step 1:
Add Datatable field on report.
Step 2:Add Group Field on crystal Report:
=> Click On Crystal Report.
=> Select 'Report' Option.
=> Now click on 'Group Expert'.
=> Now 'Group Expert' Screen will be open. (ShortCut Key :Alt+R,R,G)
=> Now Select which field we want Group from report feild or dataset and
Click on 'Option'button to set order by . asc or desc.
=> Now Click on 'Ok' Button.
Step 3: Write click on Group Header and select 'Hide' Option.
Step 4: Write click on Group footer and select 'Hide' Option.
Step 5: Group Header Print on every page
=> Click On Crystal Report.
=> Select 'Group Header' Option.
=> Now click on 'Group Expert'.
=> Now 'Group Expert' Screen will be open. (ShortCut Key :Alt+R,R,G)
=> Now Click on 'Options' Button.
=> Now again select 'Option' Tab from New Open screen.
=> Now Select Check Box for Below option.
1) Keep Group Together.
2) New Page After
3) Repeat Group Header On Each Page.
=> Now Select 'Ok' Button.
=> Now Again Select 'Ok' Button.
Step 6: Now Create Running Fields of which we want to show sum in Group footer (mean Page Footer).
.
E.g.Right Click on 'Running Totals Option' From Field Explorer.
=> Now click on 'New' Option.
=> Now Give Name for Running Total Field.
=> Now select Field to Summarize from Left side datatable and click on '>' option.
=> Now From 'Reset' Option. Select option'On Change of group'.
=> Now Click on 'Ok' Button.
Step 7: Now Place Running Field in Page Footer.
No comments:
Post a Comment
Please do not enter any spam link in the comment box.