report formating

  • Thread starter Thread starter dave
  • Start date Start date
D

dave

hello
i m designing report with fields name, addressline1,addressline2,
suburb,state..

i want output sth like this

Mr. peter addressline1
addressline2
suburb,state

Mr.craig addressline1
addressline2
suburbu,state

Only the problem is i dont put blank line if some contact doesnt have
addressline2..
for example if mr. peter doesnt have addressline2 then out put should be

Mr. peter addressline1
suburb,state

Mr.craig addressline1
addressline2
suburbu,state

Is it possible...
Any help would be appreciated...
Thanx
 
in report design view, set the "addressline2" control's CanShrink property
to Yes. also, set the CanShrink property to Yes for the report *section*
that the control is in.

hth
 
I tried...
I have 'detail' section in report...
In the detail section fields are align sth like this...

[Name] [Addressline1]
[Addressline2]
[Suburb][State]

I set the CanShrink & CanGrow property to yes and also CanShrink property to
yes of detail section..
But still its not working...and putting blank line if Addressline2 is Null.

Thanx
 
if there is one or more other controls on either side of [Addressline2] that
stretch vertically into that area, that will prevent the space from
shrinking. (hard to explain, sorry i can't do screen prints for you to
illustrate.) here's two examples:

[Name] [Addressline1]
[Addressline2] [AnotherControl]
[Suburb][State]

and

[Name] [Addressline1] [AnotherControl
[Addressline2] StretchesIntoArea]
[Suburb][State]

first, try setting the CanShrink property of *all* controls in the Detail
section to Yes. if that doesn't work, you'll need to adjust the
placement/sizing of controls adjacent to [Addressline2] to allow the space
to shrink.

hth


dave said:
I tried...
I have 'detail' section in report...
In the detail section fields are align sth like this...

[Name] [Addressline1]
[Addressline2]
[Suburb][State]

I set the CanShrink & CanGrow property to yes and also CanShrink property to
yes of detail section..
But still its not working...and putting blank line if Addressline2 is Null.

Thanx

tina said:
in report design view, set the "addressline2" control's CanShrink property
to Yes. also, set the CanShrink property to Yes for the report *section*
that the control is in.

hth
Click to expand...
Click to expand...
 
Back
Top