This is a multi-part message in MIME format.
--=_NextPart_000_0008_01C60620.7A602800
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
I am building a report based on an SQL Server 2005 Analysis Services = Cube of staff members' hours worked for a month, broken down into = chargeable and non-chargeable time.
I can create the dataset that I require fine and add 2 columns to the = filter panel and tick the PARAMETERS check boxes (year and month). It = then generates 2 other datasets for the parameters and adds those = parameters to the report.
I have added a table control to the report and grouped by staff member's = name.
When I preview the report I can select the parameters and generate the = report.
However the data fields in the detail row [e.g. = "=3DSum(Fields!Work_Hours.Value, "KothesDSS")"] gives the grand total of = all staff members' hours for the month and repeats for every staff = member - it does not seem to be grouping and giving me the total for the = individual, just the total for all staff over and over.
Any clues would be appreciated.
Thanks.
-- Colin Halliday
--=_NextPart_000_0008_01C60620.7A602800
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
I am building a report based on an SQL = Server 2005 Analysis Services Cube of staff members' hours worked for a month, = broken down into chargeable and non-chargeable time.
I can create the dataset that I require = fine and add 2 columns to the filter panel and tick the PARAMETERS check boxes = (year and month). It then generates 2 other datasets for the parameters and = adds those parameters to the report.
I have added a table control to the = report and grouped by staff member's name.
When I preview the report I can select = the parameters and generate the report.
However the data fields in the detail = row [e.g. "=3DSum(Fields!Work_Hours.Value, "KothesDSS")"] gives the grand total of = all staff members' hours for the month and repeats for every staff member - it = does not seem to be grouping and giving me the total for the individual, just the = total for all staff over and over.
Any clues would be = appreciated.
Thanks.
-- = Colin Halliday
--=_NextPart_000_0008_01C60620.7A602800--Hi Colin,
Two things to check:
1. Make sure the scope of your sum() function is set for the staff member's
name group (i hope "KothesDSS" is the group name. Otherwise, if it's the
dataset name for the whole table, that would explain why it always shows the
total for all the staff)
2. If the above won't work, then try replacing sum with
RunningValue(Expression, Function, Scope)
example :
RunningValue( Fields!Work_Hours.Value, sum, "DataSet1" ) or
RunningValue( Fields!Work_Hours.Value, sum, "<name_of_your_group_here" )
Hope this helps,
Andrei.
"Colin Halliday" <kothesit@.newsgroup.nospam> wrote in message
news:e9cunRcBGHA.3840@.TK2MSFTNGP15.phx.gbl...
I am building a report based on an SQL Server 2005 Analysis Services Cube of
staff members' hours worked for a month, broken down into chargeable and
non-chargeable time.
I can create the dataset that I require fine and add 2 columns to the filter
panel and tick the PARAMETERS check boxes (year and month). It then
generates 2 other datasets for the parameters and adds those parameters to
the report.
I have added a table control to the report and grouped by staff member's
name.
When I preview the report I can select the parameters and generate the
report.
However the data fields in the detail row [e.g.
"=Sum(Fields!Work_Hours.Value, "KothesDSS")"] gives the grand total of all
staff members' hours for the month and repeats for every staff member - it
does not seem to be grouping and giving me the total for the individual,
just the total for all staff over and over.
Any clues would be appreciated.
Thanks.
--
Colin Halliday|||Thanks, "KothesDSS" was the dataset name. When I changed this to the group
name it worked fine.
Colin
"andrei" <andrei.toma@.era-environmental.com> wrote in message
news:%23ZFUS7jBGHA.2664@.TK2MSFTNGP15.phx.gbl...
> Hi Colin,
> Two things to check:
> 1. Make sure the scope of your sum() function is set for the staff
> member's
> name group (i hope "KothesDSS" is the group name. Otherwise, if it's the
> dataset name for the whole table, that would explain why it always shows
> the
> total for all the staff)
> 2. If the above won't work, then try replacing sum with
> RunningValue(Expression, Function, Scope)
> example :
> RunningValue( Fields!Work_Hours.Value, sum, "DataSet1" ) or
> RunningValue( Fields!Work_Hours.Value, sum,
> "<name_of_your_group_here" )
> Hope this helps,
> Andrei.
>
> "Colin Halliday" <kothesit@.newsgroup.nospam> wrote in message
> news:e9cunRcBGHA.3840@.TK2MSFTNGP15.phx.gbl...
> I am building a report based on an SQL Server 2005 Analysis Services Cube
> of
> staff members' hours worked for a month, broken down into chargeable and
> non-chargeable time.
> I can create the dataset that I require fine and add 2 columns to the
> filter
> panel and tick the PARAMETERS check boxes (year and month). It then
> generates 2 other datasets for the parameters and adds those parameters to
> the report.
> I have added a table control to the report and grouped by staff member's
> name.
> When I preview the report I can select the parameters and generate the
> report.
> However the data fields in the detail row [e.g.
> "=Sum(Fields!Work_Hours.Value, "KothesDSS")"] gives the grand total of all
> staff members' hours for the month and repeats for every staff member - it
> does not seem to be grouping and giving me the total for the individual,
> just the total for all staff over and over.
> Any clues would be appreciated.
> Thanks.
> --
> Colin Halliday
>
Showing posts with label charset. Show all posts
Showing posts with label charset. Show all posts
Monday, March 26, 2012
Subscribe to:
Posts (Atom)