Parameter drop-down

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.
Thanks in advance.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
"Danno" <Danno@.discussions.microsoft.com> wrote in message
news:CF5CB8D2-56A1-4C85-ADCF-AEBF6F53715B@.microsoft.com...
> 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.
> Thanks in advance.|||Thanks Danno,
Bit disappointing that it requires two reports to achieve this.
regards
Matt
"Danno" <Danno@.discussions.microsoft.com> wrote in message
news:D320BE8F-0F79-4BBA-90E6-97174E704B09@.microsoft.com...
> 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
> "Matt" wrote:
> > 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
> >
> >
> > "Danno" <Danno@.discussions.microsoft.com> wrote in message
> > news:CF5CB8D2-56A1-4C85-ADCF-AEBF6F53715B@.microsoft.com...
> > > 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.
> > >
> > > Thanks in advance.
> >
> >
> >|||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
"Matt" wrote:
> 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
>
> "Danno" <Danno@.discussions.microsoft.com> wrote in message
> news:CF5CB8D2-56A1-4C85-ADCF-AEBF6F53715B@.microsoft.com...
> > 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.
> >
> > Thanks in advance.
>
>