Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Bullet list in VFP Report
Message
De
03/02/2016 20:57:15
 
 
À
03/02/2016 14:55:43
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:
01630758
Vues:
143
I'm probably misunderstanding your question, and likely grossly oversimplifying, but if the report is a pattern similar to that of a multiple choice quiz, where there is a question text and a list of possible answers listed below (and the number of choices is limited in quantity, for example no more than five choices), then one (though somewhat kludgy) way would be to have:
* detail band would consist of a text box for question text and bullets and text box for each of the answer items (up to the maximum number).
* The text boxes are set to expand with contents
* The bullets and the corresponding text boxes are set to float relative to top of band, and the Print When expression set so that prints only when the item applies.
* Above each of the bullet and corresponding text, place a line that spans the width of the paired items, set the line to float relative to top of band. The Print When expression is set to .F. so that it isn't printed.
As a text box expands, it "pushes" the items (that are set to float) down the page, and the line above the bullet and corresponding text assures that the bullet and text are "pushed" together.

>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