>>>I'm using an SQL cursor (based on 3 tables in my DBC) to create fields for my report. After I create the cursor I have a Default data session with my desired cursor "Rptdata", plus all the original tables.
>>>
>>>1) The first and biggest problem is that as soon as I click on Quick Report I get an "Error instantiating cursor object \.tmp". It doesn't refer to my cursor name (Rptdata), but the temp file name. I was puzzled by this. In addition, it is looking for this tmp file in the directory in which I run the cursor (my data directory). I thought the problem was that my temporary directory was someplace else, so just tried to tell the report where the file was. I looked for it in my temporary directory, but couldn't find a match to the file name for which it's looking. The fields and headers from my cursor are added to the report layout, but I kept getting this error message when I tried to do other things and eventually get booted out of VFP altogether.
>>>
>>>2) In my cursor, I SELECT as "First", instead of "First Name", which is what I really want for my page header column. I know I could edit this after the fact. Is there a way to include it in the SQL or otherwise grab the captions from the DBC for column purposes in the report designer?
>>>
>>>3) This is related to 2. Several of my column headers are truncated to the field size of the corresponding field. Is this expected behavior? For example, my middle initial field is 2 characters. However in my cursor I selected pe_middlei AS MIDDLE. But what I ended up with as a header was MID.
>>>
>>>TIA for any help on these problem.
>>>
>>>Sylvia
>>>
>>>Thanks
>>
>>Basically, most people don't use Quick Report/Form/Table and other 'quick' builders. Creating report form from scratch you will get all things done orderly and knowingly.
>
>Ed -
>
>The reason I decided to try this method was based on a thread from several months ago in which it was suggested that it was possible and several people were actually using an SQL select cursor as a data source. However, some of the details are (obviously) not working out for me.
>
>Sylvia

That's true, it's common way to base report on cursor. I just said, that it's not common way to use 'Quick Report' builder.

Edward Pikman
Independent Consultant