Zombi,

Glenn had two suggestions. The first doesn't seem to apply to you. The second is actually the same as option#3 I presented earlier. Option 3 is definitely easy...

Great question and even better follow up discussions. Thanks!

So you have 5 dropdowns instead of 2, but the basic question is still the same and some of the ideas I gave still apply. The most elegant and user-friendly...

So to paraphrase your question, you want to show two drop down boxes but you only need the user to select from one of the two? If that's the...

You haven't provided enough details for me to tell why you weren't getting any results but I see one error that should be corrected. From your original question, it...

It is definitely possible to display long legend text in SSRS 2008. (I can't speak for other versions though). Click and select the legend. Press 'F4' to display...

Would your query always return 5 rows or less? If so, there are some tricks you can implement in the SQL itself that guarantees that 5 rows are always...

Perhaps this might work for you:

Right click on the legend and select legend properties.

In the dialog that pops up, select "row" for layout and choose bottom for legend position. ...