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
387 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
  • 2
  • 2
4 Comments
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
This got it, your awesome, thanks!
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
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…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

771 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now