Hi All, I have a cube based report with few parameters as drop-downs. Few of them are very small data-sets like Gender, date etc. There is an other parameters which has a drop-down of around 10,000 values and it's taking huge amount of time to show the dropdown while executing the report. Is this an usual thing for SSRS or is there any solution to this? Any help is very much appreciated. Thanks, Kambala

I believe Cumulative Update has a fix for this problem - http://support.microsoft.com/kb/2507770

When you start using cube, you should go for SSAS. SSRS will surely take hell like time.Regards, Amey

When you start using cube, you should go for SSAS. SSRS will surely take hell like time.Regards, Amey

I think using 10,000 values in the dropdown list is not a good idea since this is not user friendly. For example, users want to select some values in the drop down list, they have to check the values in 10000values. I think it is better to use like function which may not exist in MDX. However, you can use Contains Operator which works similar to Like operator. You still want to display in drop down list then you can use cascading between the parameters and Default the parameter values. For instance, Branch Numbers Dallas 1201 Dallas 1202 If you cascade Numbers parameter with Branch and Defaulting Branch value to Dallas then it won't show all the Branches details.This results less time to populate parameters. Let me know if you don't understand anything. Thanks Tarak.

Hi Kambala, Ideally you would not want to display 10,000 values in a dropdown because it is going to be very difficult for the user to browse through that list and get the appropriate one. A workaround would be to use cascading parameters. For eg, if you have a dropdown for accounts (maybe 60,000 in number), you could also have a few cascading parameters before that like Country, State, City. So once you select a specific country, state and city, the number of accounts might be just 20 or 30. Cheers, Jason P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :)