Groups | Blog | Home
all groups > sql server reporting services > september 2004 >

sql server reporting services : Parameter drop-down


Danno
9/16/2004 4:53:03 PM
I've got two reports that are almost identical. They both allow clicking on
the column headers to sort the report so there is a parameter called SortBy
which appears as a drop-down list of fields that are available for sorting.
Both reports have the same default value defined for this parameter because
they both use the same datasource, however, one report shows this default
value in the drop-down list by default, the other report shows <Select a
Value> and the user must select a value before the report can be generated.
Any ideas? I've even compared the .rdl files and they appear identical with
regards to this parameter.

Help, I'm losing it over this one.

Danno
9/17/2004 9:26:53 AM
Never mind, I fixed it. I just deleted the report in Report Manager and
re-added it and now it works....go figure.

To allow column-header clicking, check out this sample:

http://www.gotdotnet.com/Community/UserSamples/Details.aspx?SampleGuid=6a347b53-5594-40f9-861d-876beabeda16

[quoted text, click to view]
Matt
9/17/2004 12:42:23 PM
Hi Danno,

perhaps you need a second pair of eyes. I assume you have set up values as
Non-Queried and that the Value in the list that you want as the default is
exactly the same (case and all) as what you have set as your default value -
a space or a capital in the odd place may throw it off - I'm not sure how
exact this has to be.

A question of my own, if I may, how do you set up the report such that the
user can sort by a column by clicking on the column header?

thanks

Matt


[quoted text, click to view]

AddThis Social Bookmark Button