RB filter on JobNum

Yahoo Archive
1
Thanks Wayne and Lonnie. Your suggestions worked very nicely.

Troy Funte
Liberty Electronics

----- Original Message -----
From: Troy Funte
To: vantage@yahoogroups.com
Sent: Monday, August 13, 2001 4:14 PM
Subject: [Vantage] RB filter on JobNum


Maybe someone can give me direction. I could do this in Crystal, but am not sure how to do it in Report Builder.

I need to filter out (exclude from the report) jobs that either: A. Begin with a Zero, or B. End with a Letter.

For example, These jobs should be included:
203-1-1
305-3-1
133-2-1

These jobs should NOT be included:
7554-01A
0315-8
0274-1-1

Any solutions out there?

Troy Funte
Liberty Electronics



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


Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]
2
Maybe someone can give me direction. I could do this in Crystal, but am not sure how to do it in Report Builder.

I need to filter out (exclude from the report) jobs that either: A. Begin with a Zero, or B. End with a Letter.

For example, These jobs should be included:
203-1-1
305-3-1
133-2-1

These jobs should NOT be included:
7554-01A
0315-8
0274-1-1

Any solutions out there?

Troy Funte
Liberty Electronics



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

I think the following would work as is.

Create calculated field with value..
iif(substring(jobnum,1,1) <> "0" and substring(jobnum,length
(jobnum),1) >= "A" and substring(jobnum,length(jobnum),1)
<= "Z",yes,no)

The syntax is correct but I didn't test it fully - place in filter to
give it a try. If it bombs let me know and I'll help to hash it out.

Lonnie



--- In vantage@y..., "Troy Funte" <tfunte@e...> wrote:
> Maybe someone can give me direction. I could do this in Crystal,
but am not sure how to do it in Report Builder.
>
> I need to filter out (exclude from the report) jobs that either: A.
Begin with a Zero, or B. End with a Letter.
>
> For example, These jobs should be included:
> 203-1-1
> 305-3-1
> 133-2-1
>
> These jobs should NOT be included:
> 7554-01A
> 0315-8
> 0274-1-1
>
> Any solutions out there?
>
> Troy Funte
> Liberty Electronics
>
>
>
> [Non-text portions of this message have been removed]
4
Troy,

I did it again... hit send before double checking the text.

I think it should be..
iif(substring(jobnum,1,1) <> "0" and (substring(jobnum,length
(jobnum),1) < "A" or substring(jobnum,length(jobnum),1)
> "Z"),yes,no)

Sorry about that,

Lonnie


--- In vantage@y..., "Lonnie Drew" <lonniedrew@c...> wrote:
> Troy,
>
> I think the following would work as is.
>
> Create calculated field with value..
> iif(substring(jobnum,1,1) <> "0" and substring(jobnum,length
> (jobnum),1) >= "A" and substring(jobnum,length(jobnum),1)
> <= "Z",yes,no)
>
> The syntax is correct but I didn't test it fully - place in filter
to
> give it a try. If it bombs let me know and I'll help to hash it
out.
>
> Lonnie
>
>
>
> --- In vantage@y..., "Troy Funte" <tfunte@e...> wrote:
> > Maybe someone can give me direction. I could do this in Crystal,
> but am not sure how to do it in Report Builder.
> >
> > I need to filter out (exclude from the report) jobs that either:
A.
> Begin with a Zero, or B. End with a Letter.
> >
> > For example, These jobs should be included:
> > 203-1-1
> > 305-3-1
> > 133-2-1
> >
> > These jobs should NOT be included:
> > 7554-01A
> > 0315-8
> > 0274-1-1
> >
> > Any solutions out there?
> >
> > Troy Funte
> > Liberty Electronics
> >
> >
> >
> > [Non-text portions of this message have been removed]
5
You could create a calculated field to filter on, like:

SUBSTRING(JobNum,1,1) = '0' or IS-LETTER(SUBSTRING(JobNum,LENGTH(JobNum)))

-Wayne Cox

At 04:14 PM 8/13/2001 , you wrote:
>Maybe someone can give me direction. I could do this in Crystal, but am
>not sure how to do it in Report Builder.
>
>I need to filter out (exclude from the report) jobs that either: A. Begin
>with a Zero, or B. End with a Letter.
>
>For example, These jobs should be included:
> 203-1-1
> 305-3-1
> 133-2-1
>
>These jobs should NOT be included:
> 7554-01A
> 0315-8
> 0274-1-1
>
>Any solutions out there?
>
>Troy Funte
>Liberty Electronics