Trying to build a baq for a crystal report

system · October 17, 2011, 1:12pm

True but he has a BAQ that he is using and it would not have an RDD.
Adding filters and options to the BAQ report would accomplish his goal.
He could also add filters to the dashboard and then use that data for a
Crystal Report.

Charlie Smith

2W Technologies LLC, Sr. Business Consultant

Phone: (312) 533-4033 x8046

(860) 620-9553

Fax: (847) 374-3620

2W Tech on Facebook
<http://www.facebook.com/pages/Chicago-IL/2W-Technologies-LLC/1391945694
32409> www.2WTech.com <http://www.2wtech.com/>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Sebastien
Sent: Monday, October 17, 2011 9:46 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Trying to build a baq for a crystal report

Hi Chalie,

You can add your filters in the report data definition.

Sebastien.-

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"jamesd" <jdaniel1127@...> wrote:

>
> Created a dashboard and it will pull in data that I want to Crystal

but, haven't found a way to put in reports filters that the user can
pick from. would like to have a begin/end date based on labor start date
and a selection for job number.

>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,

"CharlieSmith" <CSmith@> wrote:

> >
> > Get the JobOpr record at the first query. The Job/Asm/Seq numbers

are in

> > the LaborDtl record. Make sure it's an outer join if you are looking

for

> > the indirect labor as well.
> >
> >
> >
> > Charlie Smith
> >
> > 2W Technologies LLC, Sr. Business Consultant
> >
> >
> >
> > Phone: (312) 533-4033 x8046
> >
> > (860) 620-9553
> >
> > Fax: (847) 374-3620
> >
> > 2W Tech on Facebook
> > <

http://www.facebook.com/pages/Chicago-IL/2W-Technologies-LLC/1391945694

> > 32409> www.2WTech.com <http://www.2wtech.com/>
> >
> >
> >
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>

