-->

21 December 2019

Asp.Net C# How to Repeat Group footer on every page In Crystal Report

  Asp.Net CS By Example       21 December 2019



  How to Repeat Group footer on every page:
   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.
logoblog

Thanks for reading Asp.Net C# How to Repeat Group footer on every page In Crystal Report

Previous
« Prev Post
Oldest
You are reading the latest post

No comments:

Post a Comment

Please do not enter any spam link in the comment box.