Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Lines in report like Excel
Message
De
09/03/2016 01:29:34
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Allemagne
 
 
À
08/03/2016 17:29:11
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:
01632704
Vues:
46
>Thanks, Lutz - it is attached...

John,

see attached.

The table does not match te report. It fails with mTech, todaysdate.

for anything else the report works as expected. The address increases as it is to large sometimes, story does not.
You can alter this in the properties on the field there is a checkbox Stretch with overflow on the first page.

The line below the fields in the detail band needs to be closer to the fields and set to Fix relative to bottom of band , so it will follow the stretch of address.

For propper alignment the horizontal line is hidden under the detail band This is a design problem of the report builder. You can mark by blindly drawing a rectangle with the mouse and unselecting any texbox accidently selected by this. (Shift+LeftClick adds ore removes items from selection)

As recomended I have set the grid to pixels.This is better understandable then inches that come in decimal fractions. If you move the line up and down, you might see bottom going into negative. The propper position of the line is on pixel above negative. You can not move the detail band bar and move it back, this will make the detail bar one pixel higher. This is a problem in the builder.

Use the Layout Toolbar to align items.

What I see too:

you have fields named Time_A, Time_B, Exp_12. This looks like the result of a badly created SELECT SQL.

Consider to use
SELECT Cur1.SomeTime AS MeaningfullFieldName,Cur1.PoNum,SUM(Cur1.Numeric) AS Other_MeaningfullFieldName;
FROM YourTable AS Cur1

The AS on the fields / expressions allow to have consistent field names in the result, while the alias in the FROM clause allows the replacement of YourTable by variable name like FROM (cVariableTable) AS Cur1. This might be no problem in your approach, but if the world becomes more complex it is good to be used to this behaviour. As soon as you use subselects it's unavoidable.

If todaysdate shows the date of the current day, what's wrong with simple DATE()?
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform