I can see maybe using a hidden report parameter or a report variable, but how to I change it on the fly. in expressions can you execute more then one statement?
or am I going to have to do something like custom code
=Code.CallMyStoredProcedure(1)
if so what would CallMyStoredProcedure look like and where does it go?