how to get the total amount and hide the field
In Crystal report parameter screen, user has the option to Mutliselect either Donor or Grant or Donor & Grant; based on that in report output user is expected to see list of Donors with Grand Total. Requirement is not to split Amount by Donor rather need to show list of all Donor in header and Grant Total in Footer.
For example from the above list if user selected Algeria, Austria, Australia and India each country/Donor contribution is 150 than expected output will be
Grand Total = 600
please let me know if any one get idea about this requirement.