Hi Gnana,
A parameterized view is just a cursor with a WHERE clause that changes. When you run the SQL for the report, store the value (cusomer ID, primary key, etc.) to a variable and use a WHERE clause in the SQL.
MyID = customer.CustID
SELECT customer.* from Customer WHERE customer.custid = MyID
This picks the CustID for the active customer record each time you run the report.
HTH
Barbara
>Hi Barbara,
>
>I am new to foxpro. If I use a cursor for the report How can I dynamically change the values in the where clause of the mycursor.(Like in parametised view).Actually I want to run my report from my form
>
>Thanks for your timely help.
>Gnana.