asked on Crystal report request to show all part_id's with product-code and an alpha character in Eng_master_id
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})
({PART.ENGINEERING_MSTR}) LIKE '^[A-Za-z0-9]+$' and
NOT ISNULL ({PART.PRODUCT_CODE})
Crystal Reports
Last Comment
wallis34
ASKER
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
report-01.jpg
select-expert.jpg
sql.rtf
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
This got it, your awesome, thanks!
Can it have special characters? or are they alphanumeric fields (made from A-Z (either case) and 0-9)?
You can try
Open in new window
mlmcc