blank lines in report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm using the following expression in one field and have the Can Shrink
property set to yes, however I'm still getting blank lines if one or more of
the expressions is null. I'm using the expression in a memo field, is that
the problem?

=([RESOLUTION NOTES]) & Chr(13) & Chr(10) & IIf([REPAIR ORDER
SUBMITTED]=True,"REPAIR ORDER SUBMITTED.") & Chr(13) & Chr(10) & IIf([ars tag
ORDERED]=True,"ARS TAG ISSUED.") & Chr(13) & Chr(10) & IIf([CREDIT MEMO
SUBMITTED]=True,"CREDIT MEMO SUBMITTED" & " " & [DATE CREDIT SUBMITTED]) &
Chr(13) & Chr(10) & IIf([DEBIT/CREDIT MEMO SUBMITTED]=True,"DEBIT MEMO
SUBMITTED" & " " & [DATE CREDIT SUBMITTED])

Thank you,
 
You need to move the Chr(13) & Chr(10) inside the IIF statements.


=([RESOLUTION NOTES]) & Chr(13) & Chr(10) &
IIf([REPAIR ORDER SUBMITTED]=True,"REPAIR ORDER SUBMITTED." & Chr(13) & Chr(10))
&
IIf([ars tag ORDERED]=True,"ARS TAG ISSUED." & Chr(13) & Chr(10)) &
IIf([CREDIT MEMO SUBMITTED]=True,"CREDIT MEMO SUBMITTED" & " " & [DATE CREDIT
SUBMITTED] & Chr(13) & Chr(10)) &
IIf([DEBIT/CREDIT MEMO SUBMITTED]=True,"DEBIT MEMO SUBMITTED" & " " & [DATE
CREDIT SUBMITTED])
 
Thank you, the expression is working now with the exception of the first
field [Resolution Notes]. If the field is null, it leaves a blank line.
I've tried creating an IIF is null expression, but keep getting errors.

John Spencer (MVP) said:
You need to move the Chr(13) & Chr(10) inside the IIF statements.


=([RESOLUTION NOTES]) & Chr(13) & Chr(10) &
IIf([REPAIR ORDER SUBMITTED]=True,"REPAIR ORDER SUBMITTED." & Chr(13) & Chr(10))
&
IIf([ars tag ORDERED]=True,"ARS TAG ISSUED." & Chr(13) & Chr(10)) &
IIf([CREDIT MEMO SUBMITTED]=True,"CREDIT MEMO SUBMITTED" & " " & [DATE CREDIT
SUBMITTED] & Chr(13) & Chr(10)) &
IIf([DEBIT/CREDIT MEMO SUBMITTED]=True,"DEBIT MEMO SUBMITTED" & " " & [DATE
CREDIT SUBMITTED])
I'm using the following expression in one field and have the Can Shrink
property set to yes, however I'm still getting blank lines if one or more of
the expressions is null. I'm using the expression in a memo field, is that
the problem?

=([RESOLUTION NOTES]) & Chr(13) & Chr(10) & IIf([REPAIR ORDER
SUBMITTED]=True,"REPAIR ORDER SUBMITTED.") & Chr(13) & Chr(10) & IIf([ars tag
ORDERED]=True,"ARS TAG ISSUED.") & Chr(13) & Chr(10) & IIf([CREDIT MEMO
SUBMITTED]=True,"CREDIT MEMO SUBMITTED" & " " & [DATE CREDIT SUBMITTED]) &
Chr(13) & Chr(10) & IIf([DEBIT/CREDIT MEMO SUBMITTED]=True,"DEBIT MEMO
SUBMITTED" & " " & [DATE CREDIT SUBMITTED])

Thank you,
Click to expand...
Click to expand...
 
IIF([Resolution notes] is null, Null,[Resolution Notes] & Chr(13) & Chr(10)) & ...
Thank you, the expression is working now with the exception of the first
field [Resolution Notes]. If the field is null, it leaves a blank line.
I've tried creating an IIF is null expression, but keep getting errors.

John Spencer (MVP) said:
You need to move the Chr(13) & Chr(10) inside the IIF statements.


=([RESOLUTION NOTES]) & Chr(13) & Chr(10) &
IIf([REPAIR ORDER SUBMITTED]=True,"REPAIR ORDER SUBMITTED." & Chr(13) & Chr(10))
&
IIf([ars tag ORDERED]=True,"ARS TAG ISSUED." & Chr(13) & Chr(10)) &
IIf([CREDIT MEMO SUBMITTED]=True,"CREDIT MEMO SUBMITTED" & " " & [DATE CREDIT
SUBMITTED] & Chr(13) & Chr(10)) &
IIf([DEBIT/CREDIT MEMO SUBMITTED]=True,"DEBIT MEMO SUBMITTED" & " " & [DATE
CREDIT SUBMITTED])
I'm using the following expression in one field and have the Can Shrink
property set to yes, however I'm still getting blank lines if one or more of
the expressions is null. I'm using the expression in a memo field, is that
the problem?

=([RESOLUTION NOTES]) & Chr(13) & Chr(10) & IIf([REPAIR ORDER
SUBMITTED]=True,"REPAIR ORDER SUBMITTED.") & Chr(13) & Chr(10) & IIf([ars tag
ORDERED]=True,"ARS TAG ISSUED.") & Chr(13) & Chr(10) & IIf([CREDIT MEMO
SUBMITTED]=True,"CREDIT MEMO SUBMITTED" & " " & [DATE CREDIT SUBMITTED]) &
Chr(13) & Chr(10) & IIf([DEBIT/CREDIT MEMO SUBMITTED]=True,"DEBIT MEMO
SUBMITTED" & " " & [DATE CREDIT SUBMITTED])

Thank you,
Click to expand...
Click to expand...
Click to expand...
 
Back
Top