>>>>How wuold I go about basing a report on a parameterized view? Is it possible without using a public variable? ie- can I pass the paramater by value to the report?
>>>
>>>It's actually local variable:
>>>
>>>***cmdRunreport click event
>>>local nViewparameter
>>>nViewparameter=....
>>>Select view1
>>>=requery()
>>>Report Form ....
>>
>>Erik,
>>
>>Can I assume that you want this to be a 'standalone report' with the view in the report's DE? If so, what if you put code in the DE's Init to prompt the user for the parameter(s) and then add the view to the DE using the parameters you collected..
>>
>>HTH
>
>No can do. Tables in question use surrogate keys that the user would have no idea about.

In that case, use Ed's idea with the Default DS