[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf

> > Of jamesd
> > Sent: Saturday, October 15, 2011 6:47 PM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Trying to build a baq for a crystal report
> >
> >
> >
> >
> >
> > Have 2 BAQ's I'm trying to use to get labor data and production data
> > for a production report but, can't join them to make one crystal

report.

> > ( need act/est prod, setup and scrap hours,job#,opr#,opr desc.,seq

#,

> > job complete,emp name,labor start date, labor qty, labor hrs).
> >
> >
> > Query 1-get labor detail
> > for each EmpBasic no-lock , each LaborHed where (LaborHed.company =
> > EmpBasic.company and LaborHed.EmployeeNum = EmpBasic.EmpID) no-lock

,

> > each LaborDtl where (LaborDtl.Company = LaborHed.Company and
> > LaborDtl.LaborHedSeq = LaborHed.LaborHedSeq) no-lock , each LabExpCd
> > outer-join where (LabExpCd.Company = LaborDtl.Company and
> > LabExpCd.ExpenseCode = LaborDtl.ExpenseCode) no-lock , each JCDept
> > outer-join where (JCDept.Company = LaborDtl.Company and

JCDept.JCDept =

> > LaborDtl.JCDept) no-lock .
> >
> > Query 2 - get job detail
> > for each JobOpDtl where ( JobOpDtl.JobNum <> '') no-lock , each

JobOper

> > where (JobOpDtl.Company = JobOper.Company and JobOpDtl.JobNum =
> > JobOper.JobNum and JobOpDtl.AssemblySeq = JobOper.AssemblySeq and
> > JobOpDtl.OprSeq = JobOper.OprSeq) no-lock .
> >
> > What am I missing or am I trying to do this wrong?
> >
> > Thanks,
> >
> > James
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>

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

system · October 15, 2011, 6:48pm

Have 2 BAQ's I'm trying to use to get labor data and production data
for a production report but, can't join them to make one crystal report.
( need act/est prod, setup and scrap hours,job#,opr#,opr desc.,seq #, job complete,emp name,labor start date, labor qty, labor hrs).

Query 1-get labor detail
for each EmpBasic no-lock , each LaborHed where (LaborHed.company = EmpBasic.company and LaborHed.EmployeeNum = EmpBasic.EmpID) no-lock , each LaborDtl where (LaborDtl.Company = LaborHed.Company and LaborDtl.LaborHedSeq = LaborHed.LaborHedSeq) no-lock , each LabExpCd outer-join where (LabExpCd.Company = LaborDtl.Company and LabExpCd.ExpenseCode = LaborDtl.ExpenseCode) no-lock , each JCDept outer-join where (JCDept.Company = LaborDtl.Company and JCDept.JCDept = LaborDtl.JCDept) no-lock .

Query 2 - get job detail
for each JobOpDtl where ( JobOpDtl.JobNum <> '') no-lock , each JobOper where (JobOpDtl.Company = JobOper.Company and JobOpDtl.JobNum = JobOper.JobNum and JobOpDtl.AssemblySeq = JobOper.AssemblySeq and JobOpDtl.OprSeq = JobOper.OprSeq) no-lock .

What am I missing or am I trying to do this wrong?

Thanks,

James

system · October 16, 2011, 1:38pm

I was trying to build a report from the BAQ's. Made them into a dashboard and found the create crystal in their and now it looks like I have all of the fields from both BAQ's.... too bad there isn't anything in the documentation I have telling you this...

--- In vantage@yahoogroups.com, "jamesd" <jdaniel1127@...> wrote:
>
> Have 2 BAQ's I'm trying to use to get labor data and production data
> for a production report but, can't join them to make one crystal report.
> ( need act/est prod, setup and scrap hours,job#,opr#,opr desc.,seq #, job complete,emp name,labor start date, labor qty, labor hrs).
>
>
> Query 1-get labor detail
> for each EmpBasic no-lock , each LaborHed where (LaborHed.company = EmpBasic.company and LaborHed.EmployeeNum = EmpBasic.EmpID) no-lock , each LaborDtl where (LaborDtl.Company = LaborHed.Company and LaborDtl.LaborHedSeq = LaborHed.LaborHedSeq) no-lock , each LabExpCd outer-join where (LabExpCd.Company = LaborDtl.Company and LabExpCd.ExpenseCode = LaborDtl.ExpenseCode) no-lock , each JCDept outer-join where (JCDept.Company = LaborDtl.Company and JCDept.JCDept = LaborDtl.JCDept) no-lock .
>
> Query 2 - get job detail
> for each JobOpDtl where ( JobOpDtl.JobNum <> '') no-lock , each JobOper where (JobOpDtl.Company = JobOper.Company and JobOpDtl.JobNum = JobOper.JobNum and JobOpDtl.AssemblySeq = JobOper.AssemblySeq and JobOpDtl.OprSeq = JobOper.OprSeq) no-lock .
>
> What am I missing or am I trying to do this wrong?
>
> Thanks,
>
> James
>

system · October 16, 2011, 7:09pm

Get the JobOpr record at the first query. The Job/Asm/Seq numbers are in
the LaborDtl record. Make sure it's an outer join if you are looking for
the indirect labor as well.

Charlie Smith

2W Technologies LLC, Sr. Business Consultant

Phone: (312) 533-4033 x8046

(860) 620-9553

Fax: (847) 374-3620

2W Tech on Facebook
<http://www.facebook.com/pages/Chicago-IL/2W-Technologies-LLC/1391945694
32409> www.2WTech.com <http://www.2wtech.com/>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of jamesd
Sent: Saturday, October 15, 2011 6:47 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Trying to build a baq for a crystal report

Have 2 BAQ's I'm trying to use to get labor data and production data
for a production report but, can't join them to make one crystal report.
( need act/est prod, setup and scrap hours,job#,opr#,opr desc.,seq #,
job complete,emp name,labor start date, labor qty, labor hrs).

Query 1-get labor detail
for each EmpBasic no-lock , each LaborHed where (LaborHed.company =
EmpBasic.company and LaborHed.EmployeeNum = EmpBasic.EmpID) no-lock ,
each LaborDtl where (LaborDtl.Company = LaborHed.Company and
LaborDtl.LaborHedSeq = LaborHed.LaborHedSeq) no-lock , each LabExpCd
outer-join where (LabExpCd.Company = LaborDtl.Company and
LabExpCd.ExpenseCode = LaborDtl.ExpenseCode) no-lock , each JCDept
outer-join where (JCDept.Company = LaborDtl.Company and JCDept.JCDept =
LaborDtl.JCDept) no-lock .

Query 2 - get job detail
for each JobOpDtl where ( JobOpDtl.JobNum <> '') no-lock , each JobOper
where (JobOpDtl.Company = JobOper.Company and JobOpDtl.JobNum =
JobOper.JobNum and JobOpDtl.AssemblySeq = JobOper.AssemblySeq and
JobOpDtl.OprSeq = JobOper.OprSeq) no-lock .

What am I missing or am I trying to do this wrong?

Thanks,

James

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

system · October 16, 2011, 7:16pm

Created a dashboard and it will pull in data that I want to Crystal but, haven't found a way to put in reports filters that the user can pick from. would like to have a begin/end date based on labor start date and a selection for job number.

--- In vantage@yahoogroups.com, "CharlieSmith" <CSmith@...> wrote:
>
> Get the JobOpr record at the first query. The Job/Asm/Seq numbers are in
> the LaborDtl record. Make sure it's an outer join if you are looking for
> the indirect labor as well.
>
>
>
> Charlie Smith
>
> 2W Technologies LLC, Sr. Business Consultant
>
>
>
> Phone: (312) 533-4033 x8046
>
> (860) 620-9553
>
> Fax: (847) 374-3620
>
> 2W Tech on Facebook
> <http://www.facebook.com/pages/Chicago-IL/2W-Technologies-LLC/1391945694
> 32409> www.2WTech.com <http://www.2wtech.com/>
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of jamesd
> Sent: Saturday, October 15, 2011 6:47 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Trying to build a baq for a crystal report
>
>
>
>
>
> Have 2 BAQ's I'm trying to use to get labor data and production data
> for a production report but, can't join them to make one crystal report.
> ( need act/est prod, setup and scrap hours,job#,opr#,opr desc.,seq #,
> job complete,emp name,labor start date, labor qty, labor hrs).
>
>
> Query 1-get labor detail
> for each EmpBasic no-lock , each LaborHed where (LaborHed.company =
> EmpBasic.company and LaborHed.EmployeeNum = EmpBasic.EmpID) no-lock ,
> each LaborDtl where (LaborDtl.Company = LaborHed.Company and
> LaborDtl.LaborHedSeq = LaborHed.LaborHedSeq) no-lock , each LabExpCd
> outer-join where (LabExpCd.Company = LaborDtl.Company and
> LabExpCd.ExpenseCode = LaborDtl.ExpenseCode) no-lock , each JCDept
> outer-join where (JCDept.Company = LaborDtl.Company and JCDept.JCDept =
> LaborDtl.JCDept) no-lock .
>
> Query 2 - get job detail
> for each JobOpDtl where ( JobOpDtl.JobNum <> '') no-lock , each JobOper
> where (JobOpDtl.Company = JobOper.Company and JobOpDtl.JobNum =
> JobOper.JobNum and JobOpDtl.AssemblySeq = JobOper.AssemblySeq and
> JobOpDtl.OprSeq = JobOper.OprSeq) no-lock .
>
> What am I missing or am I trying to do this wrong?
>
> Thanks,
>
> James
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

system · October 16, 2011, 11:45pm

BAQ report

Charlie Smith

2W Technologies LLC, Sr. Business Consultant

Phone: (312) 533-4033 x8046

(860) 620-9553

Fax: (847) 374-3620

2W Tech on Facebook
<http://www.facebook.com/pages/Chicago-IL/2W-Technologies-LLC/1391945694
32409> www.2WTech.com <http://www.2wtech.com/>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of jamesd
Sent: Sunday, October 16, 2011 7:17 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Trying to build a baq for a crystal report

Created a dashboard and it will pull in data that I want to Crystal but,
haven't found a way to put in reports filters that the user can pick
from. would like to have a begin/end date based on labor start date and
a selection for job number.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"CharlieSmith" <CSmith@...> wrote:

>
> Get the JobOpr record at the first query. The Job/Asm/Seq numbers are

in

> the LaborDtl record. Make sure it's an outer join if you are looking

for

> the indirect labor as well.
>
>
>
> Charlie Smith
>
> 2W Technologies LLC, Sr. Business Consultant
>
>
>
> Phone: (312) 533-4033 x8046
>
> (860) 620-9553
>
> Fax: (847) 374-3620
>
> 2W Tech on Facebook
> <

http://www.facebook.com/pages/Chicago-IL/2W-Technologies-LLC/1391945694

> 32409> www.2WTech.com <http://www.2wtech.com/>
>
>
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>

[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf

> Of jamesd
> Sent: Saturday, October 15, 2011 6:47 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Trying to build a baq for a crystal report
>
>
>
>
>
> Have 2 BAQ's I'm trying to use to get labor data and production data
> for a production report but, can't join them to make one crystal

report.

> ( need act/est prod, setup and scrap hours,job#,opr#,opr desc.,seq #,
> job complete,emp name,labor start date, labor qty, labor hrs).
>
>
> Query 1-get labor detail
> for each EmpBasic no-lock , each LaborHed where (LaborHed.company =
> EmpBasic.company and LaborHed.EmployeeNum = EmpBasic.EmpID) no-lock ,
> each LaborDtl where (LaborDtl.Company = LaborHed.Company and
> LaborDtl.LaborHedSeq = LaborHed.LaborHedSeq) no-lock , each LabExpCd
> outer-join where (LabExpCd.Company = LaborDtl.Company and
> LabExpCd.ExpenseCode = LaborDtl.ExpenseCode) no-lock , each JCDept
> outer-join where (JCDept.Company = LaborDtl.Company and JCDept.JCDept

=

> LaborDtl.JCDept) no-lock .
>
> Query 2 - get job detail
> for each JobOpDtl where ( JobOpDtl.JobNum <> '') no-lock , each

JobOper

> where (JobOpDtl.Company = JobOper.Company and JobOpDtl.JobNum =
> JobOper.JobNum and JobOpDtl.AssemblySeq = JobOper.AssemblySeq and
> JobOpDtl.OprSeq = JobOper.OprSeq) no-lock .
>
> What am I missing or am I trying to do this wrong?
>
> Thanks,
>
> James
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

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

system · October 17, 2011, 9:45am

Hi Chalie,

You can add your filters in the report data definition.

Sebastien.-

--- In vantage@yahoogroups.com, "jamesd" <jdaniel1127@...> wrote:
>
> Created a dashboard and it will pull in data that I want to Crystal but, haven't found a way to put in reports filters that the user can pick from. would like to have a begin/end date based on labor start date and a selection for job number.
>
> --- In vantage@yahoogroups.com, "CharlieSmith" <CSmith@> wrote:
> >
> > Get the JobOpr record at the first query. The Job/Asm/Seq numbers are in
> > the LaborDtl record. Make sure it's an outer join if you are looking for
> > the indirect labor as well.
> >
> >
> >
> > Charlie Smith
> >
> > 2W Technologies LLC, Sr. Business Consultant
> >
> >
> >
> > Phone: (312) 533-4033 x8046
> >
> > (860) 620-9553
> >
> > Fax: (847) 374-3620
> >
> > 2W Tech on Facebook
> > <http://www.facebook.com/pages/Chicago-IL/2W-Technologies-LLC/1391945694
> > 32409> www.2WTech.com <http://www.2wtech.com/>
> >
> >
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> > Of jamesd
> > Sent: Saturday, October 15, 2011 6:47 PM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Trying to build a baq for a crystal report
> >
> >
> >
> >
> >
> > Have 2 BAQ's I'm trying to use to get labor data and production data
> > for a production report but, can't join them to make one crystal report.
> > ( need act/est prod, setup and scrap hours,job#,opr#,opr desc.,seq #,
> > job complete,emp name,labor start date, labor qty, labor hrs).
> >
> >
> > Query 1-get labor detail
> > for each EmpBasic no-lock , each LaborHed where (LaborHed.company =
> > EmpBasic.company and LaborHed.EmployeeNum = EmpBasic.EmpID) no-lock ,
> > each LaborDtl where (LaborDtl.Company = LaborHed.Company and
> > LaborDtl.LaborHedSeq = LaborHed.LaborHedSeq) no-lock , each LabExpCd
> > outer-join where (LabExpCd.Company = LaborDtl.Company and
> > LabExpCd.ExpenseCode = LaborDtl.ExpenseCode) no-lock , each JCDept
> > outer-join where (JCDept.Company = LaborDtl.Company and JCDept.JCDept =
> > LaborDtl.JCDept) no-lock .
> >
> > Query 2 - get job detail
> > for each JobOpDtl where ( JobOpDtl.JobNum <> '') no-lock , each JobOper
> > where (JobOpDtl.Company = JobOper.Company and JobOpDtl.JobNum =
> > JobOper.JobNum and JobOpDtl.AssemblySeq = JobOper.AssemblySeq and
> > JobOpDtl.OprSeq = JobOper.OprSeq) no-lock .
> >
> > What am I missing or am I trying to do this wrong?
> >
> > Thanks,
> >
> > James
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>

Topic		Replies	Views
BAQ Report Query Question Yahoo Archive	5	345	February 4, 2009
Report help Yahoo Archive	9	718	June 30, 2005
non-BAQ subreport in BAQ report Yahoo Archive	7	719	August 12, 2009
Unable to create a BAQ/Crystal Report successfully using the tab Yahoo Archive	4	355	March 23, 2009
Report problem Blank Title 51468 Yahoo Archive	4	264	August 22, 2006

Trying to build a baq for a crystal report

Related Topics