• Have you thought of storing the parameter values in a parameter table? This will decrease your query/refresh time. Even with parameters that rely on other parameters.

    All of my parameters are refreshed with new values from the database nightly and are pulled from a parameter table with the basic values of ParameterName, ParameterLabel, ParameterValue. This has really increased the performance and refresh time on reports.

    Sabrina