X hits on this document





23 / 96

Flexible Solutions, Inc. – GP Reports Viewer

Once the parameters are populated you can make changes to the Parameter Display Names (what the users will see when running reports) and set up default lookups and values for the parameters. Below are the descriptions of the columns in the Parameters scrolling list:



Parameter Display Name

The name the parameter was given in the report. If the Report Type is Crystal Report and the parameter is a range, two parameters with “From” and “To” will be added automatically at the end of the parameter name. You may change the Parameter Display Name to anything you wish to make it more user friendly by clicking in the field and typing over it. This is what the users see on the GP Reports Viewer window when running their reports.

TIP: When designing your reports try to make the parameter names descriptive so that you can more easily determine what type of lookup to assign to the parameter. For example, if the parameter is for a Customer ID, call the parameter CustomerID instead the more ambiguous name Customer, which could indicate either Customer ID or Customer Name.

Parameter Lookup (Optional)

You can set up a lookup to be associated with each parameter in the GP Reports Viewer window. There are three types of lookups: Dynamics GP, Custom - Static and Custom - Dynamic. GP Reports Viewer ships with a number of pre-defined



If your report contains parameters, click the Get Parameters from Report button and the parameters on the report will populate in the scrolling list on the bottom of the window. If no parameters have been defined in the report, you will receive a message indicating this.

Report Option

Use Default SQL Login and Password from Setup Options Window

Default Value


Modifying a SQL Reporting Services Report for Server and Database Replacement for more information on adding these parameters to your report.

Depends on Setup Options

[only applies to Excel and Crystal Reports]

This option will be unchecked by default unless you have set up an optional SQL Login to use for all of your reports. The default value for this option is controlled by the Use this setting for all new Crystal Reports checkbox on the Setup Options window. We recommend to leave this checked if you are using Crystal or Excel reports.

Document info
Document views583
Page views583
Page last viewedTue Jan 24 07:25:55 UTC 2017