>>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
Matt McDonnell
...building a better mousetrap with moldy cheese...