Sorting the values in parameter dropdowns in Report Builder

re: Sorting the values in parameter dropdowns in Report Builder

Derek Price — Thu, 29 Mar 2012 16:00:32 GMT

To fix this all you need to do is unhide the parameter that is not sorting properly, the only column should be a VALUE column. Add the SAME field to the data set, not touching anythign else, save the data set.

As long as you have the field Sorted in the reporting model properties the field will auto sort it self in the parameters drop down.

if you have questions feel free to email at: dp978@msn.com

re: Sorting the values in parameter dropdowns in Report Builder

Has there been an update for this to work with RB 3.0? — Wed, 12 Oct 2011 14:31:01 GMT

I'm trying to build it, but I can freely admit that these days my skills with Visual Studio are pretty limited to nothing much more than developing SSAS and SSIS packages. Is there a means to make this work simply with RB 3.0?

re: Sorting the values in parameter dropdowns in Report Builder

kelvinaston — Thu, 22 Apr 2010 15:31:00 GMT

Hi Bob,

I'm trying to implement your dropdown sorting code but haven't met with much success. I initally received Semantic query execution errors but managed to get around these by adding the IdbConnectionWrapper code from the updates to the original post. However, I'm not finding that anything is actually sorted. Are you aware of any other changes I may need to implement to get this working?

Thanks for any advice that you can offer, and for supplying the code.

Regards

Kelvin

re: Sorting the values in parameter dropdowns in Report Builder

KathyDavis — Fri, 10 Oct 2008 22:01:58 GMT

I implemented this custom data processing extension, but it only works sometimes! Any suggestions?

Thanks,

Kathy Davis

re: Sorting the values in parameter dropdowns in Report Builder

TheMilkMan — Fri, 25 Jan 2008 18:44:35 GMT

Hi,

Is the zip file correct? It seems to contain a SQLTimeoutDP assembly and not SQLReportModelDP as specified in the NewConfigEntries.txt file?

Thanks