Hi!
Your report probably have some tables in the data environment. Remove them all, because report will use them instead of current alias.
As about dynamic grid creation, see FAQ section at the
http://tek-tips.com site for VFP forum where I posted a sample code. I will post it here too, but it will not appear immediately.
>thanks for the help I tried to this syntax
>
>select * ..... into curs mycurs
>select mycurs
>repo form report01.frx prev
>
>it runs but report shows all records not shows where clause eg. where iq<=25
>
>how can create grid after the query for exp. I have a form and there is 1-2 combobox,1 commandbutton for the query syntax after I selected my criteria
>ý wantto push command button the query results will come to new created grid on the form .. would you like write the syntax for this (for command button contain)
>
>thanks
>Kosta
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.