Parameters

Question

Parameters

keywestfl9

SSCertifiable

Points: 5215
More actions
June 5, 2009 at 2:17 pm

#205657

i am creating a report with four parameter
Application name, region,type,server
i want to do in such a way the user can select
1. Application alone and all details should be displayed
2. application name and type
3.Server alone (it can be single or multiple server selection)
Please let me know how do i go about creating it.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004356 More actions · Answer 1

keywestfl9 (6/5/2009)
i am creating a report with four parameter
Application name, region,type,server
i want to do in such a way the user can select
1. Application alone and all details should be displayed
2. application name and type
3.Server alone (it can be single or multiple server selection)
Please let me know how do i go about creating it.

What do you want done with Region?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

keywestfl9 SSCertifiable Points: 5215 More actions · Answer 2

keywestfl9

SSCertifiable

Points: 5215

June 5, 2009 at 10:28 pm

#1005631

region will also be a parameter

Jeff Moden SSC Guru Points: 1004356 More actions · Answer 3

keywestfl9 (6/5/2009)
region will also be a parameter

Heh... I knew that. What do you want done with it? You didn't list it in any of the conditions you've laid out so far.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

keywestfl9 SSCertifiable Points: 5215 More actions · Answer 4

i would like to know how to use if or case statement in SSRS dataset.

if the user selects application name alone then

i need select * from table where applname = ""

if the user selects application name and region

i need select statement where clause to be changed

i want where clause to be dynamic based on the user selecting the parameter.