Print Page | Close Window

I can't do this in Parameters

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=15171
Printed Date: 03 May 2024 at 3:02am


Topic: I can't do this in Parameters
Posted By: swatts
Subject: I can't do this in Parameters
Date Posted: 15 Dec 2011 at 6:02am
I have a report that shows employees and a lot of information on them. Unfortunately, Employees 1-20 are test dummies and I do not want them to show. I cannot do this in Parameters, I don't think, because when running the report it prompts me for the employee ID and I don't need it to do that, I need it to show ALL employees. Any suggestions?


Replies:
Posted By: DBlank
Date Posted: 15 Dec 2011 at 6:24am
Do you mean you want to use the employees in a dynamic lov param but you want to exclude the 'dummy records' from the list that is generated to pick from?

Posted By: lockwelle
Date Posted: 15 Dec 2011 at 6:59am
it sounds like you thinking to have a parameter for the employee id so that you can exclude the employees, but you want all the employees AND you don't want to display the first 20 employees as they are test.
 
if that is the case:
Reports\selection formulas\record
{table.employee} > 20
 
should filter out the test employees
 
Hope I am on the right track


Print Page | Close Window