Pass parameters to a view from a calling stored procedure

[Mirak]

Hi,

How can I pass optional parameters to a view when it is called from a stored procedure. Basically I want the recordset from the view to be filtered based on criteria requested by the calling procedure. I do not want the view to return records that are not needed for my report. Furthermore, the view will be used in another view to produce records for the report eventually...The report will be designed in MS Access. Basically I already designed all the queries needed to run the report in MS Access, but with a view to optimize the use of bandwidth on our WAN, I am converting all our queries to views and stored procedures to be executed on the Server. As is commonly known, sometimes you need to create quite a number of queries to generate reports. I am now tasked with the duty of converting all these queries to stored procedures and views when applicable. Please for urgent assistance.

 

[donutman]

Views can't have parameters, but there is a kludge solution. Have the stored procedure update a table with just the parameter information. Then write the view and have it access the parameter through that table.
-Karl