Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Creating detail order numbers
Message
 
À
23/06/2005 13:30:30
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Divers
Thread ID:
01025845
Message ID:
01025947
Vues:
19
I'll remeber that ;o))))

>IT WORKS!
>
>Well, Thanks VERY VERY MUCH, this is very usefull for me!
>
>You can have a drink on my account!
>
>
>>>The solution you have given me works if I put it in Detail Band, but if I put it in Group Footer (which I also need) it doesn't work.
>>>
>>>Need help for that also.
>>>
>>>Thanks for helping on Detail band.
>>>
>>>>>How to make in report show of detail order number by data field?
>>>>>
>>>>>I want to show by every detail field his number by order: 1. 2. 3. 4. 5....
>>>>>
>>>>>I have tried RECNO() to add to field but that doesnt work beacuse there are deleted records in table so it skip some number (1,2,3,5,6,9...) and i want it because I need in groups to show that order number which is again useless with RECNO().
>>>>
>>>>Put a variable in report, Calculate->Sum, Initial Value = 0, Value to Store ->1, Reset At -> Choose the group., Put this variable to print at the beging of the Detaile band row.
>>
>>For Group sequence:
>>Add a new variable named GroupSeq, Calculate->Sum, Initial Value = 1
>>
>>DoubleClick on Group Footer Then in OnExit even put:
>>
>>_VFP.SetVar("GroupSeq",GroupSeq+1)
>>
>>then print this variable in each group
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform