This is a multi-part message in MIME format.
--=_NextPart_000_015E_01C572BF.645C0780
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi,
I have two groupings in my table. one based of employee_id and the other = based on employee region. I am showing some values in the detail row of = that table.
Now, I need to show the total of one field in employee_id group1 footer = and employee_region group2 footer as well. the value that I display in = detail field can be type a or b. so I need to show 2 totals for both the = groups. How can I do this.
Group1:Header Employee_ID 1
Group2:Header Employee_Region Madrid
Detail Value:10 Type: B
Detail Value:10 Type: A
Detail Value:10 Type: B
Detail Value:10 Type: B
Detail Value:10 Type: A
Group2:Footer Total for Type A: 20
Group2:Footer Total for Type B: 30
Group2:Header Employee_Region Moscow
Detail Value:20 Type: B
Detail Value:20 Type: A
Detail Value:20 Type: B
Detail Value:20 Type: B
Detail Value:20 Type: A
Group2:Footer Total for Type A: 40
Group2:Footer Total for Type B: 60
Group1:Footer Total for Type A: 60
Group1:Footer Total for Type B: 90
My problem is in calculating Totals for Type A and B based on EmployeeID = and EmployeeRegion.How can I do this
Any help on this will be appreciated
Thanks in Advance
Kiran
--=_NextPart_000_015E_01C572BF.645C0780
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Hi,
I have two groupings in my table. one based of employee_id and = the other based on employee region. I am showing some values in the detail = row of that table.
Now, I need to show the total of one field in employee_id group1 = footer and employee_region group2 footer as well. the value that I display in = detail field can be type a or b. so I need to show 2 totals for both the groups. How = can I do this.
Group1:Header Employee_ID 1
Group2:Header Employee_Region Madrid
Detail Value:10 Type: B
Detail Value:10 Type: A
Detail Value:10 Type: B
Detail Value:10 Type: B
Detail Value:10 Type: A
Group2:Footer Total for Type A: = 20
Group2:Footer Total for Type B: = 30
Group2:Header Employee_Region Moscow
Detail Value:20 Type: B
Detail Value:20 Type: A
Detail Value:20 Type: B
Detail Value:20 Type: B
Detail Value:20 Type: A
Group2:Footer Total for Type A: = 40
Group2:Footer Total for Type B: = 60
Group1:Footer Total for Type A: = 60
Group1:Footer Total for Type B: = 90
My problem is in calculating Totals for Type A and B based on EmployeeID and EmployeeRegion.How can I do this
Any help on this will be appreciated
Thanks in Advance
Kiran
=
--=_NextPart_000_015E_01C572BF.645C0780--For EmployeeID group - totals for type A
=Runningvalue(IIF(Reportitems!Type ="A",Reportitems!Detailvalue,0),SUM,employeeID groupname)
For EmployeeRegion group -
=Runningvalue(IIF(Reportitems!Type ="B",Reportitems!Detailvalue,0),SUM,employeeRegion groupname)|||Thanks Sonali.
Kiran
"Sonali" <Sonali@.discussions.microsoft.com> wrote in message
news:2694E290-3E42-4420-AD55-15D498A661EE@.microsoft.com...
> For EmployeeID group - totals for type A
> =Runningvalue(IIF(Reportitems!Type => "A",Reportitems!Detailvalue,0),SUM,employeeID groupname)
> For EmployeeRegion group -
> =Runningvalue(IIF(Reportitems!Type => "B",Reportitems!Detailvalue,0),SUM,employeeRegion groupname)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment