grouping and sorting - dates and balances

[Arlend Floyd]

Im trying to group dates [LastTouched] greater than 45 days and have them in
desending order by the [balance]. Then have a second half of my report with
all other dates [LastTouched] also in desending order by [balance]. I can get
the first group by an expresion : =([LastTouched]<Date()-45) but the grouping
option forces me to select assending or desending for that field.

any ideas

 

[Allen Browne]

The expression:
([LastTouched]<Date()-45)
evaluates to the possible results:
Null, if LastTouched is Null
-1, if the expression is True
0, if the expression is False.

Therefore the grouping will sort in that order if you choose Ascending.

On the next row of the Sorting And Grouping pane, choose the Balance field
to achieve the secondary sort as well.

 

[Arlend Floyd]

Is there a way to bulk the 45 days of [LastTouched] and sort it by [Balance]
only, in desending order for the start of the report and then make the rest
of the report bulk all other dates and sort those by Balance in the same
desending order. Is this possible in one report or do i need two reports?

Thanks

The expression:
([LastTouched]<Date()-45)
evaluates to the possible results:
Null, if LastTouched is Null
-1, if the expression is True
0, if the expression is False.

Therefore the grouping will sort in that order if you choose Ascending.

On the next row of the Sorting And Grouping pane, choose the Balance field
to achieve the secondary sort as well.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Im trying to group dates [LastTouched] greater than 45 days and have them
in
desending order by the [balance]. Then have a second half of my report
with
all other dates [LastTouched] also in desending order by [balance]. I can
get
the first group by an expresion : =([LastTouched]<Date()-45) but the
grouping
option forces me to select assending or desending for that field.

any ideas

 

[Allen Browne]

Yes: that's what you should be getting if you placed that expression into
the Sorting and Grouping box.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Is there a way to bulk the 45 days of [LastTouched] and sort it by
[Balance]
only, in desending order for the start of the report and then make the
rest
of the report bulk all other dates and sort those by Balance in the same
desending order. Is this possible in one report or do i need two reports?

Thanks

The expression:
([LastTouched]<Date()-45)
evaluates to the possible results:
Null, if LastTouched is Null
-1, if the expression is True
0, if the expression is False.

Therefore the grouping will sort in that order if you choose Ascending.

On the next row of the Sorting And Grouping pane, choose the Balance
field
to achieve the secondary sort as well.

Im trying to group dates [LastTouched] greater than 45 days and have
them
in
desending order by the [balance]. Then have a second half of my report
with
all other dates [LastTouched] also in desending order by [balance]. I
can
get
the first group by an expresion : =([LastTouched]<Date()-45) but the
grouping
option forces me to select assending or desending for that field.

any ideas

 

[Arlend Floyd]

That seems to sort the [LastTouched] assending I am only trying to sort
Balance.

Yes: that's what you should be getting if you placed that expression into
the Sorting and Grouping box.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Is there a way to bulk the 45 days of [LastTouched] and sort it by
[Balance]
only, in desending order for the start of the report and then make the
rest
of the report bulk all other dates and sort those by Balance in the same
desending order. Is this possible in one report or do i need two reports?

Thanks

The expression:
([LastTouched]<Date()-45)
evaluates to the possible results:
Null, if LastTouched is Null
-1, if the expression is True
0, if the expression is False.

Therefore the grouping will sort in that order if you choose Ascending.

On the next row of the Sorting And Grouping pane, choose the Balance
field
to achieve the secondary sort as well.

Im trying to group dates [LastTouched] greater than 45 days and have
them
in
desending order by the [balance]. Then have a second half of my report
with
all other dates [LastTouched] also in desending order by [balance]. I
can
get
the first group by an expresion : =([LastTouched]<Date()-45) but the
grouping
option forces me to select assending or desending for that field.

any ideas

 

[Allen Browne]

You lost me.

I understood you to say you wanted to sort the report into 2 group: first
group where LastTouched is 45 days or less, and the 2nd group with the other
dates. Within those 2 groupings, you wanted to sort by Balance.

Therefore you need 2 rows in the Sorting and Grouping: the first row is the
expression that determines whether it is in the first 45 days or not, and
the 2nd row of the dialog is the Balance field.

If that's not what you are doing, I have not understood the question.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

That seems to sort the [LastTouched] assending I am only trying to sort
Balance.

Yes: that's what you should be getting if you placed that expression into
the Sorting and Grouping box.

Is there a way to bulk the 45 days of [LastTouched] and sort it by
[Balance]
only, in desending order for the start of the report and then make the
rest
of the report bulk all other dates and sort those by Balance in the
same
desending order. Is this possible in one report or do i need two
reports?

Thanks

:

The expression:
([LastTouched]<Date()-45)
evaluates to the possible results:
Null, if LastTouched is Null
-1, if the expression is True
0, if the expression is False.

Therefore the grouping will sort in that order if you choose
Ascending.

On the next row of the Sorting And Grouping pane, choose the Balance
field
to achieve the secondary sort as well.

message
Im trying to group dates [LastTouched] greater than 45 days and have
them
in
desending order by the [balance]. Then have a second half of my
report
with
all other dates [LastTouched] also in desending order by [balance].
I
can
get
the first group by an expresion : =([LastTouched]<Date()-45) but the
grouping
option forces me to select assending or desending for that field.

any ideas