Grouping by <NULL>s

[CrystaLv]

Hi,
another issue I am stuck with.
I have some order numbers that are <NULL> but I need to group by Order Number. <NULL>s won't show up. What to do?


Thanks. I am using CR9.

 

[lbass]

Decide what you want displayed, and then create a formula:

if isnull({table.ordernumber}) then "No Order Number" else
totext({table.ordernumber},0,"")

This assumes that order number is a number. If it is a string, then remove the totext().

-LB

 

[CrystaLv]

I am getting error 'too many arguments been given to this function' in place totext({table.ordernumber},0,"")
reffering to 0,

 

[lbass]

That means it probably is already a string. Remove the totext(,0,""). You can tell the datatype by letting your mouse move over the field and observing the tool tip.

-LB

 

[CrystaLv]

It WAS a string...I am out of my mind.
So let say I had created fromula and grouped by formula instead of the order number? It doesn't do anything different somehow.

 

[rosemaryl]

Dear Crystallv,

If you group by a string that contains nulls then all the nulls are grouped together with a blank "null" groupname.

Whenever I group on a field, I always do Group Name customization (options tab) and insert a formula like the one LB provided you:

If isnull({Table.Field})
then 'Some Text Regarding It is Null'
else {Table.Field}

By doing so, you ensure that anyone reading the report sees the value is labeled as Null or whatever text you want. It makes for a more readable report.

regards,

ro

Rosemary Lieberman
rosemary-at-microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

You will get answers more quickly if you read this before posting: faq149-3762