The part of vis studio you need comes on the SQL Disk from 2005 onwards.. BIDS is what you need (business intelligence development studio). If your looking to simplify things for users you can have drop down boxes with parameters. Report models may also be worth looking at if you have this software