Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
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
Medium Priority
?
400 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 101

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 101

Accepted Solution

by:
mlmcc earned 2000 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

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

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. …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

721 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