BAQ for Creating a list of scheduled jobs by department V8.03.40

Yahoo Archive
1
Thanks.  I ended up adding a custom field in the operation to map it to the department.  Now the summarize works just fine.  
Thanks!
2

I would like to create a BAQ for scheduled jobs by department.  It would have data columns like 

JobNumber, PartNumber, JCDepartment, EstHours, ActHours, StartDate, EndDate. 


This in itself is relatively simple, but I was trying to use the summarize feature of the BAQ so that I didn't have to dump a larger data set and create a pivot table in excel to group it by department.  


Any ideas?


Eddie Cler

Paul's Machine & Welding Corp. 

3
>>summarize feature of the BAQ to group it by department.
>>JopOper table  JCDept
I've had mixed results with summarizing in V8 BAQs

Instead I sometimes use BAQ reports.
Dump the raw data into Crystal where it is easier to summarize.
And if I maintain my sections and column/heading widths I can export cleanly to Excel.
4
Thanks, 
I don't seem to have a JobOper.JCDept field.  Do you have one?  The closest that I have is a field in the OperationMaster table that we populated (charachter01).  
5
Use the Executive query ability to sum by department.  Using this you can create your own dashboards similar to the Resource Schedule Load Graph and Plant Schedule Load Graph.

Bruce

Larson Solutions
Bruce@...
6
>>I don't seem to have a JobOper.JCDept field.  Do you have one?
>>OperationMaster table that we populated (charachter01).
Sorry, JobOper.JCDept field is in E9.

If you want to try something besides character01, may be able to tie JobOper to JobOdDtl to ResourceGroup
-- to pull ResourceGroup.JCDept

>> Executive query
I might do it in Crystal if it's just a report
I think an Exec query is nice if you need a dashboard but it's a bit more setup.
Manuals have examples if you haven't done one before.