how to display running total on page/group header

[HRHK]

I want to display the running Total Amount of the detail section in the Group header or page header.
In the detail section, I display item and item price. I want to calculate
total of all the item price and display the total in header section. I have grouped the item
by Vendor. The Running TotalAmount works only in the Group Footer section
but not in the Group Header/Page Header. While calculating the Running total,
I selected reset on Change of group: Vendor name.
How can I fix this? Thanks in advance.

 

[HRHK]

Got it working by right clicking on the detail section of the item price and inserting the summary and dragging it to the header.

 

[Jameson55]

This doesn't seem to work for placing the running total in the Report Header. I can show the total at the end of the report, but not at the beginning (where the summary information is located.) Any ideas? - Jamie

 

[lbass]

If you are trying to show group summaries in the report header, then try inserting a crosstab, using your group as the row field, and the field you want to summarize in the summary area.

Another approach would be to save the report under another name and insert it as a subreport in the report header. In the subreport, suppress the details section so that only the relevant summaries are displayed.

-LB

 

[Jameson55]

oooh- I was afraid that was going to be your answer. This report was created to replace a pre-printed form used to calculate and pay our union workers fees and dues based on the number of hours worked. The detailed information was listed after the totals. It was a really great report until they realized that we only want the hours after the workers have been on the job for more than 30 days. I had to add formulas to correctly calculate the correct number of hours for the month and then create a running total. Works great as long as the running total is at the end of the report. I'll try the sub-report avenue and see if that works. Thanks...Jamie

 

[lbass]

You might be able to use conditional formulas instead of running totals, but it is unclear what kind of display you want to show. If it is per worker, then you will need a crosstab. A conditional formula for the detail section might look like:

if datediff("d",{table.hiredate},{table.workdate}) > 30 then {table.hours}

You could use this in a crosstab.

-LB

 

[Jameson55]

Unfortunately, the printed report has to exactly match the format from the union, so I went the "subreport" route and it worked just fine. Thanks for your help. Jamie