Address block in Base report

users
#1

Windows XP, SP3
LO 4.0.5.2

We have created a Base database from Access 2003. One of the reports, based
on a query, is to print labels. The first line is for the name, second line
is for the company name, third line is for the street address or PO Box, and
the last line is for the city, state and zip code. We would like the PO Box
to show on the third line if there is no given address. Using the Function
Wizard, we have tried the following: "IF([STREETNO]&"
"&[STREET]ISBLANK;[POBOX];[STREETNO]&" " [STREET]") - this doesn't show any
information. We tried to reverse it "IF([POBOX]ISBLANK;[STREETNO]&"
"&[STREET];[POBOX]) - no data appears. We have tried to use " " instead of
ISBLANK, same thing, no data.

Any ideas?

#2

Windows XP, SP3
LO 4.0.5.2

We have created a Base database from Access 2003. One of the reports, based
on a query, is to print labels. The first line is for the name, second line
is for the company name, third line is for the street address or PO Box, and
the last line is for the city, state and zip code. We would like the PO Box
to show on the third line if there is no given address. Using the Function
Wizard, we have tried the following: "IF([STREETNO]&"
"&[STREET]ISBLANK;[POBOX];[STREETNO]&" " [STREET]") - this doesn't show any
information. We tried to reverse it "IF([POBOX]ISBLANK;[STREETNO]&"
"&[STREET];[POBOX]) - no data appears. We have tried to use " " instead of
ISBLANK, same thing, no data.

Any ideas?

Karen,

Without the function does the query return the correct information?

A typical SQL query would look like this:

SELECT person, company, address1, address2, city, state, zip (use your column names)
FROM contacts (use your table name(s))

Also, does the form/report return a label that is correct without the function?
I have found sometimes trying the minimalist approach first yields the results I wanted.

#3

Yes, the report will return a label showing the address or PO box on two separate lines. However, we would like the PO box to show where the address line would normally be. Seems like a function should work for this. If address line available, print, if not, print PO box.

#4

Hi Karen,

Yes, the report will return a label showing the address or PO box on two separate lines. However, we would like the PO box to show where the address line would normally be. Seems like a function should work for this. If address line available, print, if not, print PO box.

From memory, you have to insert a hidden paragraph marker into your

report document that will triger when XYZ condition is met, e.g. one of
the following :

!Database.Table.FieldName

NOT Database.Table.FieldName

Database.Table.FieldName EQ ""

Database.Table.FieldName ==""

This should work for a normal Writer document, however, I have no idea
whether you can actually do this in a report builder report document.

Alex

#5

Hi again,

We have created a Base database from Access 2003. One of the reports, based
on a query, is to print labels. The first line is for the name, second line

Thinking about it, you would probably be better off using a label
template and then using mailmerge using the query as a datasource to
achieve what you want to to. You could then use the hidden paragraph
function in your label template.

Alex

#6

Thanks Alex. That sounds like a good option.

Hi again,

We have created a Base database from Access 2003. One of the

reports, based

on a query, is to print labels. The first line is for the name,

second line

Thinking about it, you would probably be better off using a label
template and then using mailmerge using the query as a datasource to
achieve what you want to to. You could then use the hidden paragraph
function in your label template.

Alex