Solved

Parameter like

Posted on 2011-02-15
8
1,082 Views
Last Modified: 2012-05-11
I know you can add discrete values in a parameter llike London
I would like to have a flexible parameter like London% where the user can state London in the paramenter and it will find all values stating with London
Can this be done and if so how
Gordon
0
Comment
Question by:GiaHughes
[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
  • 4
  • 2
  • 2
8 Comments
 
LVL 12

Assisted Solution

by:JayConverse
JayConverse earned 150 total points
ID: 34895739
Let the users enter a parameter, then put this in the record selection formula

UpperCase({?myparam}) = uppercase(left({myfield},len({?mymaram})))
0
 

Author Comment

by:GiaHughes
ID: 34895848
Hi
I would like to give the users a list to select from
ie
Selsey
Runcton
Fruit

When they select Selsey (for example) I want information returned for Selsey and Selsey Leaf

Hope this makes sense
Gordon
0
 
LVL 12

Expert Comment

by:JayConverse
ID: 34895887
That's fine, just put those values into the selection list of the parameter.
0
On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

 

Author Comment

by:GiaHughes
ID: 34895892
Hi

Do I still create a formula
UpperCase({?myparam}) = uppercase(left({myfield},len({?mymaram})))

Gordon
0
 

Author Comment

by:GiaHughes
ID: 34896120
Hi

I tried to add the formula
?myparam guess this is replaced with ?factory being the parameter

Not sure what the other 2 are replaced with?

Gordon
0
 
LVL 26

Expert Comment

by:Kurt Reinhardt
ID: 34897752
Create a parameter with values like London, Selsey, etc.. the use the following record selection criteria:

{table.field} like {?param}

No need to convert to uppercase unless your database doesn't allow for case insensitivity (Oracle, for example) AND you have mixed case data.  A "like" isn't particularly efficient, but at least it processes on the databaes, where as an uppercase against a databased field won't be.

~Kurt
0
 

Author Comment

by:GiaHughes
ID: 34902662
Hi
I found the solution
A simple case of using the slect feature and adding field with starts with and add the ?parameter
It works ok
Gordon
0
 
LVL 26

Accepted Solution

by:
Kurt Reinhardt earned 350 total points
ID: 34902699
{table.field} like {?param} and {table.field} startswith {?param} are functionally the same in this regard.  When Crystal Reports creates it's query to pass to the database, they'll both be converted like..

~Kurt
0

Featured Post

[Webinar] Learn How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
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…
If you're a developer or IT admin, you’re probably tasked with managing multiple websites, servers, applications, and levels of security on a daily basis. While this can be extremely time consuming, it can also be frustrating when systems aren't wor…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…

687 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