Report from a cursor

[tommy99]

Hi !
Is it possible to design and show the records in Report Design from a Cursor instead of a Table or View ?
IF I require to show some additional information in the Report design which are available in some Memory variables, is there any way of displaying the same in the report other than declaring them as Public variable and then placing them in the report design ?

Thanks in advance

 

[craigsboyd]

Yes you can run a report off of a cursor...a cursor is really just a temporary table. In fact certain types of cursors actually exist on the harddrive (NOFILTER and READWRITE) while they are being used.

Yes you can define report variables and you can also reference properties on a particular form or of the _screen in a report. The forms need to be referenced by a variable that is in scope or accessed through the _screen.forms collection or the activeform property of the _screen.

_{craig1442@mchsi.com}

"Whom computers would destroy, they must first drive mad." - Anon​

 

[tommy99]

>Yes you can run a report off of a cursor...a cursor is >really just a temporary table. In fact certain types of >cursors actually exist on the harddrive (NOFILTER and >READWRITE) while they are being used.

Thank you for your answers.

Then how can I select the Fields from this Cursor while designing this report. In the Data Envirnoment window, I can only select a table or view and this cursor does not appear there in that Select Table window.

 

[craigsboyd]

just type them in manually in the expression textbox of the fields on the report...or you can create the cursor in VFP and leave it open and selected in the datasession and then design your report and fields will show.

_{craig1442@mchsi.com}

"Whom computers would destroy, they must first drive mad." - Anon​

 

[tommy99]

Thanks a lot.