Seems like reporting out of order releases breaking on the
"make" flag would do it.

Todd Hofert wrote:

>
> I am trying to figure out a way to determine what percentage of the items
> that we sell are from the standard Vantage part master and what percentage
> is custom manufactured. Is there anyone out there that could tell me how I
> would do that in report builder?
>
> Thanks
> Todd Hofert
> Spartan Graphics, Inc.
> (616)887-8243
>
>
> 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.)

I am trying to figure out a way to determine what percentage of the items
that we sell are from the standard Vantage part master and what percentage
is custom manufactured. Is there anyone out there that could tell me how I
would do that in report builder?

Thanks
Todd Hofert
Spartan Graphics, Inc.
(616)887-8243

There are many different ways to do this, so here is one scenario. If you
have marked your parts as stocked and non-stocked (the Vantage way a
differentiating between standard and custom parts) you could start your
report from InvDtl, then link to InvHed and Part. Create a funcion that
would apply a boolean value (true) to either your stock or non-stock parts.
Now, create another function that would total the previous one if true.
Total your total dollars invoiced vs. the functions' total value and you
have a percent of standard and/or custom parts.

Let me know if you need more help. Like I said there are many ways to get
this number, depending on how you have setup your database.

Ted Kitch
tedkitch@...

On Fri, 3 Nov 2000 07:49:04 -0500, vantage@egroups.com wrote:

> I am trying to figure out a way to determine what percentage of the items
> that we sell are from the standard Vantage part master and what
percentage
> is custom manufactured. Is there anyone out there that could tell me how
I
> would do that in report builder?
>
> Thanks
> Todd Hofert
> Spartan Graphics, Inc.
> (616)887-8243
>

Ted Kitch
tedkitch@...

_______________________________________________________
Say Bye to Slow Internet!
http://www.home.com/xinbox/signup.html