Sage 100 Crystal Reports how to add a parameter

//Sage 100 Crystal Reports how to add a parameter

Sage 100 Crystal Reports how to add a parameter

Q: Mike we are Sage 100 users and own Crystal Reports, we would like to add a parameter field to the reports so the report prompts for a data range before the report is run. How do we do that?

A: This is a common need that many of our users and customers have, it is a fairly straightforward process once the original Crystal report is setup.

On the Crystal Field Explorer right click the Parameter Fields and select New.blog1blog2Enter the Name, Set Type to Date, set List of Values to Dynamic, Enter Prompt Group Text, from the drop down fields select the Value, Description and then click on Parameters. This will set the Parameter.

blog3Since we want a Date Range: On the Value Option scroll to the bottom and set Allow range values to true and accept.

The next step is to select the select expert: Looks like a yellow funnel.blog4Select Record and then scroll down to the field that you want as the parameter, in this case Order Date. Then click OK.blog5In the Select Expert set the parameter “is equal to” and select the parameter, in the case ?Order Date and click OK.

blog6Each time you run the Crystal Report the parameter of OrderDate Range will be prompted.


If you have questions please contact us at or 760-618-1395. Please stay tuned for more helpful Sage 100 ERP tips!








By | 2018-03-03T08:18:38+00:00 August 11th, 2017|Sage 100 tips and tricks|Comments Off on Sage 100 Crystal Reports how to add a parameter

About the Author: