FR
The FR parameter enables printing and determines the format of the report. Specify FRRS for Production Reporting for Reporting Services, FRCR for Production Reporting for Crystal Reports, or RSNATIVE for Reporting Service native SQL report. RSNATIVE gets data from a custom SQL query and does not use the views.
For Production Reporting for Reporting Services, a Print button is placed in the toolbar. The button is placed at the left of list. Use the Options parameter to change the placement of the button.
For Production Reporting for Crystal Reports, a menu is placed to the left of the toolbar.
Additional parameters vary based on the value set for the FR parameter. The syntax is:
FR=FRCR view format template form
FR=FRRS view projName repName format repServer
RSVirtualDirectory repParams
FR=RSNATIVE projName repName form format repServer
RSVirtualDirectory repParams
| view | The name of the view which will provide data for the first report. |
| format | For FRRS, the format options are HTML3.2, HTML4.0, HTMLOWC, MHTML, IMAGE, EXCEL, CSV, PDF, XML, and NULL. (NULL is the default and uses the Reports virtual directory to display the report in the browser.) For FRCR, the format options are RPT, XLS, PDF, and XML. This parameter must be specified for RPT, XLS, and XML. PDF is the format used if this parameter is not specified. |
| template | The Crystal Reports template used to format the data. The template name is required but not the path or extension. The default location is the Program Files\Infor\CPM\Web\CrystalTemplates directory . |
| form | Report title. This parameter is optional. |
| projName | Reporting Services project name. |
| repName | Reporting Services report name. This parameter must be specified if the report name is different from the view name. If the names match, this parameter is optional. |
| repServer | Report server computer name. This parameter must be specified if the report server and the Decision server are on different computers or on the same computer but running on different ports. If they are on the same computer and running on the same port, this parameter is optional. |
| RSVirtualDirectory | Reporting Services virtual directory. This
is specified during the Reporting Services installation. This parameter must be
specified if the following conditions are true:
|
| repParams | For FRRS and RSNATIVE, you can define custom
parameters in Visual Studio. The runtime values for these parameters are passed
through to the report. For example, to specify a Reporting Services parameter
named "Title" and pass a value of "My Report Title":
You can specify additional parameters by separating each parameter and value with a semi-colon. This example has two parameters ("Title" and "MyNewUnit") passed to a single Reporting Services report.
If you have multiple reports you can assign Reporting Services parameters to each report by separating the semi-colon delimited list with a comma. This example creates two financial reports with two Reporting Services parameters being passed to each financial report.
Optionally, you can set the repParams parameters in the TPLDisplayView file by modifying the following line.
You can dynamically build a custom string of parameters and send that string to the SetRSValues() function where they are used as an argument for the function. Going back to the first example of a single report with a single reporting services parameter named "Title" and specifying the template view to use for the data in the report:
|
Examples
/CPM/Workstation/TPLDisplayView.aspx?View=CT RS Income Statement by Unit&Form=PRRS Income Statement by Unit&Options=creadzb&FR=FRRS&projName=CtrainRS2005&repServer=localhost
/CPM/Workstation/TPLDisplayView.aspx?View=CT MR Balance Sheet&Options=abcdefghijklmnopqrstuvwxyz&Form=Balance Sheet&FR=FRCR&Template=13column