Report Parameters

Hi,
Is it possible to have report parameter of string type displayed as a text
box instead of dropdown ? This will enable the user to type-in the parameter
value rather than choosing one. I have one more question. Is report
parameter of type String always displayed as a drop down list ? Can I have
checkboxes as report parameters ? These question are very basic. Iam new to
SSRS. Please provide help.
Thanks,
RKOn Oct 17, 5:48 am, "S V Ramakrishna"
<ramakrishna.seeth...@.translogicsys.com> wrote:
> Hi,
> Is it possible to have report parameter of string type displayed as a text
> box instead of dropdown ? This will enable the user to type-in the parameter
> value rather than choosing one. I have one more question. Is report
> parameter of type String always displayed as a drop down list ? Can I have
> checkboxes as report parameters ? These question are very basic. Iam new to
> SSRS. Please provide help.
> Thanks,
> RK
Regardless of datatype, anytime you provide a choice of available
values, whether non-queried or queried, you'll be presented with the
drop down. The drop down is the only option for displaying available
values. The only time you'll see checkboxes is if you select the
Multi-Value option and even then the checkboxes appear by way of the
drop down.
If you want your users to enter the parameter value in a text box, you
will not be able to offer available values. There is a slight caveat
to my last statement. You can use the prompt to suggest potential
values to be entered into the text box. For example, you could have
your prompt read, "Enter one of the following values: Yes; No; Maybe."
HTH

Report parameter dropdown

Hello,

I need to create a MyPar parameter dropdown list, that is why I created a new dataset that gets data through a stored procedure. I also add @.MyPar into the query string of MyMainDataSet . I defined this parameter in Parameter screen for both available and default values.

When I run the report, I get the following error.

Query execution failed for data set MyMainDataSet.

Must declare the variable @.MyPar

What is problem?

Hello:

If I understand correctly:
The first stored procedure that displays the parameters for MyPar is a straight SQL Select Statement - So this SQL Select just gets the data for the available parameters to display in the dropdown list.
The next step the user selects one value from all of the available parameters in the dropdown list - so once this parameter is selected you need to pass this selected parameter to your next SQL Select statement so you only get the data based on the parameter the user selected!
Include the following in the Stored Procedure (if your are using one for the selection of data based on the parameter the user selected)
CREATE PROCEDURE "Whatever the Procedure name is"
@.MyPar nvarchar(10) or whatever length the parameter is

-- SETUP RUNTIME OPTIONS / DECLARE VARIABLES --
set nocount on

Hope this helps!
Best Regards - Joe

Report parameter dropdown

I bound a report parameter to a combobox. I tried to configure default
parameter as null several ways
in report parameters properties dialog but could not.
How can i specify default value of null for a combobox parameter? thxOn Apr 17, 2:09 pm, "nkg" <x...@.yahoo.com> wrote:
> I bound a report parameter to a combobox. I tried to configure default
> parameter as null several ways
> in report parameters properties dialog but could not.
> How can i specify default value of null for a combobox parameter? thx
If the default value of null does not work in the Report Parameters
dialog, I would suggest unioning your dataset against an empty/null
record and then use a default of the dataset and make sure that the
empty/null value is listed first. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||thx!
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1176856481.241478.187380@.b58g2000hsg.googlegroups.com...
> On Apr 17, 2:09 pm, "nkg" <x...@.yahoo.com> wrote:
>> I bound a report parameter to a combobox. I tried to configure default
>> parameter as null several ways
>> in report parameters properties dialog but could not.
>> How can i specify default value of null for a combobox parameter? thx
>
> If the default value of null does not work in the Report Parameters
> dialog, I would suggest unioning your dataset against an empty/null
> record and then use a default of the dataset and make sure that the
> empty/null value is listed first. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||On Apr 18, 1:51 pm, "nkg" <x...@.yahoo.com> wrote:
> thx!"EMartinez" <emartinez...@.gmail.com> wrote in message
> news:1176856481.241478.187380@.b58g2000hsg.googlegroups.com...
> > On Apr 17, 2:09 pm, "nkg" <x...@.yahoo.com> wrote:
> >> I bound a report parameter to a combobox. I tried to configure default
> >> parameter as null several ways
> >> in report parameters properties dialog but could not.
> >> How can i specify default value of null for a combobox parameter? thx
> > If the default value of null does not work in the Report Parameters
> > dialog, I would suggest unioning your dataset against an empty/null
> > record and then use a default of the dataset and make sure that the
> > empty/null value is listed first. Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
You're welcome. Let me know if I can be of further assistance.
Regards,
Enrique Martinez
Sr. Software Consultant|||"EMartinez" wrote:
> On Apr 18, 1:51 pm, "nkg" <x...@.yahoo.com> wrote:
> > thx!"EMartinez" <emartinez...@.gmail.com> wrote in message
> >
> > news:1176856481.241478.187380@.b58g2000hsg.googlegroups.com...
> >
> > > On Apr 17, 2:09 pm, "nkg" <x...@.yahoo.com> wrote:
> > >> I bound a report parameter to a combobox. I tried to configure default
> > >> parameter as null several ways
> > >> in report parameters properties dialog but could not.
> >
> > >> How can i specify default value of null for a combobox parameter? thx
> >
> > > If the default value of null does not work in the Report Parameters
> > > dialog, I would suggest unioning your dataset against an empty/null
> > > record and then use a default of the dataset and make sure that the
> > > empty/null value is listed first. Hope this helps.
> >
> > > Regards,
> >
> > > Enrique Martinez
> > > Sr. Software Consultant
>
> You're welcome. Let me know if I can be of further assistance.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>
Instead of modifying my datasource, I chose to change the parameter. A small
function injects the null value into the selected list before filtering my
data.
here's how :
http://pderop.blogspot.com/2007/05/ssrs-multivalue-and-nulls.html
cheers