|
|
 | | From: | Larry Hakel | | Subject: | Index problem | | Date: | Sun, 23 Jan 2005 09:48:26 -0500 |
|
|
 | I have an complex index "chapter + upper(lastname)+upper(firstname)".
In a report which groups by chapter as long as there is a value in
the chapter field the names are arranged in alphabetical order, as
expected. However, if the chapter value is a NULL then the names are
not in alphabetical order. They are grouped at the beginning of the
report but not arranged in alphabetical order.
How can I get these names arranged in alphabetical order when the
chapter field is empty or a NULL?
Larry
|
|
| | From: | Howard Mintzer | | Subject: | Re: Index problem | | Date: | Sun, 23 Jan 2005 10:33:44 -0500 |
|
|
| Larry
I think your problem occurs because null plus anything is still null
(just like zero times anything is still zero).I'd replace any nulls that
are in the chapter field now with space(0).And then set the default for
the chapter field (use the table designer and the inspector to do this)
to space(0) so you won't add null values but blank value. I think then
it should work for you. Another way would be to set the rowsets autonull
property to false or the global set autonulls off to make sure that your
chapter fields don't have nulls in them.
Howie
Larry Hakel wrote:
>I have an complex index "chapter + upper(lastname)+upper(firstname)".
>
>In a report which groups by chapter as long as there is a value in
>the chapter field the names are arranged in alphabetical order, as
>expected. However, if the chapter value is a NULL then the names are
>not in alphabetical order. They are grouped at the beginning of the
>report butnotarrangedinalphabeticalorder.
>
>How can I get these names arranged in alphabetical order when the
>chapter field is empty or a NULL?
>
>Larry
>
>
|
|
|
