Thursday, March 22, 2012

Dropdown won't show values if only one item is available

I have a report that has 2 dropdowns, selecting from the first dropdown populates the second one. This works fine in the BI Studio.

When I deploy this report to the 'Report Manager' and make a selection from the first dropdown, the second dropdown loads (as expected). I tried to select from the second dropdown (which has only 1 item - which is correct), the dropdown does not appear correctly - as in, I can't see that item.

Since we can't attach anything here, below is the link to a screenshot of my issue:
http://docs.google.com/View?docid=ddd6j2xn_52c5qd5

If you look closely at the screenshot from the link above, you'll see that there is a value in the second dropdown - it just won't show completely - as if the dropdown is not rendering correctly. I can view source on the page and see that the dropdown has a value.

What appears to be happening is the if only 1 item is in the second dropdown and that item is longer than the size of the dropdown, the dropdown won't render.

Here is my value for the second dropdown '012 Candy Gadler David Thapero'. This is the only value in the second dropdown. - You can try 35 chars or more in the dropdown to confirm.

Notes:
+ No special chars are in either dropdown
+ I am using IE 7 (Also had someone test this on IE 6 - same problem)
+ Using Visual Studio 2005 to build report - where this works fine

Work around:
+ If I add another item to the dropdown via a UNION query, I see the original value + the new item in the dropdown #2


Please share your thoughts
Thanks,
h.


Weird, because I cannot make that happen. I created two dropdowns with items that are each way longer than yours, the second one is dependent on the first and has only one item, and I don't get that scrollbar in the dropdown, the page just becomes wide enough for the dropdowns and I have to scroll the whole page across to see the second dropdown, but it displays fine. I tried it in Report Manager, then I tried it in the Report Viewer and there it also works although it looks a little different. Instead of the whole report getting wider, just the parameters section gets wider, so I have to scroll it, but again the dropdown is full width.

I'm using Reporting Services 2005 with SP1.

|||

SNMSDN ,

Are your parameters Multi-value? Try making them multi-value. Your assistance is appreciated.

|||

Haha - that's it, if it's multivalue I cannot see the single value either.

Someone from MS - we have a bug.

|||

It is a bug. Actually the value is there, but horizontal scrollbar took too much space, and completely covered it.

As far as I remember it was fixed in Sql Server 2005 SP1

|||Thanks SNMSDN for confirming this issue.|||Thank you Lev Semenets - MSFT for the fix.|||It isn't fixed in SP1, because I'm using SP1, hopefully in the SP2?|||Sorry, I was wrong. There is a QFE for this issue. And it will be fixed in SqlServer SP2

No comments:

Post a Comment