Solved

exclude one value from a range in the select expert

Posted on 2006-11-03
2
321 Views
Last Modified: 2008-03-17
I want to list values for a range of customers excluding one: The formula I have is:
{Command.fullname} in "customer1" to "customer 3" and "customer 5" to "customer 7".
The error message keeps telling me a boolean is required? How do i exclude values in the middle of a range?

seb
0
Comment
Question by:sebastiz
[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 Comments
 
LVL 77

Expert Comment

by:peter57r
ID: 17865637
Hi sebastiz,

 {Command.fullname} in "customer1" to "customer 3" OR  {Command.fullname} in "customer 5" to  "customer 7".


Pete
0
 
LVL 28

Accepted Solution

by:
bdreed35 earned 500 total points
ID: 17865690
Another way is like this:

{Command.fullname} in "customer1 to customer 7" and
{Command.fullname} <> "customer 4"

Since you are using a Command, I would recommed doing this in the command rather in the record selection formula for performance reasons.
0

Featured Post

[Webinar] Code, Load, and Grow

Managing multiple websites, servers, applications, and security on a daily basis? Join us for a webinar on May 25th to learn how to simplify administration and management of virtual hosts for IT admins, create a secure environment, and deploy code more effectively and frequently.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Crystal Reports - group header 2 69
Unable to total correct amount due to line duplication 5 43
Crystal Report sorting 6 34
Help with a Crystal Formula 6 43
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. …
I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

710 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