• The 'wrapping' seems to work okay:

    CREATE PROCEDURE Proc_Report AS

    EXEC Proc_Product

    Obviously they aren't called that but you get the idea - the Proc_Product has about 5-6 parameters, by doing it this way if we change what we show on our products and hence change the defaults the report should pull them through automatically.

    I didn't really want to create an additional SP but it's not like I've had to create 40 more or something.