Is Like ?!?!?!
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22485
Printed Date: 29 Apr 2024 at 9:33pm
Topic: Is Like ?!?!?!
Posted By: SRilee
Subject: Is Like ?!?!?!
Date Posted: 25 Oct 2017 at 7:31am
I have been asked to build a report that will identify each time a specific option has been sold however I'm struggling with how to setup the report criteria.
Our option numbers consist of a 9 digit number. The the first four characters vary from house plan to house plan however the last 5 are the same and indict the specific option. An example would be 109115055 and 108115055. These are two separate plans but both have the same option installed.
I would like to design a report where the user could simply input the option number (Ex. 15055) and the report would spit out EACH time a specific option has been sold.
Any suggestions would be greatly appreciated. Thanks!
|
Replies:
Posted By: DBlank
Date Posted: 25 Oct 2017 at 9:36am
just do a select to compare your typed in param to the last 5 characters of the string
?@param = right(field,5)
|
Posted By: SRilee
Date Posted: 25 Oct 2017 at 10:00am
I've been playing with your suggestion but I can't seem to get the syntax right and get the dreaded "Remaining text doesn't appear to be part of the formula" message. My current Record Selection Formula is
{VW_AMA_Est_Options_w_Job.OPTION_NUMBER} = {?Option Number} Obviously this is not accurate but shows what my table and Parameter field are. Given than how would you would you proceed? Many Thanks!
|
Posted By: DBlank
Date Posted: 26 Oct 2017 at 3:09am
right({VW_AMA_Est_Options_w_Job.OPTION_NUMBER},5) = {?Option Number}
this assumes they are both string data types.
|
Posted By: SRilee
Date Posted: 26 Oct 2017 at 9:07am
|
Ah! Is see now. Thank you so much. I owe you lunch or a coffee if you are ever in Charlotte, NC.
|
|