>David -

I had left the Add Alias and Add to DE checkboxes selected when I chose the Quick Report, so unchecked those, and this time did not get the error, so thank you.

In answer to your question, I was just creating a temporary cursor as opposed to a view. Now I'm wondering if I should create a view for the report. Would there be an advantage to doing this over a temporary table (the ability to use parameterized views perhaps)?

Also, do you have any advice on my problems 2 and 3?

Thanks again,

Sylvia

Sylvia,
>
>I use Quick report all the time to get the basic report laid out, Just make sure it's the currently selected alias when you go into the report designer. Also make sure you don't have Add Alias or or Add to DE selected when you do it.
>
>Are you using the View designer to create the view or using CREATE SQL VIEW in code?
>
>>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