Report Builder Question

Thank you both it worked. As you probably know those left outer add about 30
seconds but hey it works. thanx again

-----Original Message-----
From: Martin Nijdam [mailto:martinn@...]
Sent: Thursday, September 07, 2000 12:52 PM
To: 'vantage@egroups.com'
Subject: RE: [Vantage] Report Builder Question



You need to do a left outer link to you PartBin Table. Format the field so
the 0 will appear for an unknown.

Martin Nijdam (Jr. Ing.)
Suss Woodcraft Int'l
(514) 363-3565

> -----Original Message-----
> From: Trzaska, Mark [SMTP:mtrzaska@...]
> Sent: Thursday, September 07, 2000 1:41 PM
> To: Vantage (E-mail)
> Subject: [Vantage] Report Builder Question
>
>
> Hello all,
> Guru's out there i have a question. How can you make zero qty's in
> inventory
> appear on a report. I have a report that lists all the materials for a
> specific job. It lists the on hand qty's in inventory the part name
> description, etc... However when I run the dang thing the zero qty items
> do
> not appear???? Is there a way i can tell this thing to print these records
> even though the ohqty is 0?
>
> Any help is appreciated
>
>
> [Non-text portions of this message have been removed]
>
>
> 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.)

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.)
You need to update the aggregate field, click 'Options', and under
processing, select 'Pre-pass'.
Is your aggregate set to "PRE PASS"? If not you can change
that in the aggregate definition screen (Options button)

Tim Care
Electro Chemical Finishing
----- Original Message -----
From: <JEFFTKELLY@...>
To: <vantage@egroups.com>
Sent: Wednesday, August 09, 2000 8:53 AM
Subject: [Vantage] Report Builder Question


> Hi Everyone,
>
> We have written a report that show total vendor purchases for a year. We
> would like to sort this report by this total amount to see who we spend
the
> most dollars with. We can't get the "aggregate" field to sort. I am sure
> that it is something simple, but we haven't figured it out. Your help is
> greatley appreciated.
>
> Thanks,
> Jeff Kelly
> Youngberg Industries, Inc.
>
>
>
> 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.)
>
Thanks for the advice, but I don't have a group defined as part#. I am just
starting to get my hand around this. Basically all I've done is start with
Invoice data base. I can pull up all of the given transactions for each
part number after, July for example. But, I only want the last one. So, no
I don't have a group defined as part #.

Thanks,

Dean
----- Original Message -----
From: Jim Frice <Jim.Frice@...>
To: <vantage@egroups.com>
Sent: Tuesday, August 15, 2000 10:41 AM
Subject: [Vantage] Report Builder Question


> Dean,
>
> If you have a group defined as part#. You have a group footer line for the
> part#. You can do a aggregate calculation on the invoice date or ship date
> depending on what record you are using. The aggregate type will be
maximum,
> reset by part#, accumulation is every composite, and processing is
pre-pass.
> Then have the report print only the group lines suppressing the record
> lines. Move the fields or copy the fields you want to print to the group
> line.
>
> Jim Frice
>
>
> > -----Original Message-----
> > From: Dean Brown, Jr. [mailto:dbrownjr@...]
> > Sent: Tuesday, August 15, 2000 12:55 PM
> > To: vantage@egroups.com
> > Subject: [Vantage] Report Builder Question
> >
> >
> > I am writing a program in Report Builder. I need the program to give me
> > that LAST instance a part was sold. I can get it to bring up ALL of
them,
> > but I only want the last one, no matter when it was sold. Can anyone
help
> > me?
> >
> > Dean
>
>
>
>
> 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 think he means for you to create a group in your report builder
report-this group would be defined as partno. Then you create an aggregate
calculation in that group's footer to get the info that you want. Re-read
his suggestion and give it a whirl. It sure got me thinking about a couple
of things I've tried previously and couldn't get to work.


Thanks for the advice, but I don't have a group defined as part#. I am just
starting to get my hand around this. Basically all I've done is start with
Invoice data base. I can pull up all of the given transactions for each
part number after, July for example. But, I only want the last one. So, no
I don't have a group defined as part #.

Thanks,

Dean


> Dean,
>
> If you have a group defined as part#. You have a group footer line for the
> part#. You can do a aggregate calculation on the invoice date or ship date
> depending on what record you are using. The aggregate type will be
maximum,
> reset by part#, accumulation is every composite, and processing is
pre-pass.
> Then have the report print only the group lines suppressing the record
> lines. Move the fields or copy the fields you want to print to the group
> line.
>
> Jim Frice
>
>
I believe that all you need to do is create a group based on part number.
Delete or suppress the record band line. Then create a new group footer
band line. Put all of the information you need into the group footer band
line. Then sort in ascending order on the invoice number. this will give
you one line of information on the report that corresponds to the last time
the part was invoiced.

Hope this helps. Feel free to call me with questions.

Rick Lane
Intelligent Systems Integration, Inc.
661B Weber Drive
Wadsworth, OH 44281
330-335-5291
Fax: 330-335-7275

"Helping business make intelligent use of technology"


-----Original Message-----

I am writing a program in Report Builder. I need the program to give me
that LAST instance a part was sold. I can get it to bring up ALL of them,
but I only want the last one, no matter when it was sold. Can anyone help
me?

Dean
You need to do a left outer link to you PartBin Table. Format the field so
the 0 will appear for an unknown.

Martin Nijdam (Jr. Ing.)
Suss Woodcraft Int'l
(514) 363-3565

> -----Original Message-----
> From: Trzaska, Mark [SMTP:mtrzaska@...]
> Sent: Thursday, September 07, 2000 1:41 PM
> To: Vantage (E-mail)
> Subject: [Vantage] Report Builder Question
>
>
> Hello all,
> Guru's out there i have a question. How can you make zero qty's in
> inventory
> appear on a report. I have a report that lists all the materials for a
> specific job. It lists the on hand qty's in inventory the part name
> description, etc... However when I run the dang thing the zero qty items
> do
> not appear???? Is there a way i can tell this thing to print these records
> even though the ohqty is 0?
>
> Any help is appreciated
>
>
> [Non-text portions of this message have been removed]
>
>
> 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.)
Mark,

You need to make an outer join on the part bin table. This should do it for you.


Jeff

"Trzaska, Mark" wrote:

>
> Hello all,
> Guru's out there i have a question. How can you make zero qty's in inventory
> appear on a report. I have a report that lists all the materials for a
> specific job. It lists the on hand qty's in inventory the part name
> description, etc... However when I run the dang thing the zero qty items do
> not appear???? Is there a way i can tell this thing to print these records
> even though the ohqty is 0?
>
> Any help is appreciated
>
> [Non-text portions of this message have been removed]
>
> 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.)