Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Report with variable num of columns
Message
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
00873099
Message ID:
00873332
Vues:
25
Nadya,
Thank you for your suggestion. But this report has to be done in VFP.

>How about creating it in Excel? If you want, I can send you some code, which I got from Daniel Gramunt...
>
>>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform