Skip to Content

Displaying multiple values in a single paramater

Please help im having a problem displaying all the values entered by a user.

This is the report im trying to do. The Qty field is the user input values. I manage to display the first value which is 1 but the second value is not showing correctly it should display 2.

Please help I am currently stuck in this problem

capture.png (5.3 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • Posted on Oct 12, 2018 at 01:46 PM

    When users enter multiple values in a parameter, they are stored in an array.

    How do you get the product names into the report? Are they hard-coded, based on another parameter, or are they coming from the data? The method you'll use for getting the correct values will vary depending on the answer to this.

    -Dell

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 14, 2018 at 05:32 AM

    The product names and other stuff in there are coming from a database and the qty field is the one im asking for the user end and display those data in the crystal report.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 14, 2018 at 07:56 AM

    How did you logically associate Qty = 2 with the second row?

    What happens when the database returns more rows?

    -Abhilash

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 16, 2018 at 08:04 AM

    You mean the user enter quantity in a parameter like 1,2,3,4 and you want to should it in quantity column like

    1

    2

    3

    4

    Is it your question?

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 22, 2018 at 05:26 PM

    One way would be to use a Dynamic parameter so it queries the DB for the values and then use a Range parameter so it allows users to select multiple values.

    range.jpg


    range.jpg (115.3 kB)
    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.