Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Allow empty field in report 1

Status
Not open for further replies.

KeithSeeley

Technical User
Aug 12, 2003
10
US
New to BO...

I have two joined tables A & B where a matching entry in B may not exist. I want my report to show all of table A data along side of whatever data is in table B.

When I create a report and add the B fields the A results become restricted to only those with a matching B.

How do I return all of A along with whatever is in B?
 
You need outer joins to be defined in your universe.

Steve Krandel
VERITAS Software
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top