Filter functions not working in Cascading Parameters Crystal Reports 2016

RUA Volunteer2?
RUA Volunteer2? used Ask the Experts™
on
Cascading Parameter will let me pick from a list however when set :
1.      The list displays the oldest records first and does not show the most recent entries in the database as the list is cut off…(I know this is because of the MAXRecords…registry setting. Can the list be set to DESC Descending in the registry? I need a Parameter that allows for the Last IN First OUT listing of records. So users see the most recent value in the data source….?
2.      The filtering mechanism does not show all the filter series/sets…..the 1,2,3,4…(window to the left of the filter Icons) in the filter list to parse the record sets. The values are missing?
3.      The filter seems messed up as when a value is selected in the filter window by typing the correct & confirmed value it does not show up in the dropdown list above next to the carrot. It all disappears? Baffling.
4.      After attempting to filter using the filter icon button in the parameter. The entire list of records disappears and there is no way to pick the record. Even when the value is 100% correct.
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:
You can control sort and filtering using a Command as the data source for a dynamic parameter.
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013
Commented:
Agree.  just build a command to get the data you need for the values then build you parameter using it for the LOV.  No need to use it anywhere else in the report.

mlmcc
RUA Volunteer2?Tableau Trainer & Consultant Sales Exec.

Author

Commented:
Thank you.

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