Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Bullet list in VFP Report
Message
De
04/02/2016 02:48:55
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Allemagne
 
 
À
04/02/2016 02:04:44
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:
01630785
Vues:
76
High Koen,

I still think that creating a second cursor with the items, bound it with with set relations to your cursor might be fast and not that tricky with the report.

you have a fixed number of possible items, as I understand, I guess some fields of your table?
something like that will do:
*assuming vPk  identifies the records in your table, cField1 to cField3 are the items.
 SELECT;
  Cur1.vPK,;
  1 as FieldN,;
  Cur1.cField1 as cField;
  FROM SourceTable AS Cur1;
  INTO CurHelp;
  WHERE !EMPTY(Cur1.cField1);
  ORDER BY vPK,FieldN
UNION;
 SELECT;
  Cur2.vPK,;
  2 as FieldN,;
  Cur2.cField2 as cField;
  FROM SourceTable AS Cur2;
  INTO curHelp;
  WHERE !EMPTY(Cur2.cField2);
UNION;
 SELECT;
  Cur3.vPK,;
  3 as FieldN,;
  Cur3.cField3 as cField;
  FROM SourceTable AS Cur3;
  INTO CurHelp;
  WHERE !EMPTY(Cur3.cField3)

INDEX ON vPK TAG vPK
SELECT SourceTable
SET RELATION TO vPK INTO curHelp

REPORT FORM ...
SET RELATION TO
USE IN curHelp
The report can use two detail bands, where the second detail band is the helper with the items. Then positioning the stuff is simple. No need to supress unused items - the select will filter them out anyway.

Lutz
>Hi Naoto,
>
>Have implented the lines, however the 'bullets' are not pushed down. What am I missing here?
>Lines are set .F. in print when and fixed relative to top of band
>Regards,
>Koen
>
>
>>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.
>>
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord

Weeks of programming can save you hours of planning.

Off

There is no place like [::1]
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform