Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Reports, memo fields and next page
Message
 
 
À
30/05/2001 05:03:06
Minna Heikkilä
Pehmo Solutions Oy
Kuusamo, Finlande
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
00504139
Message ID:
00512620
Vues:
14
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform