Dmitry,
You may try to build report dynamically using GenRepoX
http://fox.wikis.com/wc.dll?Wiki~GenRepoX~VFP or Doug Hennig's
http://downloads.stonefield.com/pub/repobj.html.
>I need to create a report from the following cursor:
>
>
>EMPLOYEE C, 10
>CAT1HRS, N, 6,2
>CAT2HRS, N, 6,2
>CAT3HRS, N, 6,0
>
>.. and so on.
>
>of the following, sample, layout:
>
>
>EMPLOYEE CAT1HRS CAT2HRS CAT3HRS ..
>John 9.00 9.00 7.5
>Paul 1.00 2.00 0.00
>
>
>The trick for me is that number of columns (fields CAT#HRS) is variable, determined at the time of report creation.
>
>So far, the only thing I thought of is to create the report with some upsize number of columns and then hide those that won't be used. One problem I see with this approach is if number columns is greater than fit on a page of paper.
>
>If you know of any ways of doing this report more efficiently, please let me know.
>
>TIA
--sb--