Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

one parameter returning all,remining parameters also need to return ALL Expand / Collapse
Author
Message
Posted Monday, February 11, 2013 10:57 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, November 4, 2013 9:41 AM
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
Post #1418755
Posted Wednesday, May 1, 2013 11:01 AM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Saturday, March 19, 2016 1:53 AM
Points: 776, Visits: 1,556
Hi, are you using a stored procedure in your dataset definition or are you typing in the query directly?
Post #1448527
Posted Wednesday, May 1, 2013 10:35 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, June 20, 2016 9:37 PM
Points: 3,485, Visits: 3,002
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.




Post #1448682
Posted Thursday, May 2, 2013 12:07 PM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Saturday, March 19, 2016 1:53 AM
Points: 776, Visits: 1,556
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.
Post #1448941
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse