Skip to Content
0
Former Member
Feb 27, 2009 at 12:26 AM

Limit dynamic parameter list to data added in last month

38 Views

I have a crystal reports X1 report that uses a dynamic parameter for users to select. This parameter displays all database entries for the field. The field is called PLANNAME and lists out names that users have entered from the main application screens. I want to limit the display of these plan names to the most recent based on the CREATEDATE which is a field on the table that the Planname is stored.

Is there a way that Crystal reports can restrict / limit the list of vaules returned and available for report users to select. The list is steadily growing, and now requires the report users to scroll through hundreds of plannames (that is, all the plan names that have been created over the last two years).

Look forward to any suggestions.

Regards

dave