• Are you trying to create a single dataset to use in your report? If so, it looks like you can union the results together.

    SELECT...

    FROM v_SomeView

    WHERE...

    UNION ALL

    SELECT...

    FROM v_SomeOtherView

    WHERE...

    and then just pass your params in all the WHERE clauses. (they would use the same parameters but map to the proper fields).

    Or did you mean return 3 distinct result sets?