Suppress Blank Lines

[velayudham]

I want to create a report for purchaseorder in the following format.

In Report tblPurchaseOrder, tblTerms two tables result should come.

I had create report using these two tables. I create group as purchaseorder No. wise. Each purchase order starts new page.
here what my problem is in my terms table

i have allowance, size, portdestination. suppose allowance field null means the label and the space should suppress
now i can suppress the label using suppress formula isNull{tblterms.allowance}. but the line doesn't go up. These details i put in the group footer

for example
Allowance :
Size :
portdestination :

if allowance field blank means the allowance label get suppress but the result shown is

[Blank space]
size :
Portdestination :

i also tried Format -> section in that i check the Remove blank space check box. but i failed. pl help me it is very urgent for me.


Regards
velayudham

[harmonycitra]

Hello Velayudam,

I went thru your problem in the forum. I have a same problem. Have you solved ur problem?

If it is, pls tell me how did you achieved it?

Thanks

[velayudham]

Yes. I solved the problem. Pl create different section for each field. And give suppress if blank the section in the format section menu. I think this wil solve you also.

Try it and give feedback.

Regards,
Velayudham :wave:

[harmonycitra]

Thanks,

But I'm displaying my fields in the same row. (in Group Footer). How can I create separate sections for each and every field?

[velayudham]

Sorry, I have also this problem. i am try to solve but i failed.

ok. when i find the solution immediately i will reply you.


bye.

regards,
velayudham

[ESHbyESH]

now i can suppress the label using suppress formula isNull{tblterms.allowance}. but the line doesn't go up.

if allowance field blank means the allowance label get suppress but the result shown is

[Blank space]
size :
Portdestination :



Here is the solution (this is a common problem that not many people seem to have solved):
Create a textbox. Set the textbox's "Suppress blank lines in embeded fields" property.
Instead of using database field tblterms.allowance and a label, create a formula that says:

If isNull{tblterms.allowance} then
""
else
"Allowance:" + Chr(9) + ToText({tblterms.allowance})

I placed a tab in this formula to space it out. Add tab stops (one left-aligned, one decimal) to your textbox, and drag the formula into it (embed) instead of the database field. Add the other fields to the textbox as well, separating fields by adding carriage returns. Bingo. The field and the line will disappear when there is no data.