Knowing the quantity available at an Operation

Yahoo Archive
1
does anyone have an example of any options that I mentioned? I am not
sure about the code and how I would go about doing it.

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of dgodfrey_amc
Sent: Wednesday, September 02, 2009 9:20 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Knowing the quantity available at an Operation




I need to create a report that has a field that knows the qty of
manufactured parts at an operation.
For example: If a job has a production quantity of 10 and the first
op(5) completes 3, then the next op(10) has a production quantity of 10
but available quantity of 3.
What I have looked into:
1) BAQ: My problem is that I think I need to create a sql select
statement to find the previous Job operation's quantity competed field.
I can't figure out how to do this.
2) Dashboards: inherits BAQ problem
3) BAQ Reports: I think I need a second dataset to be able to compare
current operation number to the previous operation number.
4) Dashbaord Reports: This allows me to bring in multiple datasets. I
could not bring in the smae BAQ do to Vantage limitation, so I copied
the BAQ and added _02 to the end of it. Now I can bring in the same
dataset twice.
Problem: I do not know how to create a sql select statement inside of a
formula field in crystal reports.
5) BPM: I have not looked into this yet, but my thought is to run a
query on the LaborDtl.Update that would update a user field on the
JobOper table with the entered quantity. The value would be entered on
the NEXT operation's record. Then I could run a simple BAQ report.

Does anyone have any suggestion? Am I off course, is there a better or
easier way to do this? Please help.

Dan






[Non-text portions of this message have been removed]
2
I need to create a report that has a field that knows the qty of manufactured parts at an operation.
For example: If a job has a production quantity of 10 and the first op(5) completes 3, then the next op(10) has a production quantity of 10 but available quantity of 3.
What I have looked into:
1) BAQ: My problem is that I think I need to create a sql select statement to find the previous Job operation's quantity competed field. I can't figure out how to do this.
2) Dashboards: inherits BAQ problem
3) BAQ Reports: I think I need a second dataset to be able to compare current operation number to the previous operation number.
4) Dashbaord Reports: This allows me to bring in multiple datasets. I could not bring in the smae BAQ do to Vantage limitation, so I copied the BAQ and added _02 to the end of it. Now I can bring in the same dataset twice.
Problem: I do not know how to create a sql select statement inside of a formula field in crystal reports.
5) BPM: I have not looked into this yet, but my thought is to run a query on the LaborDtl.Update that would update a user field on the JobOper table with the entered quantity. The value would be entered on the NEXT operation's record. Then I could run a simple BAQ report.

Does anyone have any suggestion? Am I off course, is there a better or easier way to do this? Please help.

Dan