I have two request synchronized. Of course, some lines appears with a NULL value. No problems at all.
But when i want to sort on the object which have null values. Lines with NULL values appears first in my rapport. I would prefer to have theese lines at the end.
Can’t you help me to prevent from this problem.
I had already this problem and all I found was to build a new variable based on the object that takes a particular value when NULL. The formula looks like this:
If IsNull() then “NULL VALUE” Else
You can then apply a custom sort so that “NULL VALUE” comes at the end.
I have two request synchronized. Of course, some lines appears with a NULL value. No problems at all.
But when i want to sort on the object which have null values. Lines with
NULL values appears first in my rapport. I would prefer to have theese lines at the end.
Can’t you help me to prevent from this problem.
In a message dated 98-07-01 12:32:32 EDT, you write:
I have two request synchronized. Of course, some lines appears with a
NULL value. No problems at all.
But when i want to sort on the object which have null values. Lines with NULL values appears first in my rapport. I would prefer to have theese lines at the end.
Can’t you help me to prevent from this problem.
Thanks a lot.
Laurent DUMONT
Laurent: please first make sure that the synchronization is giving you correct results. In most cases that I have seen, a query synchronization is not a good thing to have! It generally means that there is nothing in common between your the parts of your queries, and that perhaps the objects should not be used together. Inproper definition of contexts can cause this problem as well.
Having said that, it may be that in your case the synchronization is correct, and you may have already verified this.
To gain more control over your sorts, you need to be using BusObj 4.1 rather than 4.0. (You did not mention which version you are using.) In 4.1 you have the option of creating a custom sort, which would allow you to place the #EMPTY (BusObj representation of null) at the top or bottom of the list of values, whichever you prefer. This custom sorts option is found under the SORTS option from the FORMAT menu. It is not found in Slice and Dice.
Regards,
Dave Rathbun
Integra Solutions www.islink.com See you in Orlando in '98!
If the object is numeric you can use ‘= + 0’ (or ‘=If IsNull() then 0 Else ’). Of course it will only sort in the correct order (i.e. nulls at the bottom) if all the other values are greater than zero.
If you have negative values, and you know what the lowest possible numeric value can be, you could create a variable :
=If IsNull() then -n Else {where -n is lower than any object value}.
You could apply a descending sort to this variable and use the alerter to set the -n value cells to the text value ‘NULL’ or blank then out :
Operator 1 Value 1 Result
Variable Name <= -n ‘NULL’
Please can you help me ?
I have two request synchronized. Of course, some lines appears with a NULL value. No problems at all.
But when i want to sort on the object which have null values. Lines
with
NULL values appears first in my rapport. I would prefer to have theese lines at the end.
Can’t you help me to prevent from this problem.