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
>