I'm working on the same custom report where I need to report on contact activity and show starting and ending times for appointments.  Now my boss has asked me to have a summary field by group.

I have got this to work correctly, by adding duration hours to the group footer and telling it to sum.  The problem is that I can not move the sum field right or left, which I CAN deal with but it put a heading that says "Duration hours" over the top of a couple of my other group headings.  This heading needs to be moved to the footer area.

Hi,

You can move this field around in the advanced layout by dragging/dropping it where you like.

The field heading that got added automatically to the group header can be deleted. If you would like to add another "label" type field to identify the sum you added, you can add one either by adding a "label" field with the label tool (on toolbar) or by creating a field object and enclosing the text for the label in quotations.

Trevor

I experienced similar behavior when creating fields on the "Duration Hours" field here. It looks like what is actually happening is, it is pulling the wrong width for this field from the database, when the field is added in the advanced report designer. As a result, the label is getting created, but with 0 width. So, you can see the full label, but what you are seeing is not actually the label object (which is so thin, you can't see it on the layout).

I have asked the Act! developer to look in to why this problem is occuring, and there will likely be a fix in place in the upcoming Stonefield Query release. Until the release date, you can workaround this issue by manually setting the width each time you add a field in the advanced report designer that exhibits this issue. So, after you select the table/field with the expression builder, notice that the "width" entry for the field's properties is set to 0. Increase this to a nonzero value, and it should allow you to actually select the field and move/delete it.