Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Setting Up Report Parameters, but using one parameter only to run the report Expand / Collapse
Author
Message
Posted Monday, May 14, 2012 8:14 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Today @ 8:54 AM
Points: 16, Visits: 72
Usually when you set-up multiple report parameters within a report, you need to make a selection in each paramter on the live report to ensure it runs...

Can you in any way set-up multiple parameters within a report, but you only need to make a selection in one parameter to run a report?

I want to set-up mutliple parameters for the user to choose from, but i want the user to be able to just select one parameter and still have the ability to run the report?

Thanks

Post #1299588
Posted Monday, May 14, 2012 10:18 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, May 14, 2014 3:48 AM
Points: 92, Visits: 201
Hi, this sounds like you need parameter defaults?
Post #1299697
Posted Monday, May 14, 2012 10:19 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Today @ 8:54 AM
Points: 16, Visits: 72
I have solved my problem, but added in the defaults to make it work...thanks for the reply..
Post #1299700
Posted Thursday, August 8, 2013 12:01 PM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, July 17, 2014 3:41 PM
Points: 522, Visits: 234
Hi,

You may use cascading parameters also, if your default values should change based on the main parameter values.

Thanks.
Post #1482507
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse