How to Display Report Formula Summary in Grid Edit Header
- I have a child table (Tasks) grid edit report (grouped by Phases) that is embedded on a Parent (Projects) Main Form. The full version of the child table grid edit report is available from the parent main form also.
- The phase headers on the Full Report are collapsible by group (Phase) The picture attached show ALL since this is coming from the embedded report, but the FULL report is grouped by phase. The phase headers naturally demonstrate total for the group (Red Boundary in upper right of attached .jpg)
- I created Report Formula to calculate the # tasks complete. I also created a Report Formula for Total Count but do not need this Report Formula because the total is already provided inherently. I added these two columns to the grid edit report (Yellow hashed boundary in upper right of attached .jpg)
My problem: I would like to be able to display the # of Completed Tasks (from the Report Formula) in the Header Row for the Group (Phase) so that I can display "# complete" of n tasks. (Yellow shaded in upper right of attached .jpg). How would I do this?
Alternative: If this is not possible I can also live with embedding a summary report, but I can't quite figure out the Summary Report settings to display as a column (see 2nd attached .jpg with is not filtered)
------------------------------
Annetta Coleman
------------------------------