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 Chriss Miller 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
Joined
Aug 12, 2003
Messages
10
Location
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
 
Thanks skrandel, worked great.

Have a great day!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top