• I have a similar report where the datasets and report format are exactly the same but 6 stored procs are called.

    I created a non-queried report parameter where the parameter value is the stored proc name. Then in my dataset query I use an expression to construct the call to the stored proc selected in the parameter. Something like

    ="EXEC MyDatabase.dbo." & Parameters!MySprocParam.Value

    In this way I can use one RDL instead of 6.