Do you have any experience in Access? When a report gets this
complicated I usually like to dump the data in Access where I can
create multiple queries to filter what I want and don't want and
perform grouping and summation functions on data before trying to
link them into a report. If you have some experience and want some
tips on how to get going on this let me know and I'll do what I can.
If you don't, you may want to take some classes, I find that Access
is a very powerful reporting and data-mining tool.
Brian Stenglein
Clow Stamping Co.
complicated I usually like to dump the data in Access where I can
create multiple queries to filter what I want and don't want and
perform grouping and summation functions on data before trying to
link them into a report. If you have some experience and want some
tips on how to get going on this let me know and I'll do what I can.
If you don't, you may want to take some classes, I find that Access
is a very powerful reporting and data-mining tool.
Brian Stenglein
Clow Stamping Co.
--- In vantage@yahoogroups.com, "schujamm" <jims@...> wrote:
>
> (Vantage 6.1)
>
> I'm back after a few days of hacking my through a report that is
> close, but not close enough for my engineering taste. I need to
see
> all the open jobs and operation sequences scheduled on each work
> center for a given day. I need to be able to get labor detail
> information and sum multiple labor entries for multiple jobs and
> sequences from the LabrDtl table with out loosing data in the
JobOper
> table on jobs that ran that day without dropping the jobs that
didn't
> run.
>
> I have tried to write the report from both the LabrDtl and the
JobOpr
> table but have not found the ideal set if Links and filters that
will
> allow me to capture all the open jobs and labor information without
> dropping data. My best attempt so fare is based out of the LabrDtl
> table with a link to the JobOper table.
>
> It's almost impossible for someone to answer this plea with out
> looking at the report. Would anyone be interested in looking at the
> report and giving me some ideas? or just fix it.
>
> Does any one know of a report that gives similar data that I might
be
> able to dig into and learn a new direction?
>
> Does any one know if Corvu has an OEE module/report/interface?
>
> Thanks
>
> Jim
>
> As a side note: I just want to thank this user group for all the
> information and help you have given me. It has been a well of
> knowledge in a desert without a maintenance contract and hence no
> help screens.
>