Crystal Reports Dynamic Parameters for Sage 100

Do you need to create a report that allows you to select a value when you run it? If the problem is values are always being added, do not use Static Parameter fields but instead Dynamic Parameter fields. Here are the steps to setting this up:

Note: If you have over 1000 values that will be returned, please read the following post on increasing the number of values returned: https://www.sage100crystalreports.com/post/how-to-increase-the-number-of-values-for-a-dynamic-parameter

1) Create a New Parameter Field by going into the Field Explore, right clicking on Parameter Fields and choosing New.

2) Under the List of Values, select "Dynamic". Under the Data Source, choose the field you want.

3) Now when you run the report, you will see all the values in the table as shown below for the Item Numbers in Sage 100.