# Rb?

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?

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

----------------------------------------------------------------------------
--
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?

Todd Hofert
Spartan Graphics, Inc.
(616)887-8243
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?

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

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

----------------------------------------------------------------------------
--
We no longer allow attachments to files. To access/share Report Files,