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
397 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: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

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

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
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 …

751 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