Mark,
In your simplified example, all you need to do is use a record selection
formula that says:
isnull({LaborDtl.JobNum})
This will give you only the records in the JobHead where the LaborDtl does
NOT have a corresponding record.
Troy Funte
-----Original Message-----
From: Mark Dupuis [mailto:dupuism@...]
Sent: Friday, June 06, 2003 10:17 AM
To: Vantage Users Group (E-mail)
Subject: [Vantage] crystal filter
Hello group,
It's been a while since I've had to bug you guys but I'm kind of
stuck on
this one. I have a rather complex report in crystal with 9 or 10 tables
and
4 sub reports so I'm going to use a simple example to explain my problem.
If you left outer join the JobHead and LaborDtl tables using the JobNum
field you get a data set. Some records in this set may or may not have
labor
details. I would like to use a filter to see only records that have no
labor details. Is there a way to use a filter to do this?
Mark Dupuis
Yahoo! Groups Sponsor
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]
In your simplified example, all you need to do is use a record selection
formula that says:
isnull({LaborDtl.JobNum})
This will give you only the records in the JobHead where the LaborDtl does
NOT have a corresponding record.
Troy Funte
-----Original Message-----
From: Mark Dupuis [mailto:dupuism@...]
Sent: Friday, June 06, 2003 10:17 AM
To: Vantage Users Group (E-mail)
Subject: [Vantage] crystal filter
Hello group,
It's been a while since I've had to bug you guys but I'm kind of
stuck on
this one. I have a rather complex report in crystal with 9 or 10 tables
and
4 sub reports so I'm going to use a simple example to explain my problem.
If you left outer join the JobHead and LaborDtl tables using the JobNum
field you get a data set. Some records in this set may or may not have
labor
details. I would like to use a filter to see only records that have no
labor details. Is there a way to use a filter to do this?
Mark Dupuis
Yahoo! Groups Sponsor
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]