asked on

How to make available and default values of a parameter based upon the value of another parameter

My report is to display the CPU Activity Percentages of a server at different times. The user picks the start time and the duration of time to cover and a stored procedure gets the metrics for the report. I have two parameters, StartTime and Duration. I have a date picker for the Start Time and have available Durations from 10, 20 up to 120 minutes.

I want to limit durations that when added to the Start Time, will not produce a date beyond the present date/time.

I have the report in a rectangle that is not displayed whenever the user selects a date/time beyond Now().

But I am uncertain how to write the expression for the default and for the available times for the parameter, Duration.
serveractivity.png

ASKER CERTIFIED SOLUTION

D B

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Malinda Klein

ASKER

Is this where clause to follow the EXEC p_storedprocedure? Is it not possible to make the Duration parameter default value equal to 120 OR an expression that is equal to the difference between the @UTCStart and Now()? I thought maybe using an IIF it could be done but have not been able to do so errorfree.

SOLUTION

D B

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial