How to filter data from a stored proc?

eomei

How do I filter data from a stored procedure? All I'm trying to do is use one stored procedure (instead of 4) and retrieve the rows for one location (instead of 4 locations). I've tried the data filter but I can't get it to work with a stored proc.
Thanks!

Virgil

Hi eomei,

If you are in control of the stored procedure, you could pass a parameter back to the procedure so you are not bringing back extra data.. otherwise, you could apply a filter on the table or chart where you are using the data.