- 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)
Thanks for mentioning formula queries. I read the article about them during an early AM coffee. They seem very powerful * useful. I am going to park this particular use case (which is classified as a "nice to have" for our MVP) until later this weekend so that I can burn down the "must have" list. Oh.... I also need to cook a turkey today for family coming for Thanksgiving dinner this afternoon. :)
I will definitely check out formula queries and appreciate you introducing me to them.