web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / SL Crystal Report - Er...
Microsoft Dynamics SL (Archived)

SL Crystal Report - Error in formula Record Selection

(0) ShareShare
ReportReport
Posted on by RedStorm 1,366

Help! 1) Upgrading to SL2011 from SL7.  2) Going through pain of fixing Crystal reports.  3) We have an invoice format in Flex Billings.  That format is linked to a custom Crystal report we had used in the past without issue.  4)  Now, when we VIEW INVOICE from the Flex Billings Invoice and Adjustment screen we get error:  System Message 6201 - Report Execution failed.  Error 56029.  Error Printing Report.  This field name is not known.  Details:  errorKind  Error in File BI500.....rpt:  Error in formula Record Selection:  '( ( {Command.draft_num}=CStr({@wriparaam}) ) ) AND (({pjinvsec.inv_format_cd}={pjinvhdr.inv_format_cd}) AND ({pjcontrl.control_type} = 'I0') AND {pjinvhdr.draft_num} = '0000145040' AND {pjinvdet.project_billwith}='120742001' AND {pjinvdet.draft_num} <= '0000145040' AND {pjinvdet.li_type} <> 'S")

Thank you in advance for your suggestions.  Dave

*This post is locked for comments

I have the same question (0)
  • Blaine Bryant Profile Picture
    Blaine Bryant on at

    Red Storm,

    Please try this KB:

    INTRODUCTION

    This article describes how to enable the Options tab in the Report Options Interpreter (ROI) screen for a custom report in Microsoft Dynamics SL.

    MORE INFORMATION

    The Options tab in the Report Options Interpreter (ROI) screen lets the user type or select additional report parameters. To enable this functionality in Microsoft Dynamics SL, follow these steps:
    1. Enable one or more fields on the Options tab for the custom report. 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.
    2. 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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans