on 09-01-2014 2:44 PM
Hi Experts,
I am using 2 tables "PROBSUMMARYM1" and "SYSATTACHMEM1" in my report.
Link is between these two fields {PROBSUMMARYM1.NUMBER}--->{SYSATTACHMEM1.TOPIC}
Table "PROBSUMMARYM1" is having 100 records and table "SYSATTACHMEM1" is having only 20 records that is also present in "PROBSUMMARYM1". In my report am getting only 20 records that are present in table "SYSATTACHMEM1".
What i should i do to get the record that are not present in table "SYSATTACHMEM1".
Thanks in advance.
Hi Ajay,
Also go in Link tab-- double lick on join and go in LInk Type and select != (not equal to).
-Sastry
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ajay,
Go to the Database Expert > Click the Link arrow > Change the Join type to 'Left Outer'.
Then, go to Report > Selection Formulas > Record and use this code:
{SYSATTACHMEM1} = 0 OR IsNull({SYSATTACHMEM1})
-Abhilash
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.