Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Bullet list in VFP Report
Message
De
03/02/2016 14:55:43
 
 
À
03/02/2016 14:17:33
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 10
Divers
Thread ID:
01630437
Message ID:
01630727
Vues:
132
Hi Yousfi,

The problem is not how to show a bullet, you can select any nice sign from Wingdings, so I selected Wingdings-q for the bullet. The problem is 'how to create a bullet list in a VFP report, where the options - or text parts of each individual bullets may span more than one row. Thus the next bullet will not allign with the next text part.
See picture attached.
A solution would be to create a detailband in which only one bullet, this is OK, however it would only work for one bullet list in one report, I need to have n-Lists in my report.
Since the business rule states maximum of 3 options per list, I created 4 Detailbands:
Band 1 the listheading
Band 2 till 4 the individual 'bullets'
Works fine, however impossible to secure the 4 detailbands donot span a page which makes the whole thing ugly and unusable.

For your info, this is a questionnaire with maximum 3 multiplechoice answers

Regards,
Koen


>Hi Koen!
>report is very old question in my case (as word,excel...).dont use them there is a while.
>
>this is a small code demo how to answer your question.
>the code below creates a report for a given cursor where there is a small bullet at the first field.the bullet is chr(149)
>char.
>after preview the report can modify it in first field (black bullet).rightclick to access properties.
>can change the fontname,fontbold, forecolor (red for ex.)---see the photo attached.
>can filter with any valid condtions.
>
>CLOSE TABLES all
>set safe off
>sele cust_id,company,contact ,maxordamt from home(1)+"samples\data\customer" into cursor ycurs Readwrite
>Alter Table ycurs Add Column bul c(3)
>
>*make bul field  at the first field 
>sele bul,cust_id,company,contact,maxordamt from ycurs into cursor zcurs readwrite
>use in select("ycurs")
>
>sele zcurs
>scan for  maxordamt<=9000
>repl bul with spac(2)+chr(149)
>endscan
>*brow
>
>CREATE REPORT yrepo FROM (ALIAS())
>REPORT FORM yrepo PREVIEW 
>
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform