ignore customers without state entered

[bryan3473]

Hi all i created a report that groups by state the only problem im having is that its reeturning the records with no state in them too. How do i tell it to ignore the customers with no state entered in it when i do the grouping.

 

[lbass]

If you mean you don't want those customers in the report, then use a record selection formula of:

not isnull({table.state}) or
trim({table.state}) <> ""

-LB

 

[bryan3473]

thanks for responding it tells me the formula result must be a string and puthe the cursor in front of the word not. Im using version 8.5 if that helps

 

[lbass]

I assumed that {table.state} was a string--correct? Can't see any reason why you would get that message. Did you place it in report->selection formula->RECORD?

-LB

 

[bryan3473]

Well actually the state does not a have a place anywhere in the report. I created a grouping off the state field in one of the data sets, but didnt stick state in the report anywhere just let the grouping insert the state abreveation before each group. So my first group has no abreveation just a blank spot and then all the customer names.

???
customer 1
AL
customer 2

kinda like that.

 

[Barock21]

I would do:

{table.state} > '0'

 

[lbass]

What is it that you want to do? Do you want to eliminate customers with no states or do you want a name for the customer group with no state, e.g., "No Specified State"?

What is your grouping formula? Please show the contents.

-LB