Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Report with variable num of columns
Message
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00873099
Message ID:
00873331
Views:
25
Thank you, Sergey. I will check out the link you suggested.

>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
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
Previous
Reply
Map
View

Click here to load this message in the networking platform