Skip to Content
avatar image
Former Member

Experts: How to disable maximum rows 500 for drop down boxes

Hi experts,

I am using multiple drop down boxes that have dynamic entry lists and influence each other. Lets say:

- Division

- Product (determined by Division)

- Customer (determined by Division and Product)

Now if my dashboard is start up the drop down box for customer only contains values between A... and K..... Customers that start with the letter L or higher are not shown. After choosing a division Customers starting with A... till P... are shown. After choosing a specific product all relevant Customers are shown.

What happens is that the drop down box looks at the output of the query that is underneed. If this query contains more than 500 rows only the first 500 rows are counted.

I would like to let the drop down box include all rows. How can I do this? For queries that are dragged to the storyboard it is possible to select the maximum rows. For queries that are used in a drop down box this is not possible.

Thanks in advance,

Ralph

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Jan 14, 2008 at 09:16 PM

    can any body propose a solution for this. I am also facing the same issues and trying to overcome this.

    -Aravind

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 14, 2008 at 10:33 PM

    Hi Ralph,

    check this Wiki entry:

    [https://www.sdn.sap.com/irj/sdn/wiki?path=/display/vc/savingchangesofquerysettingsfailed&|https://www.sdn.sap.com/irj/sdn/wiki?path=/display/vc/savingchangesofquerysettingsfailed&]

    I think it should be possible to modify the default setting of 500 records.

    You also should think about the usability, a dropdown with more than 500 records is not good, maybe a value help is the better solution.

    Best Regards,

    Marcel

    Add comment
    10|10000 characters needed characters exceeded