Hello Foster,
There is an example of this under the Sample Applications settings. It can be found at
http://www.lantica.com/Forum2/cgi-bin/yabb/YaBB.pl?board=samples;action=display;...The new view that you just added will be after your first view. If you look in the example you will see the only thing in the Second view appears in the Group Header, you do not want to put it in the group body as it would repeat once for each record that you retrieved.
Most of the programming in the sample you can ignore, because it has nothing to do with group totals. You will need programming in three separate events. The first one is Global Code. The code in this event would read
Stat gsGrandTotal as Int
gsGrandTotal = 0
The second place where code is needed is in the On Print event of the Value Box that you are totaling. For example lets say that the Report Block is named "Cost", In the example it is LE3. The following would go in the Cost on Print event.
gsGrandTotal += Cost
The third and last place where code is needed is in the On Print event of a unbound value box in the group header in the second view. In the example it is named LE7, you can name it whatever you like. Your code would look like the following, MyGrandTotal is the name of the Value Box.
MyGrandTotal = gsGrandTotal
You will then need to set the Width statements for the columns in
both views. This is necessary so the second view lines up with the columns in the first view.
You are printing both views. The one with the data first and then comes the view that only displays the Grand Total.