Totaling A Range

[sprog]

Hi there

I am writing a report from my payroll system. I need dollar figures of different payments made in the last quarter. When I enter the "Period End Date" into the filter, I am asking it to calculate on the Period End Date "between" 01/01/06 and 31/03/06.
My answers are correct, but it brings back information for every single pay period within this range. I just want one total for all of the periods within this range. (Not individualised).

Any help would be appreciated.

Thanks
Julie

 

[lbass]

You need all the individual records to arrive at the total. After inserting summaries on your detail amounts, go to the section expert and suppress the detail section so that only your totals are displayed.

If you have a version 9 or greater, you could instead write a command that returns only the totals you are looking for.

-LB

 

[sprog]

Thank you. I do have a version higher than 9, so are you able to help with a command that will only return the totals?

Many thanks for your reply.
J

 

[lbass]

Please identify the tables and fields you are using, what your group field is, and what field you want to total.

-LB

 

[sprog]

I am grouping by "Cost Centre" and want fields "Ordinary Time", "Overtime" & "Sick Leave" shown on my report. I am filtering by Pay Period and want total ordinary time for cost centre A for the pay period 01/01/06 to 26/03/06.
Same for Overtime & Sick leave etc.

Thanks
J

 

[lbass]

Can't help you without the tables and fields info. But, on second thought, it might be simplest just to suppress the detail section. If you don't already have a group on quarter, you can create a formula to group on:

if {table.date} in date(2006,01,01) to date(2006,03,26) then "Qtr 1" else
if {table.date} in date(2006,03,27) to date(2006,06,26) then
"Qtr 2" else //etc.

Then you can insert summaris at the the quarter group level and suppress the detail section.

-LB

 

[sprog]

Thank you IB. This did work.

J