Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Lines in report like Excel
Message
De
09/03/2016 08:03:23
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Allemagne
 
 
À
09/03/2016 07:13:46
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01632674
Message ID:
01632718
Vues:
29
>Hi Lutz - thanks for the work...
>
>Please note that the whole thing isn't nearly complete, so there is still 'work in progress' untidiness. mTech, and todaysdate are two variables that carry the technicians name, and the date for the report, which will not always be date()
>
>I solved the issue by adding two extra fields to the temp cursor for address1 and address2, instead of a concatenated single address. I keep the single address for the grid on screen, but in the report, I use ad1 and ad2, and put 2 below 1 in the details band. This way even if 2 is empty, the spacing of each report line is the same. This way I can use boxes around everything to give the 'grid line' effect of Excel. I will surely remember the 'fix relative' for anytime I have this kind of hassle again.
>
>Thank you so much for your effort - really appreciated!
>
>Just above this 'subject' is another posting of mine having battles with the calendar on a form - if you would like to chip in, please do!
>
>Best!
>John

for your adress - to keep the line as small as possible try the following
asuming you have field Adress1 and Adress2, Adress two might be empty
now, on the report go to the single line adress field, stretch with overflow and in the expression enter: ALLTRIM(Adress1)+IIF(EMPTY(Adress2),'',0h0D0A+ALLTRIM(Adress2))
This will put adress2 on second line

See the example. It will put additional text (wrong text!) on every even record.
See also the line to create vertical line. Check the properties to see how it's resizing by it's own.
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord

Weeks of programming can save you hours of planning.

Off

There is no place like [::1]
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform