Rb?


(system) #1
I have received a couple of good solutions to this problem, including the
one from Jim listed below. However, with a few more scratches of my head I
realized that the part description of all of these items BEGINS with 60".
Therefore is used a filter Part Description BEGINS '60"'. Report works now.
Thanks to all who replied.

Todd




If your width designation is aways in positions 5-6 of the part number, you
can create a calculated field called "Width"

Substring(Partnum,5,2)

then include "Width" in the filter ----> Width = "60" which would
yield all parts with a width of 60.

Hope this helps.
Jim Stetter


I am trying to create a report for a few inventory items. These items come
in different colors and sizes. The part number indicates color and size.
For
example Black rolls of Vinyl have the following part numbers:

742-15
742-20
742-30
742-60

The 742 means BLACK and the 15, 20 ,30, 60 mean width. I only want this
report to show me on hand quantity for the part numbers that are 60" wide.
How do I get Report Builder to make this selection?

Thank in advance
Todd Hofert
Spartan Graphics, Inc.
(616)887-8243


----------------------------------------------------------------------------
--

(system) #2
I am trying to create a report for a few inventory items. These items come
in different colors and sizes. The part number indicates color and size. For
example Black rolls of Vinyl have the following part numbers:

742-15
742-20
742-30
742-60

The 742 means BLACK and the 15, 20 ,30, 60 mean width. I only want this
report to show me on hand quantity for the part numbers that are 60" wide.
How do I get Report Builder to make this selection?

Thank in advance
Todd Hofert
Spartan Graphics, Inc.
(616)887-8243

(system) #3
If your width designation is aways in positions 5-6 of the part number, you
can create a calculated field called "Width"

Substring(Partnum,5,2)

then include "Width" in the filter ----> Width = "60" which would
yield all parts with a width of 60.

Hope this helps.
Jim Stetter


-----Original Message-----
From: Todd Hofert [mailto:thofert@...]
Sent: Thursday, August 10, 2000 1:35 PM
To: Vantage List (E-mail)
Subject: [Vantage] RB ?


I am trying to create a report for a few inventory items. These items come
in different colors and sizes. The part number indicates color and size.
For
example Black rolls of Vinyl have the following part numbers:

742-15
742-20
742-30
742-60

The 742 means BLACK and the 15, 20 ,30, 60 mean width. I only want this
report to show me on hand quantity for the part numbers that are 60" wide.
How do I get Report Builder to make this selection?

Thank in advance
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.)



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