Have a report sorted into two groups. Field A is in group A and Field B is in group B right below. There is not always a value in Field A but always B. The issue is if Field A is blank it creates a blank line so the report has spaces between the lines. For example:

 

This is Field A Line

           This is Field B 1st Line

 

           This is Field B 2nd Line

 

           This is Field B 3rd Line (and so on)

 

I want to eliminate the spaces between these Field B lines but can't seem to do so. Field A is obviously blank hence the gaps.

 

So in a perfect world the resulting layout should look like this:

 

This is Field A Line

          This is Field B 1st Line

          This is Field B 2nd Line

          This is Field B 3rd Line

 

No gaps.

 

Any suggestions?

 

Thanks in advance for any postings.

 

 

if isnull({field}) then TRUE