PT Sterling Tulus Cemerlang
www.sterling-team.com

Whatsapp
+62-877-8655-5055

Email
sales-enquiry@sterling-team.com

Address
Sampoerna Strategic Square
South Tower Level 30
Jl Jend. Sudirman No. 45-46
Jakarta 12930 – Indonesia

500+ FREE Tips SAP Business One for you to Become SAP B1 Super User from Sterling Tulus Cemerlang (STEM)

Create Selection Criteria Windows for SAP Crystal Report

SAP Business One Tips Create Selection Criteria Windows

This time we will discuss the steps in creating reports and layouts, Create a Selection Criteria Window with the aim of filtering data.

Here are the steps:

  1. In SAP Crystal Reports, create a blank report and link it to the data sources.
  2. On the Database Expert screen, select the table (Example: OITM (Item Master Data)) and select the OK button.
  3. In the right pane of the Field Explorer, open the Database Fields node, then select a table.
    * Note: Field Explorer is displayed by default for new reports. If you want to close it and want to reopen it, select ViewField Explorer in the menu bar.
  4. Drag this field to the work area on the Design tab and drag it to the Details area:
    • ItemCode
    • ItemName
  5. The fields appear in the Details area with labels associated with the Page Header area. You can edit it in the text label. For more information, see SAP Crystal Reports online help.
  6. In the Field Explorer panel, right-click Parameter Fields and select New.
  7. On the Create New Parameter screen, in the Name field, enter the MyParameter @ SELECT * FROM OITM token
  8. In the Value Options list at the bottom of the screen, set the value for one of these 2 configurations:

    Choose From List field

  9. To make a choose-from-list field for single-choice selection, set the value :
    Value Option Setting
    Prompt Text : Select an Item
    Allow multiple Value : False
    Allow discreate Value : True
    Allow range Value : False
    SAP Business One Tips - Create Selection Criteria Windows for SAP Crystal Report

    SAP Business One Tips – Create Selection Criteria Windows for SAP Crystal Report

    The results of the setting values that have been done areas in the table above, users can make a single-choice selection.

  10. When you click the Choose from List icon on the selection criteria screen, the List of Items screen will appear.
    SAP Business One Tips - Create Selection Criteria Windows for SAP Crystal Report

    SAP Business One Tips – Create Selection Criteria Windows for SAP Crystal Report

     (…)[Browse] Button

  11. To make the (…) [Browse] button for multiple-choice selection, set the value :
    Value Option Setting
    Prompt Text : Choose the (…) Button
    Allow multiple Value : True
    Allow discreate Value : True
    Allow range Value : False
    SAP Business One Tips - Create Selection Criteria Windows for SAP Crystal Report

    SAP Business One Tips – Create Selection Criteria Windows for SAP Crystal Report

    The results of the setting value are in accordance with the table above, users can make multiple selection choices.

  12. When you select the (…) [Browse] button, the Item List-Selection Criteria screen will appear as shown below.

    SAP Business One Tips - Create Selection Criteria Windows for SAP Crystal Report

    SAP Business One Tips – Create Selection Criteria Windows for SAP Crystal Report

  13. On the Create New Parameters screen, select the OK button.

Also read:

Run Your Business With The Piece of Mind Using SAP Business One

This article was written by PT. Sterling Tulus Cemerlang
More details about SAP Business One,
email to: sales-enquiry@sterling-team.com or call +6221-5806336 or wa +6287786555055

, , , , , , , ,