• My advise here is to build a more general stored procedure that brings in all the columns you need at a granular (lowest common factor) level. I assume you mean to create a SSRS report. When client one gets selected in the report parameter control for the client... you could assign it default values for the start day and other parameters. Although I've never done this it seems that it would use the functionality of cascading parameters.

    ----------------------------------------------------