Put the Null Group at the end

[musini]

Hi All,

I am stuck with a small problem. I am a grouping on a column which has null values in it. After I gorup on it the null value is first seen in the group header and then follows the other values in the column, but what I want is the column values first and at the last I need the null value.

This is what I get now.

Null group header
details
ABCD group header
details

what I want is

ABCD group header
details
Null
details.

Thanks,
M

 

[lbass]

Create a formula like this to group on:

if isnull({table.groupfield}) then "" else //or "Other"
" "+{table.groupfield}

Then insert your group on this. If the extra space is a problem because of alignment, then once you have inserted a group on this formula, in the group expert, choose "customize group name" and select {table.groupfield} (if you aren't showing "Other" for the null) or add the same formula as your grouping formula to the customize groupname->use a formula field, but omit the space before the groupfield. The group will be based on the original formula, but the display will reflect the customized name formula.

-LB

 

[musini]

Thanks LB. It worked and did not have any problem with the name of the group. I have one more problem now at the end of the report I get a blank page how to avoide it.

Thanks,
M

 

[lbass]

If you have new page after set on a group footer, add a conditional formula in the x+2 box that says:

not onlastrecord

Otherwise, make sure you have suppressed unused report footer sections, and make sure your section boundaries are nested against the bottom of objects in the section.

-LB

 

[musini]

Thanks, It worked.