Wednesday, March 7, 2012

Please Please Please

Hi,
How do i sort on calculate fields?
i have a group which will show the sum of all the details. how do i sort on
the group level ?
EX:
a 55
b 22
c 100
a 55
3
4
3
45
b 22
11
11
c 100
50
50
i want output as
b 22
a 55
c 100
Pls hlep meIn the sorting value of your group, enter this expression :
=Sum(Fields!MyField.Value, "group_name")|||I am doing dynamic sorting - column headers -
and the paramter doesnt take the value of an aggregate.
any other suggestions ?
"Julich" wrote:
> In the sorting value of your group, enter this expression :
> =Sum(Fields!MyField.Value, "group_name")
>|||If dynamic sorting means specifýing the sort column via report parameter
(e.g. "SortBy"), try that as the sorting value for your group:
=Sum(Fields(Parameters!SortBy.Value).Value, "group_name")
"RP" wrote:
> I am doing dynamic sorting - column headers -
> and the paramter doesnt take the value of an aggregate.
> any other suggestions ?
> "Julich" wrote:
> > In the sorting value of your group, enter this expression :
> >
> > =Sum(Fields!MyField.Value, "group_name")
> >
> >

No comments:

Post a Comment