>>
>>Usually you handle this kind of thing with parameterized views? Is that possible in this scenario.
>
>Yes but I do not understand how this would be any faster because you would have to do a requey() everytime you change the parameter right?

True but your not dealing with a filtered view of a table. Navigation and anlalization with a smaller subset of data is much quicker.