Solved

Using a between in Select Exper

Posted on 2013-01-09
2
475 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
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Formatting a Crystal Reports Report 9 77
SSRS UK Map with Postcodes 2 104
Ignore parameter if no value entered 22 46
A string is required here error 20 9
Problem Statement In an SAP BI BO Integration project when a BO universe is built on a BEx query, there can be an issue of unit & formatted value objects not getting generated in a BO universe for some key figures. This results in an issue whereb…
How to increase the row limit in Jasper Server.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…

867 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now