>I have a report that I want to run from a command button on a screen form and I want it to be based on a cursor (curForPrint)that is created by a method called by the Init() of the screen form. The report has field controls whose control sources are the columns of the cursor (e.g.: curForPrint.field1) -- I can type those in. I also need to have the data groupings based on the columns of the cursor, but I can't figure out how to do that in the report designer.
>
>I have placed a test BROWSE after the creation of the cursor, so I know it is there and populated with the rows I need for the report. However, when I run the report preview there are no values shown.
>
>Any ideas?
>
>TIA
>
>Jim
Jim,
Might it be that report DE has a table in it ?
I would suggest not to use DE of report nor alias the fields. Get your data in cursor and report from there. You could do somthing like this :
select * from ... order by ... into cursor myCursor
if !file('myReport.frx')
create report myReport from (alias()) form
endif
modi report myReport
report form myReport ...
Not aliasing report fields make same report runnable with different cursors.
Cetin