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

Do not apply specific parameter Expand / Collapse
Author
Message
Posted Friday, June 14, 2013 8:28 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, December 24, 2013 4:56 AM
Points: 178, Visits: 668

Hi geniuses,

I'm looking to create a report with 3 parameters (Area, Location and Field) - 3 persectives - Main View, Middle View and Small View.
The report must able the user to only use the Area parameter to have a Main perspective of the data, and not imperatively use the other 2 parameters.
If he wants to analize the data on a Middle perspective, then the user uses the Area Parameter which filters the Location parameter, and let the Field parameter blank.

The problem here is that all the parameters must have a value, i can't just not use the param and run the report based on only one or two param, when there's at least 3.

Any similar experience?
Thanks in advance.
Post #1463606
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse