BAQ showing Parent Records without Child Records

To create this BAQ (in 9.05):

- Add tables LaborHed and LaborDtl and change the table
relation between them to an outer join.

- Add other table criteria, probably LaborHed.ActiveTrans =
true.

- Change the LaborDtl table to a summary table only.

- Add a display calculated column with a formula of Count(
LaborDtl.EmployeeNum ).

- This query shows who's clocked in, and how many
jobs/activities they are clocked into.

- Add a display "filter results" of that calculated column = 0.

- Now this shows only people with zero active jobs.



Brian.



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of mike.numbers
Sent: Wednesday, February 29, 2012 10:35 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ showing Parent Records without Child Records





I am trying to create a BAQ using LaborHed and LaborDtl that shows who
has clocked in but has not identified a job or Indirect. Looking at the
data, I have a LaborHed record but no corresponding LaborDtl record. How
can I write a BAQ that will show me all LaborHed records that do not
have a LaborDtl record?





[Non-text portions of this message have been removed]
I am trying to create a BAQ using LaborHed and LaborDtl that shows who has clocked in but has not identified a job or Indirect. Looking at the data, I have a LaborHed record but no corresponding LaborDtl record. How can I write a BAQ that will show me all LaborHed records that do not have a LaborDtl record?
Mike,

Create a BAQ and in Phrase Builder add tables LaborHed and LaborDtl.

Check the box “Summarize” for LaborDtl. Click NEXT and the wizard will properly join the two tables. Check the box for Table Relations that says OUTER JOIN. Hit Next, Next and Finish the Phrase Builder.

Display fields LaborHed.EmployeeNum, LH.PayrollDate

Create a Calc field. Call it “LDCOUNT”. The formula: COUNT(LaborDtl.LaborDtlSeq) and the data type for the Calc field make Integer.

Run it. When LDCOUNT = 0...... you have no records for that LH record in LD.

From: mike.numbers
Sent: Wednesday, February 29, 2012 10:34 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ showing Parent Records without Child Records


I am trying to create a BAQ using LaborHed and LaborDtl that shows who has clocked in but has not identified a job or Indirect. Looking at the data, I have a LaborHed record but no corresponding LaborDtl record. How can I write a BAQ that will show me all LaborHed records that do not have a LaborDtl record?




No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.1913 / Virus Database: 2114/4840 - Release Date: 02/28/12


[Non-text portions of this message have been removed]
Vic,



Thanks that worked. We are on 9.04.507a and I could not find the “Summarize” box, but my results looked good.



I only played with this problem for 2 days before I asked for help.



Thanks again.



Mike



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Vic Drecchio
Sent: Wednesday, February 29, 2012 10:55 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] BAQ showing Parent Records without Child Records





Mike,

Create a BAQ and in Phrase Builder add tables LaborHed and LaborDtl.

Check the box “Summarize” for LaborDtl. Click NEXT and the wizard will properly join the two tables. Check the box for Table Relations that says OUTER JOIN. Hit Next, Next and Finish the Phrase Builder.

Display fields LaborHed.EmployeeNum, LH.PayrollDate

Create a Calc field. Call it “LDCOUNT”. The formula: COUNT(LaborDtl.LaborDtlSeq) and the data type for the Calc field make Integer.

Run it. When LDCOUNT = 0...... you have no records for that LH record in LD.

From: mike.numbers
Sent: Wednesday, February 29, 2012 10:34 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] BAQ showing Parent Records without Child Records

I am trying to create a BAQ using LaborHed and LaborDtl that shows who has clocked in but has not identified a job or Indirect. Looking at the data, I have a LaborHed record but no corresponding LaborDtl record. How can I write a BAQ that will show me all LaborHed records that do not have a LaborDtl record?

No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.1913 / Virus Database: 2114/4840 - Release Date: 02/28/12

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]