I am using Crystal Reports XI and have Table A linked to Table B using a left outer join. Table A contains the name of an asset record and Table B contains the names of people assigned to that asset record. For example:
Asset Record Contact
=========== =======
CI-0000000001 John Smith
Mary Jane
It may be that there is no contact in Table B or one or many contacts in Table B. For some reason, my report output is showing up like this:
Asset Record Contact
=========== =======
CI-0000000001
CI-0000000001 John Smith
CI-0000000001 Mary Jane
I would like to remove the blank field - I don't know why that is show up.
Start Free Trial