Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Several problems trying to create report from SQL
Message
 
 
To
27/08/1998 17:01:08
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00130680
Message ID:
00130809
Views:
21
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.
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform