Solved

Crystal report request to show all part_id's with product-code and an alpha character in Eng_master_id

Posted on 2013-12-09
4
395 Views
Last Modified: 2013-12-09
I have  a request to write a report that will return all Part_Id's that have both a product_Code and an alpha character in the Eng_Master_Id field. using the select expert how do i do this? This is what i got now and it no work:

({PART.ENGINEERING_MSTR}) LIKE '^[A-Za-z0-9]+$' and
NOT ISNULL ({PART.PRODUCT_CODE})
0
Comment
Question by:wallis34
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 39706330
When you say it has an ALPHA character in the Eng_Master_ID field are you saying that it not a number or that it has at least 1 character that is A-Z?

Can it have special characters? or are they alphanumeric fields (made from A-Z (either case) and 0-9)?

You can try

Not IsNumeric({PART.ENGINEERING_MSTR}) 
AND
NOT ISNULL ({PART.PRODUCT_CODE})

Open in new window


mlmcc
0
 

Author Comment

by:wallis34
ID: 39706440
Thanks, that looks good, but there are still many records with blank product codes and actually blank engineering mstr fields. I have atached a couple screen shots please let me know if you want to see other stuff.  TIA!
report-01.jpg
select-expert.jpg
sql.rtf
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 39706615
Are you sure the fields are NULL and not the empty string or one or more blanks?

Try

(
    NoT IsNull(PART.ENGINEERING_MSTR}) 
    AND
    Length(Trim(PART.ENGINEERING_MSTR}) > 0
    AND
    Not IsNumeric({PART.ENGINEERING_MSTR}) 
)
AND
(
    NOT ISNULL ({PART.PRODUCT_CODE})
     AND
    Length(Trim({PART.PRODUCT_CODE})) > 0
)

Open in new window


mlmcc
0
 

Author Closing Comment

by:wallis34
ID: 39706654
This got it, your awesome, thanks!
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question