Suppresing Dilemma

[rekhatr10]

Hi Everyone,

SQL Server 2000
cr 7.0

I have developed a report where I am joining 2 tables on account->account using a left outer join. I am suppresing data in the detail section by using the create date < to the parmeter date (which the user enter). After this I have to display only the data which records are not in the 2nd table. How would I check if the records exists in the 2nd table and i can's use not equl as it returns garbage when I do use it. Any suggestion will be helpful.

Thank you in advance
Rekha

 

[tektipdjango]

in detail section in the section expert click on suppress X-2 and write
not isnull({table2.account})
(better select in the field list above to get the right table.fieldName)

--------------------------------------------------
[highlight]Django[/highlight]
bug exterminator
tips'n tricks addict​