Solved

Using a between in Select Exper

Posted on 2013-01-09
2
511 Views
Last Modified: 2013-01-09
Does anybody know how to use a between parameter in the Crystal Reports Select Expert area.  I am trying to set up a parameter for an age field.

When somebody opens the report I want them to be able to select the ages that they want to see in the report.  Not all the grants that we do are asking for the same age range group each time.
0
Comment
Question by:TCHGirl
[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 18

Accepted Solution

by:
vasto earned 500 total points
ID: 38761049
Create 2 parameters "From" and "To". Then click menu "Report" ->"Selection formulas" -> "Record" and add:

<your database field > IN {?@From} TO {?@To}
0
 

Author Comment

by:TCHGirl
ID: 38761088
Thank you, but I ended up making the problem harder then it needed to be and I figure out how to do it.

Thanks
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Rounding duration within 20 min intervals 3 54
Possibly a grouping issue? 7 43
Sum not calculating correctly 22 59
Getting Maximum Score for certain records 7 27
1. Set up your parameter at the report level as usual, check the box Multi-value, and set the Data Type to String 2. Set the Stored Procedure Parameter to varchar(max)  --<---- This part here is the key to it's success Example:    @cst_key var…
Hi, In my previous Article  (http://www.experts-exchange.com/Database/Reporting/A_15199-Introduction-to-Microstrategy.html)I discussed some basic understanding of Microstrategy that how we can get in Intro of Microstrategy (MSTR). Now it's tim…
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

734 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