>Sylvia,
>
>
>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.>
>Good we are making some headway. *s*
>
>
>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?>
>#2 - well the report designer isn't OO yet so you can't easily manipulate it at design time. You could write a little program that would open the report as a table and change the label record fields based on the return value of DBGetProp(). On my website is some code that copies properties from a table to a view that should give you some ideas on how to structure the code.
>
>#3 - no good ideas on this, other than to write your own little QuickReport builder (it wouldn't be all that hard to do). Goto
www.foxgang.com and check Markus Egger's GenRepoX utility maybe it fixes some of this.
>
>
>>>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.David -
Thanks for the suggestion on DBGETPROP(). I've done some work with this, and am getting more comfortable with it, so will consider your suggestions. Also thanks for the tip on GenRepoX. I'll check out that website.
I gather when you say that the Report Designer isn't OOP compliant, that means in VFP 6.0 as well (do you think that will change at some point?).
Sylvia
