how to get the total amount and hide the field

[Former Member]

Hi Experts,

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

Algeria

Austria

Australia

India

America

Grand Total = 600

please let me know if any one get idea about this requirement.

Best Regard,

sowjanya.k

[abhilash_kumar]

Hi Sowjanya,

If you're simply trying to place a grand total, use the 'Insert Summary' option.

Choose the measure field as the 'Field to Summarize' > Choose 'Sum' as the summary operation > Under 'Summary Location' choose 'Grand Total Report Footer'.

-Abhilash

[TammyPowlas]

Moved to Crystal Reports space for faster response

[Former Member]

Hi Tammy Powlas,

Thanks for your response.