DATA BASE FIELD LINKS

[Kim296]

If anyone can help with this problem, it is very appreciated.

I am using 2 tables in my report:

nmmain (the master name table)
syinvl (system involvements)


I have all of the nmmain fields in the header; this is the most current information (name, address, phone, etc..)

Then I have the system involvements in the details field (there could be multiple responses: old addresses, old phone numbers, etc...)

The problem that I have is that if there are no system involvements then it doesn't return anything for my query; even when I know there is header information with no involvments.

I've tried linking the tables with a left outer link, right outer link and full outer link, so that my query will return the header information regardless of any system involvements. Nothing I've tried has worked. This report will only return the queried information if there IS system involvements.

Can anyone tell me how to fix this problem, so that it returns all queries regardless of involvements?

 

[hilfy]

There are a couple of things you need to do:

1. Link FROM nmmain TO syinvl and make this a left outer join.

2. If you have ANY references to syinvl in the Select Expert (to filter the data), you'll need to do something like this:

( IsNull({syinvl.KeyField}) or <syinvl filter> )

Note the outer parentheses - this is crucial to getting the filter to work correctly!

This will take care of the situation where there is no corresponding data in the syinvl table.

-Dell

DecisionFirst Technologies - Seven-time SAP BusinessObjects Solution Partner of the Year

http://www.decisionfirst.com

 

[Kim296]

Thank you very much for responding Dell. I was able to get this report working and I appreciate your help.

Have a great day!!