Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


one parameter returning all,remining parameters also need to return ALL


one parameter returning all,remining parameters also need to return ALL

Author
Message
Arjun123
Arjun123
Grasshopper
Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)

Group: General Forum Members
Points: 20 Visits: 201
i have 6 parameters ,in this 4th parameter returns "ALL" 5th and 6th also in need to return all
5,6 have available values, where i have to write expression

Regards
Arjun
MMartin1
MMartin1
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1102 Visits: 2014
Hi, are you using a stored procedure in your dataset definition or are you typing in the query directly?

----------------------------------------------------
How to post forum questions to get the best help
happycat59
happycat59
Hall of Fame
Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)

Group: General Forum Members
Points: 3565 Visits: 3107
This sounds like you want to make the value(s) available in param 5 and 6 dependent on the values selected in param 4 - is this correct ?
i.e. if you select "all" in param 4, then either show "all" and nothing else in param 5 and 6 OR show "all" as well as other values in param 5 and 6. If "all" is not selected in param 4, then show everything except all in param 5 and 6.

To do this sort of thing, I would create datasets for param 5 and for param 6 - these datasets would be used to populate the available values for param 5 and param 6. Each of these datasets would have the value selected in param 4 as a parameter to the dataset. Using that parameter, the logic for returning the "all" value can be made conditional on whether has been selected in param 4.



MMartin1
MMartin1
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1102 Visits: 2014
Yeah, he could be implying cascading parameters. It is just not clear (beyond a reasonable doubt) from the post itself.

In SSRS 2005 I notice stored procedures in the dataset do not produce the ALL option as an "array" item to a paramater when that parameter is a multi-value one and has its available values tied to a dataset. Hard coding the dataset in the report does. For instance,

SELECT customerName form Customer

will show the individual customers and the ALL option in the drop down for the corresponding multi-value report parameter.

----------------------------------------------------
How to post forum questions to get the best help
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search