I have been given the task of converting our current 8.5 reports to XI. this seemed like an easy task however I am finding it's not quite as simple as I planned. I need most of my parameters to be dynamic and cascading based of a "company" selection. The idea behind this one is that I hit some pretty heavy duty tables and oringinally it was thought we could just use a bunch of stored procedures....finding that it's not that easy. So would my next best thing to be to create views? I'm pretty new to this so any assitance would be great!

What my goal is that right now each report has 2-3 tables but those same tables are used for several different reports, so in theory I want to create a view that will run multiple reports. So from what your saying this should be more effiencent correct?

Ok that's what I had hoped...I have been banging my head on my desk with these cascading parameters....our developers wanted each of the parameters to run off stored procs and that just wasn't working and from what I see in alot of forums is that views are the way to go..... thank you so much!

It's a judgment call for each report. If you have to process a ton of data, look to make it more efficient from the very beginning with Views or SPs. If it's a small amount of data, they just use tables to make things easier on you. If it seems like the report is taking too long to print, look for other optimization tricks and play around with it.