Skip to Content

Parameter - Value Options - Choose From List

Looking at the "How to Work With SAP Crystal Reports in SAP Business One" version 9.1, page 16, it states that you can create a "Choose From" list from a parameter in SAP from a Crystal report. In my 20+ years of experience with Crystal Reports, I have never seen this functionality.

How do you get a report to allow a user in SAP B1 to see a list of available items using these instructions?

The instructions do not say whether or not the parameter you are creating is Static or Dynamic. Which is it?

The instructions also say that you have to create a blank report for each selection criteria window. How do these separate reports get combined into the report you're creating that actually uses these 'choose-from lists'? I appreciate any assistance. Thanks.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Mar 01, 2018 at 05:03 AM

    Hi Micheal,

    I've seen a few reports meant to work with SAP B1.

    The instruction about creating 'a blank report for each selection window' is actually supposed to be done in the same report.

    For example, when you run the report inside SAP B1 and you wanted a prompt screen that looked like the screenshot below:

    You would create a Parameter with the following settings:

    The list of values would be dynamic and the values would be generated using the query you type in the "Name" field.

    In this way, you're able to create various window styles and prompt selection UI screens that work only inside SAP B1!

    I hope ths makes sense.


    s1.png (6.7 kB)
    s2.png (34.5 kB)
    Add comment
    10|10000 characters needed characters exceeded

  • Feb 28, 2018 at 08:40 PM

    I tried to include pictures but they didn't take. Here are the examples from the How To guides' text.


    Where is there a "Choose From List" option available in the Value Options portion of the Crystal Reports parameter screen?


    1.jpg (30.3 kB)
    2.jpg (21.4 kB)
    3.jpg (36.0 kB)
    Add comment
    10|10000 characters needed characters exceeded