>>>>>>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
>
>I could use the default datasession on the report, but the form that it prints from uses a private datasession, and must stay that way, because the program allows the user to open multiple instances of the for... what I was hoping for was a way to pass the parameter to the report. I suppose that I could save my view with a different name and remove the parameter in the view itself, and then REPORT FORM for parameter = value. This would quickly make the number of my views explode, however, because I have a lot of forms that display the data from a view in which I want to put a print button to allow the user to print the data on the screen in a formatted report.

OK Erik, here's my last shot. In the BeforeOpenTables event, issue a SET DATASESSION TO (_Screen.MyForm.DataSessionID). I guess that will mean that as long as the form is a member of _SCREEN, then you won't have to declare anything public. Don't put any tables in the report's data environment.

NOW, you should be able to use Ed's idea.

HTH.