I am doing a report and have come up with the following problem.

 

If you use the criteria to select one record then all the details are displayed correctly. If you select the criteria for more than one record then the records are selected but the record is not displayed on the screen unless I increase the detail section in size.

 

Displayed for 1 record

1 High Street

 

Displayed for more than 1 record (I have to increase  detail section to display)

1 high Street

 

The problem seems to be if there is no {@address2}.

 

An example is as follows, basically the report can display 2 addresses. These addresses are in one formula field. In the formula field, called @Addresses I have the following formula.

 

 

Local NumberVar nOtherAddress := len({@Address2})

 

….some if statement but where I have the problem is here

{@Address1} +

iif(nOtherAddress > 0, {@Address2} , “”,

 

 

I have tried trim etc but no luck. In the format field of @Addresses, the following is ticked

Can grow, keep object together, close border on page break. Apart from that nothing else is changed.

 

There must be something I have missed out or doing wrong. Basically I am stumped????

just to be clear, the @Addresses formula file is always returning the correct results but is is not growing (height of text box expanding) when there is a line return in it?

Edited by DBlank - 07 Mar 2014 at 4:15am

Are these two addresses from the same table?

what exactly is the code for each of the @Address1 and @Address2 formulas?

perhaps I'm confused.

Sounds like there are embedded carriage returns, though one would think that Can Grow would take care of that.

What does this do?
local numbervar nOtherAddress := @Address2

@Address1 + iif(nOtherAddress > 0, @Address2, "")

if @address2 is a street address, does it convert to a numeric. VB was odd that way, and I guess it would...

I'm with DBlank in wanting to see the logic of code.