Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Displaying Group Summary field

Status
Not open for further replies.

rkgrp

Programmer
Oct 29, 2003
15
US
Using Crystal Report 8.5.

I have a requirement to display group's running total value on Report Header Section. I have tried using the same sum of running total field in report header, it just display 0 (zero). But running total at group footer shows value. How do I achieve displaying this running total

Is there any other way I can acheieve this other than using running total.

In visual:

-------------
Report Hdr:

Count: <run_var_tot_count> ---- 0 ?

--------
Page Hdr:
---------------
Grp Hdr: run_var_reset
---------------
Detail: run_var_tot_count + count
---------------
Grp Ftr: run_var_tot_count
---------------
Rpt Ftr:
-----------
Page Ftr:
-----------

Thank you
rkgrp
 
Right-click on a suitable field, select [Insert Field] and then chooose [Summary].

Summary totals are taken from the data, which means that Crystal knows the answer at the time it prints the group header. Running totals are updated as each detail line is printed, which is why they are always zero in the group header.

Summary totals lack the subtleties of running totals, and in particular you can't make them conditional. If you wanted to count just some of the records in the group, you'd have to use formula fields with variables.

Madawc Williams
East Anglia, Great Britain
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top