Multiple Sum of details

I am trying to build a payroll report where I have my earning at the top,
followed by the the sum. Then I will have the withholding, followed by the
sum of withholdings. Lastly, I will have the benefits, followed by the sum
of benefits. How can I do this and have spaces between each set? I can
differentiate my earnings, withholdings and benefits by a code in the row,
1,2 and 3.
The report will have one page per employee (the group by). My report should
look something like this;
Employee Joe Tanona
Earnings
Bonus 100
Salary 200
Sum 300
Withholding
Medical 40
401k 100
Sum 140
Beneifts
blah 20
blalbla 30
sum 50
Any thoughts on how to do this? I am using a stored proc to do the sum, I
also have a ytd column on the right of the amount. The date is the only
parameter.
Thanks,
RyanOn Dec 17, 9:04 pm, Ryan Mcbee <RyanMc...@.discussions.microsoft.com>
wrote:
> I am trying to build a payroll report where I have my earning at the top,
> followed by the the sum. Then I will have the withholding, followed by the
> sum of withholdings. Lastly, I will have the benefits, followed by the sum
> of benefits. How can I do this and have spaces between each set? I can
> differentiate my earnings, withholdings and benefits by a code in the row,
> 1,2 and 3.
> The report will have one page per employee (the group by). My report should
> look something like this;
> Employee Joe Tanona
> Earnings
> Bonus 100
> Salary 200
> Sum 300
> Withholding
> Medical 40
> 401k 100
> Sum 140
> Beneifts
> blah 20
> blalbla 30
> sum 50
> Any thoughts on how to do this? I am using a stored proc to do the sum, I
> also have a ytd column on the right of the amount. The date is the only
> parameter.
> Thanks,
> Ryan
You might try adding a table footer to the table control (right-click
the left-most-part of the last row in the table control and select add
row). This should give you a space assuming that you group on whatever
type/category that these are a part of (Earnings, Withholding,
Benefits) and then group on employee and perform a page break after
each employee group. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||That helps with the space, but what about the three different groupings that
I am trying to sum? Do I need three grouping or can I do this in details?
"EMartinez" wrote:
> On Dec 17, 9:04 pm, Ryan Mcbee <RyanMc...@.discussions.microsoft.com>
> wrote:
> > I am trying to build a payroll report where I have my earning at the top,
> > followed by the the sum. Then I will have the withholding, followed by the
> > sum of withholdings. Lastly, I will have the benefits, followed by the sum
> > of benefits. How can I do this and have spaces between each set? I can
> > differentiate my earnings, withholdings and benefits by a code in the row,
> > 1,2 and 3.
> >
> > The report will have one page per employee (the group by). My report should
> > look something like this;
> >
> > Employee Joe Tanona
> > Earnings
> > Bonus 100
> > Salary 200
> > Sum 300
> >
> > Withholding
> > Medical 40
> > 401k 100
> > Sum 140
> >
> > Beneifts
> > blah 20
> > blalbla 30
> > sum 50
> > Any thoughts on how to do this? I am using a stored proc to do the sum, I
> > also have a ytd column on the right of the amount. The date is the only
> > parameter.
> >
> > Thanks,
> > Ryan
>
> You might try adding a table footer to the table control (right-click
> the left-most-part of the last row in the table control and select add
> row). This should give you a space assuming that you group on whatever
> type/category that these are a part of (Earnings, Withholding,
> Benefits) and then group on employee and perform a page break after
> each employee group. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||On Dec 18, 7:15 am, Ryan Mcbee <RyanMc...@.discussions.microsoft.com>
wrote:
> That helps with the space, but what about the three different groupings that
> I am trying to sum? Do I need three grouping or can I do this in details?
> "EMartinez" wrote:
> > On Dec 17, 9:04 pm, Ryan Mcbee <RyanMc...@.discussions.microsoft.com>
> > wrote:
> > > I am trying to build a payroll report where I have my earning at the top,
> > > followed by the the sum. Then I will have the withholding, followed by the
> > > sum of withholdings. Lastly, I will have the benefits, followed by the sum
> > > of benefits. How can I do this and have spaces between each set? I can
> > > differentiate my earnings, withholdings and benefits by a code in the row,
> > > 1,2 and 3.
> > > The report will have one page per employee (the group by). My report should
> > > look something like this;
> > > Employee Joe Tanona
> > > Earnings
> > > Bonus 100
> > > Salary 200
> > > Sum 300
> > > Withholding
> > > Medical 40
> > > 401k 100
> > > Sum 140
> > > Beneifts
> > > blah 20
> > > blalbla 30
> > > sum 50
> > > Any thoughts on how to do this? I am using a stored proc to do the sum, I
> > > also have a ytd column on the right of the amount. The date is the only
> > > parameter.
> > > Thanks,
> > > Ryan
> > You might try adding a table footer to the table control (right-click
> > the left-most-part of the last row in the table control and select add
> > row). This should give you a space assuming that you group on whatever
> > type/category that these are a part of (Earnings, Withholding,
> > Benefits) and then group on employee and perform a page break after
> > each employee group. Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
If you have a secondary group on Earnings, Withholding, Benefits say
called TransactionType, then you would create a subtotal/sum
expression on the TransactionType group (which should be a subgroup of
the employee group). If you are referring to summing all three in this
group together, you should be able to either use a sum expression or a
subtotal based on the employee group. If this does not achieve your
desired outcome, you will most likely want to use a while loop or
cursor in the stored procedure/query that is sourcing the report. Hope
this helps further.
Regards,
Enrique Martinez
Sr. Software Consultant