Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: Is Like ?!?!?! Post Reply Post New Topic
Author Message
SRilee
Newbie
Newbie
Avatar

Joined: 09 Dec 2014
Location: United States
Online Status: Offline
Posts: 3
Quote SRilee Replybullet Topic: Is Like ?!?!?!
    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!
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet 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)
IP IP Logged
SRilee
Newbie
Newbie
Avatar

Joined: 09 Dec 2014
Location: United States
Online Status: Offline
Posts: 3
Quote SRilee Replybullet 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!
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet 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.
IP IP Logged
SRilee
Newbie
Newbie
Avatar

Joined: 09 Dec 2014
Location: United States
Online Status: Offline
Posts: 3
Quote SRilee Replybullet 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.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.