How to enable the Options tab in the Report Options Interpreter (ROI) screen for a custom report in Microsoft Dynamics SL.
To do this, follow these steps:
a. On the Utility menu, click Report Control Maintenance .
b. In the Report Number box, type the report number that you want to modify, and then click Custom Fields .
c. If you are creating a custom text field, type a caption value in the Custom String Field Captions box. If you are creating a check box option, type a caption value in the Custom Logical Field Captions box.
Note For example, type GL Account in the first Custom String Field Captions box, and then type Posted Only in the Custom Logical Field Captions box.
d. Click Save , and then close the Report Control Maintenance (98.300.00) screen.
Use the RIPARAM function to modify the custom report to accept the parameters that you specified in step 1c.
To do this, follow these steps:
a. Start Crystal Reports for Solomon.
b. In the Welcome to Crystal Report for Solomon dialog box, click Open an Existing Report , and then click OK .
c. In the Open dialog box, select the custom report file, and then click Open .
d. On the Report menu, click Select Expert .
e. In the Choose Field dialog box, click the appropriate database field on which you want to base the selection criteria.
f. Click Show Formula , and then type the appropriate formula. The following formula is an example of a formula that uses the RIPARAM function.
if riparam(“shortanswer(0)”) = “True”
then
// Select posted records only for the account entered.
{gltran.acct} = riparam(“LongAnswer(0)”)
and {gltran.posted}=”P”
else
// Select posted and unposted records for the account entered.
{gltran.acct} = riparam(“LongAnswer(0)”)
g. Click OK .
h. Click Save , and then close Crystal Reports for Solomon.