parameters parmaeters...

Hi all,
did a search on parameters and could not find the answer to my ask, so here
goes..
I have a report that runs on a SP. Originally, the SP had only one
parameter (ID). The main report, however has and should prompt for 3
additional parameters -- (ShowThis..Yes/No, ShowThat..Yes/No,
ShowOther..Yes/No). The report is broken out into lists (bands) that utilize
7 additional datasets. Thay are not one within the other(s), but laid out
sequentially down the report body - depending on the 'Show' parm values,
certain bands -or lists- will be shown or not. All data(sets) are run and
all data is returned to the report.
I have a SP that I have set up for a dataset that returns the available
values for the 'Show' parameters - values are Yes and No. I have default
values set up for the 'Show' parameters ( ="No" ). The problem is that I
cannot get the report to prompt me for the show partameters. The boxes are
greyed out and I have no option of making a selection...The main parameter,
ID, also has a default value and a dataset that returns available values -
once I select an available ID, the Show parms are enabled, use the default
value and the report runs. I thought that maybe this was happening because
the 'Show' parms were not included in the SP, so I added them to the SP and
made the link from the dataset parm to the report parm - no change. I feel
like I'm missing something right in front of my face - what do I have to do
so the user can make these 'Show' selections?
thanks,What is happening is that the system thinks your other parameters are
cascading (it is possible to have one parameter dependent on another). That
is why it is greying it out. Although your default is working when you put
an equal sign this means it expects an expression. An expression can refere
to other parameters and that is why it thought it was cascading. Instead of
doing the default this way:
= "No"
Just put this in (no quote marks)
No
This is like what you can do with a textbox. You can put in the text like a
tile
This is the title of my report
Or you can have an expression
="My Report with a date range of: " & Parameters!Startdate.value & " - " &
Parameters!Enddate.value
It definitely is not clear on how you put in defaults.
One other point, if all parameters have defaults then the report runs
immediately without waiting for the View button to be pressed. If you want
to wait until user decides then you need to leave one parameter without a
default.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Myles" <Myles@.discussions.microsoft.com> wrote in message
news:67790BA2-8213-4568-866F-2CEFEF356A2C@.microsoft.com...
> Hi all,
> did a search on parameters and could not find the answer to my ask, so
> here
> goes..
> I have a report that runs on a SP. Originally, the SP had only one
> parameter (ID). The main report, however has and should prompt for 3
> additional parameters -- (ShowThis..Yes/No, ShowThat..Yes/No,
> ShowOther..Yes/No). The report is broken out into lists (bands) that
> utilize
> 7 additional datasets. Thay are not one within the other(s), but laid out
> sequentially down the report body - depending on the 'Show' parm values,
> certain bands -or lists- will be shown or not. All data(sets) are run and
> all data is returned to the report.
> I have a SP that I have set up for a dataset that returns the available
> values for the 'Show' parameters - values are Yes and No. I have default
> values set up for the 'Show' parameters ( ="No" ). The problem is that I
> cannot get the report to prompt me for the show partameters. The boxes
> are
> greyed out and I have no option of making a selection...The main
> parameter,
> ID, also has a default value and a dataset that returns available values -
> once I select an available ID, the Show parms are enabled, use the default
> value and the report runs. I thought that maybe this was happening
> because
> the 'Show' parms were not included in the SP, so I added them to the SP
> and
> made the link from the dataset parm to the report parm - no change. I
> feel
> like I'm missing something right in front of my face - what do I have to
> do
> so the user can make these 'Show' selections?
> thanks,
>|||Thank you Bruce,
I knew it was something simple I was overlooking...a fella can only look at
this stuff for so long!
"Bruce L-C [MVP]" wrote:
> What is happening is that the system thinks your other parameters are
> cascading (it is possible to have one parameter dependent on another). That
> is why it is greying it out. Although your default is working when you put
> an equal sign this means it expects an expression. An expression can refere
> to other parameters and that is why it thought it was cascading. Instead of
> doing the default this way:
> = "No"
> Just put this in (no quote marks)
> No
> This is like what you can do with a textbox. You can put in the text like a
> tile
> This is the title of my report
> Or you can have an expression
> ="My Report with a date range of: " & Parameters!Startdate.value & " - " &
> Parameters!Enddate.value
> It definitely is not clear on how you put in defaults.
> One other point, if all parameters have defaults then the report runs
> immediately without waiting for the View button to be pressed. If you want
> to wait until user decides then you need to leave one parameter without a
> default.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Myles" <Myles@.discussions.microsoft.com> wrote in message
> news:67790BA2-8213-4568-866F-2CEFEF356A2C@.microsoft.com...
> > Hi all,
> >
> > did a search on parameters and could not find the answer to my ask, so
> > here
> > goes..
> >
> > I have a report that runs on a SP. Originally, the SP had only one
> > parameter (ID). The main report, however has and should prompt for 3
> > additional parameters -- (ShowThis..Yes/No, ShowThat..Yes/No,
> > ShowOther..Yes/No). The report is broken out into lists (bands) that
> > utilize
> > 7 additional datasets. Thay are not one within the other(s), but laid out
> > sequentially down the report body - depending on the 'Show' parm values,
> > certain bands -or lists- will be shown or not. All data(sets) are run and
> > all data is returned to the report.
> >
> > I have a SP that I have set up for a dataset that returns the available
> > values for the 'Show' parameters - values are Yes and No. I have default
> > values set up for the 'Show' parameters ( ="No" ). The problem is that I
> > cannot get the report to prompt me for the show partameters. The boxes
> > are
> > greyed out and I have no option of making a selection...The main
> > parameter,
> > ID, also has a default value and a dataset that returns available values -
> > once I select an available ID, the Show parms are enabled, use the default
> > value and the report runs. I thought that maybe this was happening
> > because
> > the 'Show' parms were not included in the SP, so I added them to the SP
> > and
> > made the link from the dataset parm to the report parm - no change. I
> > feel
> > like I'm missing something right in front of my face - what do I have to
> > do
> > so the user can make these 'Show' selections?
> >
> > thanks,
> >
> >
>
>