ho to do sql replication having sql on diffrent ip addresse

can any body help is sql replication is possibel when we have sql
installed on
servers who have diffrent ip addresses.
here i have three sql servers two servers are are installed at
localley and one is at remote side. my remote side server is having
diffrent ip address when i try to register my remote side server to it
does not registers it gives
connection failed. can any body help me
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz.com/Replication-...ict249894.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=865268
If the server is on a non-trusted domain, try creating a client-alias to the
server (client network utility) and then register this servername.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
sql

Hiding Missing Information

I'm designing a report, where an address will be displayed. There's also line for a P.O. Box, but most of the addresses don't have one, so this line is empty most of the time.

Like:

Name
Street
POBox
City
Phone

If there's no POBox it looks like:

Name
Street

City
Phone

Is there any tqchnique, so that I can get rid of this blank line? And it would look like:

Name
Street
City
Phone

As far as I know, there are no report items, that can hande such a problem. Probably dynamically generating the XML would work, but that's a effort, I want to avoid.

I was just enquiring if you managed to resolve this issue?