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:
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.
OffThere is no place like [::1]