Rb?


(system) #1
Use the substring command.
VariableName = SUBSTRING(PartNumber,5,2)
Filter on VariableName = "60"


Patrick J. Winter
Information Services Manager
sSc Specialty Screw Corporation
Vantage 3.00.614, Progress 8.3A

-----Original Message-----
From: Todd Hofert [mailto:thofert@...]
Sent: Thursday, August 10, 2000 12: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.)

(system) #2
In the filter put

partnum='742-60'

or whatever part number you are looking for.
Hope this helps

Tim Care
Electro Chemical Finishing

----- Original Message -----
From: Todd Hofert <thofert@...>
To: Vantage List (E-mail) <vantage@egroups.com>
Sent: Thursday, August 10, 2000 1:34 PM
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

(system) #3
Sorry about the previous answer, I read the original question
wrong. In your filter use

partnum MATCHES '*60'

This will give you all part numbers that end in 60
Hope this helps even more that before.

Tim Care
Electro Chemical Finishing

----- Original Message -----
From: Jim Stetter <jimstetter@...>
To: <vantage@egroups.com>
Sent: Thursday, August 10, 2000 2:09 PM
Subject: RE: [Vantage] RB ?


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