Parameters how to limit the records returned from a Dynamic Parameter List? Is it possible.

RUA Volunteer2?
RUA Volunteer2? used Ask the Experts™
on
Parameters how to limit the records returned from a Dynamic Parameter List? Is it possible. I have CR 2016 Sp5
 How do I access parameters dynamically while limiting the record list in a report. If my Crystal Report has a long list of employees say 1000 and I only need to show > 50 of them for users to pick from is there a way to limit the number of rows returned to list when the list is built dynamically retrieving all records. I know how to do it statically or with an import from an excel or text file but wondered if there is a better way to do this?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Professor of MIS at Penn State Erie and Owner, Millet Software
Commented:
Use a database VIEW or a Crystal Command as the data source for the parameter.
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013
Commented:
Agree, WIth the view or command you can also filter so they only see the ones you want them to see.  If you want to limit to any 50  then you could change the limit in the registry and you would get the first 50 it finds which might vary from run to run.

mlmcc
RUA Volunteer2?Tableau Trainer & Consultant Sales Exec.

Author

Commented:
I would imagine I should search for examples of a view which I build in Oracle prior to the report or use the SQL Add Command where I would have to tie it in (link it in with the rest of the tables) and point the parameters to it.  I have also often wondered and never used them if the ones embedded in the Formula Functions Formula Workshop - Formula Editor can do the same thing?  I do not know how they work if you know if they can do the same thing? I would love to know. I am not even sure their correct terminology. Thanks for your help as always.
Expert Spotlight: Joe Anderson (DatabaseMX)

We’ve posted a new Expert Spotlight!  Joe Anderson (DatabaseMX) has been on Experts Exchange since 2006. Learn more about this database architect, guitar aficionado, and Microsoft MVP.

Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet Software

Commented:
A database VIEW as a source to a dynamic parameter doesn't need to be linked to the other tables used by the report.
It is treated as an independent data source, just for the parameter.
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
Ido - do they still "allow" multiple data sources in CR2016?  I haven't tried it yet.  I know they fixed it in Crystal Enterprise so you can only have a single data source.

mlmcc
Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet Software

Commented:
Hi Mike, yes Crystal 2016 still supports multiple data sources.

But my answer above doesn't require multiple data sources. For example, assuming the database contains an Employee table, a VIEW can be created that contains a subset of these employees (e.g. only employees that had more than $1,000 in sales).
And that VIEW can be added (using Database Expert...) to the report. It doesn't need to be joined to the other tables. It can be used just to provide data for a dynamic parameter.
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
Ido - Thanks.  CR for Enterprise doesn't even allow that use.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial