Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Bullet list in VFP Report
Message
 
À
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:
01630751
Vues:
74
Hi Koen,
I have not read the entire thread, so I apologize if I missed something. Here is my suggestion:
Work with two related tables/cursors:
Cursor1 for Questions, each record would store the question text, plus one additional field for QuestionID, Assign a unique ID to each question.
Cursor2 for Detail Options, each record would store the text for one detail option, plus one additional field for QuestionID. Assign the corresponding QuestionID to each detail/option record.
Index Cursor2 on QuestionID
Select Cursor1
Set relation to QuestionID into Cursor2
Set skip to Cursor2
*
Design your report with a Data Grouping band on Cursor1.QuestionID. In that Group header band, drop the question text field from Cursor1 (make sure you set it to Stretch with overflow...)
In the Detail band drop the detail/option text field from Cursor2 (again, make sure it is set to Stretch with overflow)
*
When run, it should look like the attached.

HTH



>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
Répondre
Fil
Voir

Click here to load this message in the networking platform