Dynamic Parameter Maximum Value
Printed From: Crystal Reports Book
Category: General Information
Forum Name: Announcements
Forum Discription: Please check this section for the latest announcements from Crystal Reports Forum
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22550
Printed Date: 24 Apr 2024 at 12:40pm
Topic: Dynamic Parameter Maximum Value
Posted By: jyensel
Subject: Dynamic Parameter Maximum Value
Date Posted: 21 Feb 2018 at 3:49am
I have a report that pulls Employee Performance Records using a dynamic parameter updating on employeeid allowing the end users to select the employee or employees that they wish to review.
After 10+ years we have reached the maximum number of record capability for a dynamic parameter to display.
Is there a way to restrict the list of a dynamic parameter in Crystal Reports?
I see option two to be creating a new table that is more fine tuned for active employees but I am hoping to avoid some of that complexity.
If there is an approach I am not considering I would appreciate the feedback.
Thanks
|
Replies:
Posted By: kevlray
Date Posted: 22 Feb 2018 at 4:18am
|
For dynamic parameters I normally create a command to just bring back the values necessary, thus in your case only active employees. For me, it is usually a very simple SQL statement.
|
Posted By: jyensel
Date Posted: 22 Feb 2018 at 5:38am
I have never considered using the Db command, that worked perfectly thank you.
|
|