|
-
August 9th, 2011, 06:06 AM
#1
Exclusion linking
First post so please be gentle!
I'm using Crystal 8.5 and I have two simple tables, one is a complete list of stock-codes, the other a list of stock-codes that I'd like to exclude from the end report. I'm guessing it's all about the linking or maybe it's easier to do with a formula, but I've read through the help and scoured the internet but still my results don't make sense - can anybody point me in the right direction please?
Many thanks.
-
August 9th, 2011, 10:40 AM
#2
Re: Exclusion linking
Welcome to CodeGuru forums !
Never tested myself, but try the next :
Let's say we have Table1.StockCode and Table2.StockCode
Add to the report
Link each other using StockCode
Create a RecordSelection Formula as :
Code:
IsNull({Table2.StockCode}) = True
What we're doing is filtering the rows where the link was successful (when {Table2.StockCode} is not null)
JG
-
August 11th, 2011, 02:49 AM
#3
Re: Exclusion linking
That's done it - thank you for your help!
-
August 11th, 2011, 09:55 AM
#4
Re: Exclusion linking
JG
... If your problem is fixed don't forget to mark your threads as resolved  using the Thread Tools menu ...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote