grouping all blank rows with a blank column together

[jack91]

hi,

I have a particular column that has some blank values in some rows.

I want to group all the rows where a particular column has blank values and put them at the end of the report.

Please suggest a way to do this.

Thanks
Jk

 

[jack91]

*correction:

Topic header should read:
grouping all rows with a blank column together

 

[lbass]

Create a formula:

if isnull({table.column}) or
trim({table.column}) = "" then 1

Insert a group on this->ascending order.

-LB

 

[jack91]

strange: I did this but it does not seem to make a difference.

I inserted the formula as a group and made it ascending order
but i see no changes in the order.

Regards,
jk

 

[lbass]

It has to be your outermost group.

-LB

 

[jack91]

Thanks!!

Jk