"Colin Halliday" <kothesit@newsgroup.nospam> wrote in message
news:e9cunRcBGHA.3840@TK2MSFTNGP15.phx.gbl...

"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
>
>