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