sql server reporting services: Hiding Report Parameter UI - Still Using Parameters for Dynamic Column Sorting -- sql server reporting services

You're in the

sql server reporting services

group:

Hiding Report Parameter UI - Still Using Parameters for Dynamic Column Sorting

Re: Hiding Report Parameter UI - Still Using Parameters for Dynamic Column Sorting

Lev Semenets [MSFT]
8/18/2004 12:10:24 PM

sql server reporting services:

UI seems to be confusing. You could try to use my script:
http://blogs.msdn.com/levs/archive/2004/07/20.aspx

--
This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]

Hiding Report Parameter UI - Still Using Parameters for Dynamic Column Sorting

jrennard
8/18/2004 12:33:12 PM

Hello!

We are using a SortBy parameter and a Direction parameter for our report.
We are using dynamic sorting to allow the user to click on a column header
and sort that column. A click checks whether or not it is sorted asc or
desc and if it is, it changes the sorting to the direction it isn't
currently sorting. This functionality works perfect, but we do not want to
allow the users to sort using the parameter ui drop-down boxes. If we
removing the promt from the report designer it gives an error saying that
the parameter is read only and the report errors out. If we try to uncheck
the prompt box in report manager, it gives the same errors. We want to use
these parameters for sorting within the report, but we do not wish to have
the UI there as dropdowns. Is there a way to correct this? We appreciate
your help!

Re: Hiding Report Parameter UI - Still Using Parameters for Dynamic Column Sorting

jrennard
8/18/2004 2:58:39 PM

That worked great.

Exactly what I was looking for.

I do have another question. Do you have a script, or know of a script that
will remove duplicate values from a filter UI? We have a bunch of clients
and when we pull in query values for the filter to filter by client it
duplicates clients within the list because on the same query we have
multiple users that are associated with the same client. A script to remove
those duplicates would be very sweet. Let me know what you think. Thanks
again! Great script!

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.

home · blog · groups

Questions? Comments? Contact the dn