Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Reports, memo fields and next page
Message
 
 
To
30/05/2001 05:03:06
Minna Heikkilä
Pehmo Solutions Oy
Kuusamo, Finland
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00504139
Message ID:
00512620
Views:
13
>Thanks a lot! This helped me very much. There is only one problem. I don't know, how many variables I need in reports. Now I did 4 ( about 1000 characters) but I must do more. This is little problem! Thanks! :)

Minna,

Unfortunately, without pre-processing the whole file you can not say in advance, what's the maximum length of the Memo field (not empty part). You can not run a SQL statement to determine that. So you can either try your best guess, say, 10 parts, or scan the whole file. Still I think, that the memo will go to the next page (you can not put whole content on one page).

Basically, this idea is good for information, which is not always filled. For instance: Address1;Address2;State;ZipCode will print only not empty information.

I just got a vague idea, which you may try:
select padr(substr(Memo1,1000,254)) as part5, ..., as part10
select count(*), part10 from yourtable where part10<>space(254) group by part10
Check, if you have not empty part10, then you can check part9, then part8, etc.
Or you can start from part5, then part6, etc.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform