Labor Detail Report Problems

Yahoo Archive
1
Hi Sue,

Sorry about that. It is written in Report Builder. I think I go it fixed
but now I don't have any indirect hours. I changed the join to the JobOper
table to a Inner and the hours are totaled correct. Now I need some way of
including indirect time for each dept.

Darren

> -----Original Message-----
> From: Sue Howard [mailto:sueh@...]
> Sent: Tuesday, December 12, 2000 10:31 AM
> To: 'vantage@egroups.com'
> Subject: RE: [Vantage] Labor Detail Report Problems
>
>
> Darren,
>
> Are you writing the report in Report Builder or Crystal? I
> have a labor
> detail report already written that I could send you. It
> compares last year
> to this year for a specific period. I originally wrote it in
> Report Builder
> but have since written it in Crystal.
>
> Sue Howard
> Information Specialist
> Image National, Inc.
> (208) 287-1904
> sueh@...
>
>
> -----Original Message-----
> From: Darren Mann [mailto:dmann@...]
> Sent: Tuesday, December 12, 2000 9:08 AM
> To: Vantage User Group (E-mail)
> Subject: [Vantage] Labor Detail Report Problems
>
> I am trying to create a summary report of labor
> details for
> the current
> fiscal period as well as comparing to last
> months figures.
> The Report is
> grouped by Dept. using JCDept field and has joins to
> JobOper, GLSys, and
> JCDept. All joins are left outer. The problem
> is that the
> totals are not
> correct, for example one of our dept's of one
> person showed
> 763 total hours
> for last month. All fields are overstated by
> multiples of
> 4x or 5x. Where
> should I look for this type of problem. The fields are
> primarily aggregates
> based on calculated fields to separate setup and labor
> hours. I have been
> experimenting for two days on this but cannot
> make any more
> headway. Please
> offer some new approach.
>
> Thanks
>
> Darren Mann
> Miller Products Co.
>
> -------------------------- eGroups Sponsor
>
> We no longer allow attachments to files. To
> access/share
> Report Files, please go to the following link:
> http://www.egroups.com/files/vantage/
> (Note: If this link does not work for you the
> first time
> you try it, go to www.egroups.com, login and be sure to save
> your password,
> choose My Groups, choose Vantage, then choose Files. If you save the
> password, the link above will work the next time you try it.)
>
>
> [Non-text portions of this message have been removed]
>
>
> -------------------------- eGroups Sponsor
> -------------------------~-~>
> eGroups eLerts
> It's Easy. It's Fun. Best of All, it's Free!
> http://click.egroups.com/1/9698/1/_/411782/_/976638724/
> --------------------------------------------------------------
> -------_->
>
> We no longer allow attachments to files. To access/share
> Report Files, please go to the following link:
> http://www.egroups.com/files/vantage/
> (Note: If this link does not work for you the first time you
> try it, go to www.egroups.com, login and be sure to save your
> password, choose My Groups, choose Vantage, then choose
> Files. If you save the password, the link above will work
> the next time you try it.)
>
>
2
I am trying to create a summary report of labor details for the current
fiscal period as well as comparing to last months figures. The Report is
grouped by Dept. using JCDept field and has joins to JobOper, GLSys, and
JCDept. All joins are left outer. The problem is that the totals are not
correct, for example one of our dept's of one person showed 763 total hours
for last month. All fields are overstated by multiples of 4x or 5x. Where
should I look for this type of problem. The fields are primarily aggregates
based on calculated fields to separate setup and labor hours. I have been
experimenting for two days on this but cannot make any more headway. Please
offer some new approach.

Thanks

Darren Mann
Miller Products Co.
3
Darren,

Are you writing the report in Report Builder or Crystal? I have a labor
detail report already written that I could send you. It compares last year
to this year for a specific period. I originally wrote it in Report Builder
but have since written it in Crystal.

Sue Howard
Information Specialist
Image National, Inc.
(208) 287-1904
sueh@...


-----Original Message-----
From: Darren Mann [mailto:dmann@...]
Sent: Tuesday, December 12, 2000 9:08 AM
To: Vantage User Group (E-mail)
Subject: [Vantage] Labor Detail Report Problems

I am trying to create a summary report of labor details for
the current
fiscal period as well as comparing to last months figures.
The Report is
grouped by Dept. using JCDept field and has joins to
JobOper, GLSys, and
JCDept. All joins are left outer. The problem is that the
totals are not
correct, for example one of our dept's of one person showed
763 total hours
for last month. All fields are overstated by multiples of
4x or 5x. Where
should I look for this type of problem. The fields are
primarily aggregates
based on calculated fields to separate setup and labor
hours. I have been
experimenting for two days on this but cannot make any more
headway. Please
offer some new approach.

Thanks

Darren Mann
Miller Products Co.

-------------------------- eGroups Sponsor

We no longer allow attachments to files. To access/share
Report Files, please go to the following link:
http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time
you try it, go to www.egroups.com, login and be sure to save your password,
choose My Groups, choose Vantage, then choose Files. If you save the
password, the link above will work the next time you try it.)


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